The Query Run object 

Attributes

  • idstring

    Unique identifier for the object.

  • objectstring

    String representing the object’s type. Objects of the same type share the same value.

  • createdtimestamp

    Time at which the object was created. Measured in seconds since the Unix epoch.

  • finalized_atnullable timestamp

    Timestamp describing when a Query run reached the terminal status.

  • livemodeboolean

    Has the value true if the object exists in live mode or the value false if the object exists in test mode.

  • sqlstring

    The sql statement that is run.

  • statusnullable enum

    The status of the query run. Possible values are succeeded, pending, running, and failed.

The Query Run object
{
"id": "qry_0R9c43589O8STxCGUZXU3I6T",
"object": "sigma.sigma_query_run",
"created": 1743641728,
"error": null,
"finalized_at": 1743641733,
"livemode": true,
"result": {
"file": "file_0R9c49589O8KAxR9askNs8JQ"
},
"sql": "SELECT * FROM balance_transactions LIMIT 4",
"status": "completed"
}

Create a Query Run 

Create a query run to be executed.

Parameters

  • from_saved_querystring

    The unique id of a previously saved query to be run. Note that only one of sql or from_saved_query should be provided.

  • sqlstring

    The sql statement to run. This should be a valid Trino SQL statement that can be run in Sigma. Note that only one of sql or from_saved_query should be provided.

Returns

Returns a Query Run object.

POST /v1/sigma/query_runs
cURL
curl https://api.stripe.com/v1/sigma/query_runs \
-u "sk_test_BQokikJ...2HlWgH4olfQ2sk_test_BQokikJOvBiI2HlWgH4olfQ2:" \
--data-urlencode sql="SELECT * FROM balance_transactions LIMIT 4"
Response
{
"id": "qry_0R9c43589O8STxCGUZXU3I6T",
"object": "sigma.sigma_query_run",
"created": 1743641728,
"error": null,
"finalized_at": 1743641733,
"livemode": true,
"result": {
"file": "file_0R9c49589O8KAxR9askNs8JQ"
},
"sql": "SELECT * FROM balance_transactions LIMIT 5",
"status": "completed"
}

Retrieve a Query Run 

Retrieve the status of Query Run

Parameters

  • idstringRequired

    The id of the query run to retrieve. This should be a valid id that was previously created.

Returns

Returns the specified Query Run object.

GET /v1/sigma/query_runs/:id
cURL
curl https://api.stripe.com/v1/sigma/query_runs/qfl_0R46kn589O8KAxCGtbTjfolP \
-u "sk_test_BQokikJ...2HlWgH4olfQ2sk_test_BQokikJOvBiI2HlWgH4olfQ2:"
Response
{
"id": "qfl_0R46kn589O8KAxCGtbTjfolP",
"object": "sigma.sigma_api_query",
"created": 1742329729,
"livemode": true,
"sql": "SELECT * FROM balance_transactions LIMIT 5",
"name": "Select balance transactions"
}

Report Runs 

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.

Report Types 

The Report Type resource corresponds to a particular type of report, such as the “Activity summary” or “Itemized payouts” reports. These objects are identified by an ID belonging to a set of enumerated values. See API Access to Reports documentation for those Report Type IDs, along with required and optional parameters.

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.