CSV to Dashboard Summary
Pricing
from $6.50 / 1,000 item processeds
Go to Apify Store
CSV to Dashboard Summary
Turn CSV/tabular data into KPI summaries, dashboard-ready metrics, and insight reports.
CSV to Dashboard Summary
Pricing
from $6.50 / 1,000 item processeds
Turn CSV/tabular data into KPI summaries, dashboard-ready metrics, and insight reports.
You can access the CSV to Dashboard Summary programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in Integrations settings in Apify Console.
{ "openapi": "3.0.1", "info": { "version": "1.0", "x-build-id": "tb2HEiBrNGh3JcclP" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/junipr~csv-to-dashboard-summary/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-junipr-csv-to-dashboard-summary", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } }, "/acts/junipr~csv-to-dashboard-summary/runs": { "post": { "operationId": "runs-sync-junipr-csv-to-dashboard-summary", "x-openai-isConsequential": false, "summary": "Executes an Actor and returns information about the initiated run in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/runsResponseSchema" } } } } } } }, "/acts/junipr~csv-to-dashboard-summary/run-sync": { "post": { "operationId": "run-sync-junipr-csv-to-dashboard-summary", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } } }, "components": { "schemas": { "inputSchema": { "type": "object", "properties": { "targets": { "title": "Data Sources", "type": "array", "description": "One or more sources containing CSV text, inline records, or a public CSV URL.", "items": { "type": "object" }, "default": [ { "sourceId": "example-sales", "csvText": "region,leads,revenue,conversionRate\nNorth,120,184000,0.18\nSouth,90,93000,0.11\nWest,140,212000,0.21" } ] }, "records": { "title": "Inline Records", "type": "array", "description": "Tabular records for one source.", "items": { "type": "object" }, "default": [] }, "csvText": { "title": "CSV Text", "type": "string", "description": "CSV content for one source. Quoted commas and embedded newlines are supported.", "default": "" }, "sourceId": { "title": "Source ID", "type": "string", "description": "Stable identifier for a single top-level source.", "default": "table" }, "sourceUrl": { "title": "Public CSV URL", "type": "string", "description": "Optional public HTTP(S) CSV URL. Private, credentialed, and redirecting URLs are rejected.", "default": "" }, "fetchUrls": { "title": "Fetch Public URLs", "type": "boolean", "description": "Retrieve sourceUrl values with DNS, timeout, redirect, and response-size safeguards.", "default": false }, "delimiter": { "title": "Delimiter", "type": "string", "description": "Single-character CSV delimiter.", "default": "," }, "metrics": { "title": "Metric Columns", "type": "array", "description": "Numeric columns to summarize. Leave empty to infer them.", "items": { "type": "string" }, "default": [] }, "groupBy": { "title": "Group By Column", "type": "string", "description": "Optional categorical column for per-group metrics.", "default": "" }, "aggregation": { "title": "Primary Aggregation", "enum": [ "sum", "average", "median", "minimum", "maximum", "count" ], "type": "string", "description": "Statistic placed in metricValue.", "default": "average" }, "maxGroups": { "title": "Maximum Groups", "minimum": 1, "maximum": 100, "type": "integer", "description": "Maximum group values summarized per source.", "default": 25 }, "maxTargets": { "title": "Maximum Sources", "minimum": 1, "maximum": 20, "type": "integer", "description": "Maximum sources processed per run.", "default": 2 }, "maxItems": { "title": "Maximum Rows Per Source", "minimum": 1, "maximum": 10000, "type": "integer", "description": "Hard processing and billing cap per source.", "default": 500 }, "maxTextBytes": { "title": "Maximum Download Bytes", "minimum": 1000, "maximum": 2000000, "type": "integer", "description": "Maximum bytes accepted from each public CSV URL.", "default": 500000 }, "fetchTimeoutMs": { "title": "Fetch Timeout", "minimum": 1000, "maximum": 30000, "type": "integer", "description": "Maximum milliseconds for each public CSV request.", "default": 10000 }, "includeReport": { "title": "Create Report Files", "type": "boolean", "description": "Write metrics JSON/CSV, summary, and Markdown report files.", "default": true }, "dryRun": { "title": "Dry Run", "type": "boolean", "description": "Validate input without paid events or dataset output.", "default": false }, "debug": { "title": "Debug Logs", "type": "boolean", "description": "Enable detailed logs.", "default": false } } }, "runsResponseSchema": { "type": "object", "properties": { "data": { "type": "object", "properties": { "id": { "type": "string" }, "actId": { "type": "string" }, "userId": { "type": "string" }, "startedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "finishedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "status": { "type": "string", "example": "READY" }, "meta": { "type": "object", "properties": { "origin": { "type": "string", "example": "API" }, "userAgent": { "type": "string" } } }, "stats": { "type": "object", "properties": { "inputBodyLen": { "type": "integer", "example": 2000 }, "rebootCount": { "type": "integer", "example": 0 }, "restartCount": { "type": "integer", "example": 0 }, "resurrectCount": { "type": "integer", "example": 0 }, "computeUnits": { "type": "integer", "example": 0 } } }, "options": { "type": "object", "properties": { "build": { "type": "string", "example": "latest" }, "timeoutSecs": { "type": "integer", "example": 300 }, "memoryMbytes": { "type": "integer", "example": 1024 }, "diskMbytes": { "type": "integer", "example": 2048 } } }, "buildId": { "type": "string" }, "defaultKeyValueStoreId": { "type": "string" }, "defaultDatasetId": { "type": "string" }, "defaultRequestQueueId": { "type": "string" }, "buildNumber": { "type": "string", "example": "1.0.0" }, "containerUrl": { "type": "string" }, "usage": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "integer", "example": 1 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } }, "usageTotalUsd": { "type": "number", "example": 0.00005 }, "usageUsd": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "number", "example": 0.00005 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } } } } } } } }}OpenAPI is a standard for designing and describing RESTful APIs, allowing developers to define API structure, endpoints, and data formats in a machine-readable way. It simplifies API development, integration, and documentation.
OpenAPI is effective when used with AI agents and GPTs by standardizing how these systems interact with various APIs, for reliable integrations and efficient communication.
By defining machine-readable API specifications, OpenAPI allows AI models like GPTs to understand and use varied data sources, improving accuracy. This accelerates development, reduces errors, and provides context-aware responses, making OpenAPI a core component for AI applications.
You can download the OpenAPI definitions for CSV to Dashboard Summary from the options below:
If you’d like to learn more about how OpenAPI powers GPTs, read our blog post.
You can also check out our other API clients: