---
title: "List all scheduled query runs"
method: GET
path: "/v1/sigma/scheduled_query_runs"
---

# List all scheduled query runs

`GET /v1/sigma/scheduled_query_runs`

Returns a list of scheduled query runs.

## Query parameters

- `ending_before` string
- `expand` string[]
- `limit` integer
- `starting_after` string

## Response `200`

Successful response.

- object
  - `data` ScheduledQueryRun[], required
    - `created` integer, required — Time at which the object was created. Measured in seconds since the Unix epoch.
    - `data_load_time` integer, required — When the query was run, Sigma contained a snapshot of your Stripe data at this time.
    - `error` SigmaScheduledQueryRunError
      - `message` string, required — Information about the run failure.
    - `file` File — This object represents files hosted on Stripe's servers. You can upload files with the [create file](https://api.stripe.com#create_file) request (for example, when uploading dispute evidence). Stripe also creates files independently (for example, the results of a [Sigma scheduled query](#scheduled_queries)). Related guide: [File upload guide](https://docs.stripe.com/file-upload)
      - `created` integer, required — Time at which the object was created. Measured in seconds since the Unix epoch.
      - `expires_at` integer, nullable — The file expires and isn't available at this time in epoch seconds.
      - `filename` string, nullable — The suitable name for saving the file to a filesystem.
      - `id` string, required — Unique identifier for the object.
      - `links` object, nullable — A list of [file links](https://api.stripe.com#file_links) that point at this file.
        - `data` FileLink[], required — Details about each object.
          - `created` integer, required — Time at which the object was created. Measured in seconds since the Unix epoch.
          - `expired` boolean, required — Returns if the link is already expired.
          - `expires_at` integer, nullable — Time that the link expires.
          - `file` union, required — The file object this link points to.
            - string
            - File — recursive
          - `id` string, required — Unique identifier for the object.
          - `livemode` boolean, required — If the object exists in live mode, the value is `true`. If the object exists in test mode, the value is `false`.
          - `metadata` object, required — Set of [key-value pairs](https://docs.stripe.com/api/metadata) that you can attach to an object. This can be useful for storing additional information about the object in a structured format.
          - `object` 'file_link', required — String representing the object's type. Objects of the same type share the same value.
          - `url` string, nullable — The publicly accessible URL to download the file.
        - `has_more` boolean, required — True if this list has another page of items after this one that can be fetched.
        - `object` 'list', required — String representing the object's type. Objects of the same type share the same value. Always has the value `list`.
        - `url` string, required — The URL where this list can be accessed.
      - `object` 'file', required — String representing the object's type. Objects of the same type share the same value.
      - `purpose` 'account_requirement' | 'additional_verification' | 'business_icon' | 'business_logo' | 'customer_signature' | 'dispute_evidence' | 'document_provider_identity_document' | 'finance_report_run' | 'financial_account_statement' | 'identity_document' | 'identity_document_downloadable' | 'issuing_regulatory_reporting' | 'pci_document' | 'platform_terms_of_service' | 'selfie' | 'sigma_scheduled_query' | 'tax_document_user_upload' | 'terminal_android_apk' | 'terminal_reader_splashscreen' | 'terminal_wifi_certificate' | 'terminal_wifi_private_key', required — The [purpose](https://docs.stripe.com/file-upload#uploading-a-file) of the uploaded file.
      - `size` integer, required — The size of the file object in bytes.
      - `title` string, nullable — A suitable title for the document.
      - `type` string, nullable — The returned file type (for example, `csv`, `pdf`, `jpg`, or `png`).
      - `url` string, nullable — Use your live secret API key to download the file from this URL.
    - `id` string, required — Unique identifier for the object.
    - `livemode` boolean, required — If the object exists in live mode, the value is `true`. If the object exists in test mode, the value is `false`.
    - `object` 'scheduled_query_run', required — String representing the object's type. Objects of the same type share the same value.
    - `result_available_until` integer, required — Time at which the result expires and is no longer available for download.
    - `sql` string, required — SQL for the query.
    - `status` string, required — The query's execution status, which will be `completed` for successful runs, and `canceled`, `failed`, or `timed_out` otherwise.
    - `title` string, required — Title of the query.
  - `has_more` boolean, required — True if this list has another page of items after this one that can be fetched.
  - `object` 'list', required — String representing the object's type. Objects of the same type share the same value. Always has the value `list`.
  - `url` string, required — The URL where this list can be accessed.

## Other responses

- `default` — Error response.

---

[API](https://skmtc.net/stripe/apis/stripe-api-2.md) · [All operations](https://skmtc.net/stripe/apis/stripe-api-2/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/stripe/stripe-api-2/versions/3653ad45bbec/schema)