Attributes
- idstring
Unique identifier for the object.
- data_
load_ timetimestamp When the query was run, Sigma contained a snapshot of your Stripe data at this time.
- filenullable object
The file object representing the results of the query.
- sqlstring
SQL for the query.
- statusstring
The query’s execution status, which will be
completed
for successful runs, andcanceled
,failed
, ortimed_
otherwise.out - titlestring
Title of the query.
More attributes
- objectstring
- createdtimestamp
- errornullable object
- livemodeboolean
- result_
available_ untiltimestamp
{ "object": "list", "url": "/v1/sigma/scheduled_query_runs", "has_more": false, "data": [ { "id": "sqr_1NpIuH2eZvKYlo2CP72f3rLR", "object": "scheduled_query_run", "created": 1694472517, "data_load_time": 1694217600, "file": { "id": "file_1BE4yZ2eZvKYlo2C9MeXgqcB", "object": "file", "created": 1508284799, "expires_at": null, "filename": "path", "links": { "object": "list", "data": [], "has_more": false, "url": "/v1/file_links?file=file_1BE4yZ2eZvKYlo2C9MeXgqcB" }, "purpose": "sigma_scheduled_query", "size": 500, "title": null, "type": "csv", "url": "https://files.stripe.com/v1/files/file_1BE4yZ2eZvKYlo2C9MeXgqcB/contents" }, "livemode": false, "result_available_until": 1726012800, "sql": "SELECT count(*) from charges", "status": "completed", "title": "Count all charges" } ]}
Retrieves the details of an scheduled query run.
Parameters
No parameters.
Returns
Returns the scheduled query run object if a valid identifier was provided.
{ "object": "list", "url": "/v1/sigma/scheduled_query_runs", "has_more": false, "data": [ { "id": "sqr_1NpIuH2eZvKYlo2CP72f3rLR", "object": "scheduled_query_run", "created": 1694472517, "data_load_time": 1694217600, "file": { "id": "file_1BE4yZ2eZvKYlo2C9MeXgqcB", "object": "file", "created": 1508284799, "expires_at": null, "filename": "path", "links": { "object": "list", "data": [], "has_more": false, "url": "/v1/file_links?file=file_1BE4yZ2eZvKYlo2C9MeXgqcB" }, "purpose": "sigma_scheduled_query", "size": 500, "title": null, "type": "csv", "url": "https://files.stripe.com/v1/files/file_1BE4yZ2eZvKYlo2C9MeXgqcB/contents" }, "livemode": false, "result_available_until": 1726012800, "sql": "SELECT count(*) from charges", "status": "completed", "title": "Count all charges" } ]}
Returns a list of scheduled query runs.
Parameters
No parameters.
More parameters
- ending_
beforestring - limitinteger
- starting_
afterstring
Returns
A paginated list of all scheduled query runs.
{ "object": "list", "url": "/v1/sigma/scheduled_query_runs", "has_more": false, "data": [ { "object": "list", "url": "/v1/sigma/scheduled_query_runs", "has_more": false, "data": [ { "id": "sqr_1NpIuH2eZvKYlo2CP72f3rLR", "object": "scheduled_query_run", "created": 1694472517, "data_load_time": 1694217600, "file": { "id": "file_1BE4yZ2eZvKYlo2C9MeXgqcB", "object": "file", "created": 1508284799, "expires_at": null, "filename": "path", "links": { "object": "list", "data": [], "has_more": false, "url": "/v1/file_links?file=file_1BE4yZ2eZvKYlo2C9MeXgqcB" }, "purpose": "sigma_scheduled_query", "size": 500, "title": null, "type": "csv", "url": "https://files.stripe.com/v1/files/file_1BE4yZ2eZvKYlo2C9MeXgqcB/contents" }, "livemode": false, "result_available_until": 1726012800, "sql": "SELECT count(*) from charges", "status": "completed", "title": "Count all charges" } ] } ]}
Represents an ad-hoc execution of a Sigma query via the API
The Report Run object represents an instance of a report type generated with specific run parameters. Once the object is created, Stripe begins processing the report. When the report has finished running, it will give you a reference to a file where you can retrieve your results. For an overview, see API Access to Reports.
Note that certain report types can only be run based on your live-mode data (not test-mode data), and will error when queried without a live-mode API key.