Query API
The following article covers Sigma’s developer API for downloading queries. This can be used if you have a queryId from a previous call to Sigma’s workbook export endpoint.
Summary of Content
Endpoint
Download a Query Result
Permissions
Parameters
cURL Request
Response
Example
Related Resources
Endpoint
GET /v2/query/{queryId}/download
Downloads the result of a successful query.
Try it in Swagger
Download a Query Result
Downloads the result of a successful query.
GET /v2/query/{queryId}/download
As within the Sigma app, there is a 1 million row download limit for CSV/XLSX types. To download more rows, you can batch your requests in up to 1 million row chunks, or consider using another export method such as exporting to Cloud Storage which has a 5 GB limit.
It can take an arbitrary amount of time for our system to process the data into a file and have it ready to be downloaded. While the file is being processed, requests to the query download endpoint will respond with the status code 204 No Content.
For security and privacy reasons, by default the queryId expires 1 hour after your export request has been processed by our system and the file has become ready for download.
If you call this API with an expired "queryId," you will receive a status code 404 Not Found with the error:
The query download has expired. For security & privacy reasons, the Exports are retained for one hour. A new queryId can be generated using the Workbook Export API.
If the "queryId" has expired, you can generate a new "queryId" using the Workbook Export API.
(This default expiration time can be overridden for up to 6 hours by setting the optional request parameter "resultsValidityTimeMs" in the export request.)
Permissions
If you encounter a permission error for the given endpoint, check with your organization Admin to verify your account type and permissions associated with your API token.
Parameters
None
cURL Request
curl --location --request GET 'https://api.sigmacomputing.com/v2/query/{queryId}/download' \
--header 'Authorization: Bearer {access_token}' \
--header 'Content-Type: application/json' \
Response
The file containing the requested downloaded data. The file type of the response varies depending on the query requested.
If you call this API and the requested file is still being processed, you will receive a status code 204 No Content.
If you call this API with an expired "queryId," you will receive a status code 404 Not Found with the error message:
The query download has expired. For Security & privacy reasons, the Exports are retained only for one hour.
A new queryId can be generated using the Workbook Export API.
Example
Example Request:
curl --location --request GET 'https://api.sigmacomputing.com/v2/query/{queryId}/download' \
--header 'Authorization: Bearer {access_token}' \
--header 'Content-Type: application/json' \
Example Response:
The response will vary depending on the query requested. For example, you will receive either a PDF, PNG, CSV, or XLSX file.
Related Resources
Get Started with Sigma's API
Create an API Token and Client Id
Identify Unique Ids in Sigma
Workbook Export API