is there a way to find the status of the pipeline programmatically in fabric

[fabriclearner12]

i would like to know if three is an way to find out the status of the pipeline in microsoft fabric . Can some one create a generic sciprt which can be used to get the status .

i know we have some documentation of adf but would like to know if there is a way to find out status of pipeline programatically in fabric.

https://learn.microsoft.com/en-us/azure/data-factory/monitor-programmatically

@Anonymous
@koichino0121
@fabchinmay
@v-cboorla-msft
@mpoeckl
@yllsuarez76
@ajarora

[gpalsson]

Look....

The need here is not to check single pipelines or create an alert when a single activity fails. What we need is a way to see if ANYTHING fails, and without us having to implement tedious error handling boxes for every activity for every pipeline, in case something goes wrong.

This works great in ADF. Why can't there be similar functionality in Fabric?

Even being able to query all activity runs for errors via the API would be an improvement. That way we could create an error workflow that covers all pipelines.

[Houston-ho]

Your link already provided 4 versions of code to check the status in generic way, https://learn.microsoft.com/en-us/azure/data-factory/monitor-programmatically

May i know where you would like to check the status of pipeline? outside Azure?

If that is inside Fabric, @FabianSchut  already shared the link, https://learn.microsoft.com/en-us/fabric/data-factory/pipeline-rest-api#query-activity-runs using REST API.

[FabianSchut · Accepted solution]

Hi @fabriclearner12,

Although this functionallity is still in preview, I think you can achieve this with the Fabric data pipeline API: https://learn.microsoft.com/en-us/fabric/data-factory/pipeline-rest-api.

To get the status specifically, I think you can use: https://learn.microsoft.com/en-us/fabric/data-factory/pipeline-rest-api#get-item-job-instance or https://learn.microsoft.com/en-us/fabric/data-factory/pipeline-rest-api#query-activity-runs