Fabric data pipeline public REST API Query Activity Runs

[mprewett]

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_insta...}' \

--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}/...' \

--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. 

[Anonymous · Accepted solution]

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.

[larsaia · Accepted solution]

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

[mprewett]

Thank you! Finding documentation on this was not easy.

[larsaia]

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.

[Anonymous · Accepted solution]

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.