API to get all the pipeline status and activity runs

Kumar, Arun 316 Reputation points
2023-10-03T15:16:58.3533333+00:00

Hi,

Is there any API to pass and get all the pipeline and activity status for Azure Synapse Studio (Azure Data Factory). I am seeing POST and GET API for Azure Data Factory based on passing pipeline name/run ids, but not a consolidated status. Below is what i am looking for

  1. POST and GET API to get status of all Azure Synapse Studio pipelines and activities (Copy, Get Metadata etc.)

Appreciate the help.

Thanks,
Arun

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,467 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 29,901 Reputation points MVP
    2023-10-04T04:19:48.9633333+00:00

    Hey,

    Using the below API, you can get the list of all pipeline runs :

    https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/pipeline-run/query-pipeline-runs-by-workspace?tabs=HTTP

    And then leveraging that iterate over each run to get the activity status via below API :

    https://learn.microsoft.com/en-us/rest/api/synapse/data-plane/pipeline-run/query-activity-runs?tabs=HTTP

    0 comments No comments

0 additional answers

Sort by: Most helpful