The Scheduled Query object

Attributes

• id string Unique identifier for the object.
• data _ load _ time timestamp When the query was run, Sigma contained a snapshot of your Stripe data at this time.
• file nullable object The file object representing the results of the query.
• sql string SQL for the query.
• status string The query’s execution status, which will be completed for successful runs, and canceled, failed, or timed_out otherwise.
• title string Title of the query.

More attributes

• object string, value is "scheduled_query_run"
• created timestamp
• error nullable object
• livemode boolean
• result _ available _ until timestamp

The Scheduled Query object

Retrieve a scheduled query run

GET / v1 / sigma / scheduled_query_runs /:id

Retrieves the details of an scheduled query run.

Parameters

No parameters.

Returns

Returns the scheduled query run object if a valid identifier was provided.

Response

List all scheduled query runs

GET / v1 / sigma / scheduled_query_runs

Returns a list of scheduled query runs.

Parameters

No parameters.

More parameters

• ending _ before string
• limit integer
• starting _ after string

Returns

A paginated list of all scheduled query runs.

Response