SigmaScheduledQueryRunList

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://raw.githubusercontent.com/api-evangelist/stripe/main/json-schema/stripe-sigma-scheduled-query-run-list-schema.json",
  "title": "SigmaScheduledQueryRunList",
  "x-generated": "2026-10-12",
  "x-method": "derived",
  "x-generator": "derive-json-schema.py",
  "x-source": "openapi/stripe-sigma-api-openapi.yml#/components/schemas/SigmaScheduledQueryRunList",
  "type": "object",
  "required": [
    "data",
    "has_more",
    "object",
    "url"
  ],
  "properties": {
    "data": {
      "items": {
        "$ref": "#/$defs/scheduled_query_run"
      },
      "type": "array"
    },
    "has_more": {
      "description": "True if this list has another page of items after this one that can be fetched.",
      "type": "boolean"
    },
    "object": {
      "description": "String representing the object's type. Objects of the same type share the same value. Always has the value `list`.",
      "enum": [
        "list"
      ],
      "type": "string"
    },
    "url": {
      "description": "The URL where this list can be accessed.",
      "maxLength": 5000,
      "pattern": "^/v1/sigma/scheduled_query_runs",
      "type": "string"
    }
  },
  "$defs": {
    "file": {
      "type": "object",
      "description": "Referenced by this document but never defined in it. API Evangelist added this empty placeholder so the document resolves; the shape is unknown and is NOT a claim about the API.",
      "x-ae-placeholder": true
    },
    "scheduled_query_run": {
      "description": "If you have [scheduled a Sigma query](https://stripe.com/docs/sigma/scheduled-queries), you'll\nreceive a `sigma.scheduled_query_run.created` webhook each time the query\nruns. The webhook contains a `ScheduledQueryRun` object, which you can use to\nretrieve the query results.",
      "properties": {
        "created": {
          "description": "Time at which the object was created. Measured in seconds since the Unix epoch.",
          "format": "unix-time",
          "type": "integer"
        },
        "data_load_time": {
          "description": "When the query was run, Sigma contained a snapshot of your Stripe data at this time.",
          "format": "unix-time",
          "type": "integer"
        },
        "error": {
          "$ref": "#/$defs/sigma_scheduled_query_run_error"
        },
        "file": {
          "anyOf": [
            {
              "$ref": "#/$defs/file"
            }
          ],
          "description": "The file object representing the results of the query."
        },
        "id": {
          "description": "Unique identifier for the object.",
          "maxLength": 5000,
          "type": "string"
        },
        "livemode": {
          "description": "Has the value `true` if the object exists in live mode or the value `false` if the object exists in test mode.",
          "type": "boolean"
        },
        "object": {
          "description": "String representing the object's type. Objects of the same type share the same value.",
          "enum": [
            "scheduled_query_run"
          ],
          "type": "string"
        },
        "result_available_until": {
          "description": "Time at which the result expires and is no longer available for download.",
          "format": "unix-time",
          "type": "integer"
        },
        "sql": {
          "description": "SQL for the query.",
          "maxLength": 100000,
          "type": "string"
        },
        "status": {
          "description": "The query's execution status, which will be `completed` for successful runs, and `canceled`, `failed`, or `timed_out` otherwise.",
          "maxLength": 5000,
          "type": "string"
        },
        "title": {
          "description": "Title of the query.",
          "maxLength": 5000,
          "type": "string"
        }
      },
      "required": [
        "created",
        "data_load_time",
        "id",
        "livemode",
        "object",
        "result_available_until",
        "sql",
        "status",
        "title"
      ],
      "title": "ScheduledQueryRun",
      "type": "object",
      "x-expandableFields": [
        "error",
        "file"
      ],
      "x-resourceId": "scheduled_query_run"
    },
    "sigma_scheduled_query_run_error": {
      "type": "object",
      "description": "Referenced by this document but never defined in it. API Evangelist added this empty placeholder so the document resolves; the shape is unknown and is NOT a claim about the API.",
      "x-ae-placeholder": true
    }
  }
}