---
title: "List task runs"
method: GET
path: "/task_runs"
tags: ["Task Runs"]
---

# List task runs

`GET /task_runs`

Retrieve a paginated list of [task runs](/docs/core-concepts/tasks/task-runs) for the workspace linked to the API key.

<Note>
  `time_from` and `time_to` are optional. If neither is provided, the API returns the last 7 days of data. If both are provided, the maximum time range per request is 7 days. `time_from` cannot be earlier than 2023-01-01.
</Note>

Filter by multiple statuses, integrations, pipeline IDs, or task run IDs using comma-separated values. For example, `status=SUCCEEDED,FAILED&integration=HTTP,SNOWFLAKE` returns task runs matching either status and either integration.

## Query parameters

- `page` integer
- `page_size` integer
- `time_from` string, date-time, nullable
- `time_to` string, date-time, nullable
- `pipeline_ids` string
- `status` string
- `integration` string
- `task_run_ids` string

## Response `200`

Successful response.

- PaginatedResponseTaskRunResponse
  - `page` integer, required
  - `pageSize` integer, required
  - `total` integer, required
  - `results` TaskRunResponse[], required
    - `id` string, uuid4, required
    - `pipelineRunId` string, uuid4, required
    - `taskName` string, required
    - `taskId` string, required
    - `accountId` string, uuid4, required
    - `pipelineId` string, uuid4, required
    - `integration` 'AIRBYTE_CLOUD' | 'AIRBYTE_SERVER' | 'AIRFLOW' | 'ARCH' | 'ALTERYX_SERVER' | 'AWS_EC2' | 'AWS_ECS' | 'AWS_EMR' | 'AWS_EKS' | 'AWS_FIREHOSE' | 'AWS_GLUE' | 'AWS_LAMBDA' | 'AWS_RDS' | 'AWS_REDSHIFT' | 'AWS_S3' | 'AWS_BEDROCK' | 'AWS_SAGEMAKER' | 'AWS_SECRETS_MANAGER' | 'AZURE' | 'AZURE_CONTAINER_APPS' | 'AZURE_DATA_FACTORY' | 'AZURE_DATA_LAKE_STORAGE' | 'AZURE_KEY_VAULT' | 'AZURE_KUBERNETES_SERVICE' | 'AZURE_LOGIC_APPS' | 'AZURE_SYNAPSE_ANALYTICS' | 'AZURE_VM' | 'BAUPLAN' | 'BOOMI' | 'CDATA' | 'CENSUS' | 'CLAUDE' | 'CLICKHOUSE' | 'COALESCE' | 'COUNT' | 'DATADOG' | 'DATABRICKS' | 'DATAPROC' | 'DATAZEN' | 'DBT' | 'DBT_CORE' | 'DLT' | 'DOMO' | 'DUCKDB' | 'EMAIL' | 'ESTUARY' | 'ETLEAP' | 'FABRIC' | 'FABRIC_SYNAPSE' | 'FIVETRAN' | 'FORTRA' | 'GCP_BIG_QUERY' | 'GCP_CLOUD_RUN' | 'GCP_CLOUD_FUNCTIONS' | 'GCP_CLOUD_STORAGE' | 'GCP_DATAFLOW' | 'GCP_DATAFORM' | 'GCP_DATASTREAM' | 'GCP_LOOKER' | 'GKE' | 'GITHUB_ACTIONS' | 'GOOGLE_CLOUD' | 'HEVO' | 'HEX' | 'HIGHTOUCH' | 'HTTP' | 'INFORMATICA_IICS' | 'INFORMATICA_POWERCENTER' | 'KAFKA' | 'KEBOOLA' | 'KLEENE' | 'LIGHTDASH' | 'LINUX_SSH' | 'MATILLION' | 'MATILLION_ETL' | 'METAPLANE' | 'MICROSOFT_TEAMS' | 'MICROSTRATEGY' | 'MOTHERDUCK' | 'NIMBLE' | 'OMNI' | 'OPEN_AI' | 'ORCHESTRA' | 'PARADIME' | 'PAGER_DUTY' | 'PINECONE' | 'PORTABLE' | 'POSTGRES' | 'POWER_AUTOMATE' | 'POWER_BI' | 'PREFECT_CLOUD' | 'PYTHON' | 'QLIK' | 'QLIK_REPLICATE' | 'RENDER' | 'RIVERY' | 'RUDDERSTACK' | 'SAP' | 'SFTP' | 'SIGMA' | 'SISENSE' | 'SLACK' | 'SNOWFLAKE' | 'SNOWPLOW' | 'SODA' | 'SQL_MESH' | 'SQL_SERVER' | 'STITCH' | 'STREAMKAP' | 'TABLEAU_CLOUD' | 'TALEND_CLOUD' | 'THOUGHTSPOT' | 'TOBIKO_CLOUD' | 'WEAVIATE' | 'WEBHOOK' | 'WELD' | 'WINDOWS_SSH', required
    - `integrationJob` 'ACA_RUN_JOB' | 'ADF_PIPELINE_RUN' | 'ADLS_SENSOR' | 'AIRBYTE_CLOUD_JOB' | 'AIRBYTE_SERVER_JOB' | 'AIRFLOW_RUN_DAG' | 'AKS_RUN_JOB' | 'ALTERYX_SERVER_TRIGGER_WORKFLOW' | 'APPROVAL' | 'ARCH_SYNC_PIPELINE' | 'AWS_EC2_SSM_RUN_SCRIPT' | 'AWS_ECS_RUN_TASK' | 'AWS_EKS_RUN_JOB' | 'AWS_EMR_RUN_JOB' | 'AWS_FIREHOSE_CHECK_STREAM' | 'AWS_GLUE_RUN_JOB' | 'AWS_LAMBDA_EXECUTE_ASYNC_FUNCTION' | 'AWS_REDSHIFT_EXECUTE_STATEMENT' | 'AWS_BEDROCK_INVOKE_MODEL' | 'AWS_SAGEMAKER_DEPLOY_MODEL' | 'AWS_SAGEMAKER_TRAIN_MODEL' | 'AZURE_LOGIC_APPS_RUN_WORKFLOW' | 'AZURE_VM_RUN_COMMAND' | 'BAUPLAN_DATA_QUALITY_TEST' | 'BAUPLAN_EXECUTE_PIPELINE' | 'BOOMI_EXECUTE_PROCESS' | 'CDATA_SYNC_JOB' | 'CENSUS_SYNC' | 'CLAUDE_CHAT' | 'CLICKHOUSE_RUN_QUERY' | 'CLICKHOUSE_RUN_TEST' | 'COALESCE_RUNJOB' | 'DATA_RECONCILIATION_MANUAL_QUERY' | 'DATA_RECONCILIATION_CURSOR_FIELD' | 'DATABRICKS_EXECUTE_STATEMENT' | 'DATABRICKS_ONE_TIME_RUN' | 'DATABRICKS_RUN_TEST' | 'DATABRICKS_RUN_WORKFLOW' | 'DATAPROC_RUN_JOB' | 'DATAZEN_CHECK_JOB' | 'DATAZEN_RUN_JOB' | 'DBT_CORE_EXECUTE' | 'DBT_RUNJOB' | 'DLT_EXECUTE_JOB' | 'DUCKDB_EXECUTE_QUERY' | 'ESTUARY_CHECK_FLOW' | 'ETLEAP_REFRESH_PIPELINE' | 'FABRIC_RUN_DATA_PIPELINE' | 'FABRIC_RUN_NOTEBOOK' | 'FABRIC_SYNAPSE_RUN_QUERY' | 'FABRIC_SYNAPSE_RUN_DQ_TEST' | 'FIVETRAN_SYNC_ALL' | 'GCP_BQ_RUN_QUERY_JOB' | 'GCP_BQ_RUN_SCHEDULED_QUERY_JOB' | 'GCP_BQ_RUN_TEST' | 'GCP_CLOUD_RUN_EXECUTE_JOB' | 'GCP_CLOUD_FUNCTIONS_EXECUTE_ASYNC_FUNCTION' | 'GCP_DATAFLOW_RUN_PIPELINE' | 'GCP_DATAFORM_INVOKE_WORKFLOW' | 'GCP_DATASTREAM_MONITOR' | 'GCP_LOOKER_RUN_SCHEDULED_PLAN' | 'GITHUB_RUN_WORKFLOW' | 'GKE_RUN_JOB' | 'HEVO_CHECK_DESTINATION_STATUS' | 'HEX_RUN_PROJECT' | 'HIGHTOUCH_SYNC' | 'HTTP_REQUEST' | 'HTTP_REQUEST_ASYNC' | 'KAFKA_CHECK_TOPIC' | 'KEBOOLA_RUN_FLOW' | 'LIGHTDASH_REFRESH_DASHBOARD' | 'LINUX_SSH_EXECUTE_COMMAND' | 'MATILLION_ETL_RUN_JOB' | 'MATILLION_EXECUTE_PIPELINE' | 'METAPLANE_RUN_MONITOR' | 'MOTHERDUCK_EXECUTE_QUERY' | 'NIMBLE_SERP_API' | 'NIMBLE_WEB_API' | 'OMNI_TRIGGER_SCHEDULE' | 'OPEN_AI_CHAT' | 'PORTABLE_RUN_FLOW' | 'POSTGRES_RUN_QUERY' | 'POSTGRES_RUN_TEST' | 'POWER_AUTOMATE_RUN_FLOW' | 'POWER_BI_REFRESH_DATAFLOW' | 'POWER_BI_REFRESH_DATASET' | 'PREFECT_CLOUD_RUN_FLOW' | 'PYTHON_EXECUTE_SCRIPT' | 'QLIK_REPLICATE_TASK_FULL_LOAD' | 'RENDER_RUN_JOB' | 'RIVERY_RUN_RIVER' | 'RUN_AGENT' | 'SEND_SLACK_MESSAGE' | 'SEND_MICROSOFT_TEAMS_MESSAGE' | 'SIGMA_DATAMODEL_MATERIALIZATION' | 'SIGMA_DATASET_MATERIALIZATION' | 'SIGMA_WORKBOOK_MATERIALIZATION' | 'SNOWFLAKE_ANOMALY_DETECTION' | 'SNOWFLAKE_RUN_QUERY' | 'SNOWFLAKE_RUN_TEST' | 'SNOWFLAKE_SCHEMA_VALIDATION' | 'SQL_MESH_EXECUTE_JOB' | 'SQL_SERVER_RUN_QUERY' | 'STITCH_SYNC' | 'SYNAPSE_NOTEBOOK_RUN' | 'SYNAPSE_PIPELINE_RUN' | 'TABLEAU_REFRESH_EXTRACT' | 'TABLEAU_REFRESH_WORKBOOK' | 'TABLEAU_UPDATE_SUBSCRIPTION' | 'TALEND_CLOUD_EXECUTE_TASK' | 'THOUGHTSPOT_FETCH_LIVEBOARD_DATA' | 'TOBIKO_CLOUD_EXECUTE' | 'TRIGGER_PIPELINE' | 'WAIT' | 'WINDOWS_SSH_COMMAND', required
    - `status` 'CREATED' | 'SKIPPED' | 'QUEUED' | 'RUNNING' | 'SUCCEEDED' | 'WARNING' | 'FAILED' | 'CANCELLING' | 'CANCELLED', required — NOTE: if changing these values, please also confirm the AWS Step Function state machine is not impacted. This can be done by looking at `terraform/modules/step_function/main.tf`, and viewing the state machine JSON definition.
    - `message` string, nullable
    - `externalStatus` string, nullable
    - `externalMessage` string, nullable
    - `taskParameters` object, nullable
    - `runParameters` object, nullable
    - `connectionId` string, nullable
    - `computeResourceId` string, nullable
    - `platformLink` string, nullable
    - `numberOfAttempts` integer, nullable
    - `matrixParent` boolean
    - `matrixParentId` string, uuid4, nullable
    - `createdAt` string, required
    - `updatedAt` string, required
    - `completedAt` string, nullable
    - `startedAt` string, nullable
    - `dependsOn` string[], nullable
    - `anomalies` object, nullable

## Other responses

- `401` — The request was not authorized. Check the API key and `Authorization` header.
- `403` — The request was forbidden, or the Metadata API is not enabled for this workspace.
- `422` — Validation failed. Check path parameters, query parameters, and JSON request bodies.
- `429` — Too many requests. Wait before sending more requests.

---

[API](https://skmtc.dev/getorchestra/apis/orchestra-api.md) · [All operations](https://skmtc.dev/getorchestra/apis/orchestra-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/getorchestra/orchestra-api/revisions/50f4d2ba114d/schema)
