topic Fabric data pipeline public REST API Query Activity Runs in Pipelines

Fabric data pipeline public REST API Query Activity Runs

mprewett — Fri, 13 Dec 2024 18:23:55 GMT

I am using Postman to call the the Fabric data pipeline public REST API's to query activity runs. I keep getting an empty result set when calling the queryactivityruns api using the pipeline job instance id, but the "Get item job instance" api returns correct results using the same job instance ID. Are these different ID's?

This returns the correct job instance (GET):

curl --location --request GET 'https://api.fabric.microsoft.com/v1/workspaces/{ws_id}/items/{pipeline_id}/jobs/instances/{job_instance_id}' \

--header 'content-type: application/json' \

--header 'Authorization: ••••••' \

--data '{

This returns an empty result set (POST):

curl --location 'https://api.fabric.microsoft.com/v1/workspaces/{ws_id}/datapipelines/pipelineruns/{job_instance_id}/queryactivityruns' \

--header 'content-type: application/json' \

--header 'Authorization: ••••••' \

--data '{

kromerm, adding you for possible assistance since i saw you as a contributor for these API's.

Re: Fabric data pipeline public REST API Query Activity Runs

Anonymous — Mon, 16 Dec 2024 02:02:34 GMT

Hi mprewett ,

It sounds like you're encountering an issue with the IDs used in your API calls. The job_instance_id used in the queryactivityruns API might be different from the one used in the Get item job instance API.

Here are a few things to check:

1. Ensure that the job_instance_id you are using in both API calls is exactly the same. Sometimes, there might be a slight difference or typo that could cause the issue.

2. Check the response data from the Get item job instance API to see if it includes any other IDs or references that might be needed for the queryactivityruns API.

3. Ensure that your API token has the necessary permissions to access both endpoints. Sometimes, different endpoints might require different scopes or permissions.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Fabric data pipeline public REST API Query Activity Runs

larsaia — Thu, 12 Jun 2025 15:50:25 GMT

You need to provide something in the body, at least:

{"lastUpdatedAfter":"2025-06-11T08:55:57.7992493Z","lastUpdatedBefore":"2025-06-12T08:55:57.7992676Z"}

Its very difficult to find in the documentation: Fabric data pipeline public REST API - Microsoft Fabric | Microsoft Learn

I found a link to a similar question: How to use pagination in Azure Data factory with REST API - Microsoft Q&A

There is some additional info in the DataFactory documentation, where some things seem to be applicable to fabric: Activity Runs - Query By Pipeline Run - REST API (Azure Data Factory) | Microsoft Learn

Re: Fabric data pipeline public REST API Query Activity Runs

mprewett — Thu, 12 Jun 2025 15:36:50 GMT

Thank you! Finding documentation on this was not easy.

Re: Fabric data pipeline public REST API Query Activity Runs

larsaia — Thu, 12 Jun 2025 15:47:18 GMT

I stumbled over your question, while searching for a solution, to use paging for this endpoint. The Fabric documentation is incorrect. I made it work, with the help from the Data Factory documentation. The last issue is, that I'm unable to change the pagesize.