topic Re: [URGENT] Get Status of the Data Pipeline after trigger using Power Automate in Pipelines

[URGENT] Get Status of the Data Pipeline after trigger using Power Automate

JatinSaini — Tue, 24 Dec 2024 09:48:19 GMT

Hi Developers,

Am new to the Fabric Platform and recently I have created a Data Pipeline. And have create a power automate flow to run that data pipeline via API method (HTTP Request).
Here's the below thred for that:
[URGENT] Run DataPipeline via API using Power Automate and get status
In continuation of this,
I also want to get the status of the triggered pipeline. If suppose there are multiple people running the same pipeline, how can I retrieve the status of only my instance?

Thanks in Advance.

Re: [URGENT] Get Status of the Data Pipeline after trigger using Power Automate

lbendlin — Tue, 24 Dec 2024 13:03:14 GMT

Job Scheduler - Get Item Job Instance - REST API (Core) | Microsoft Learn

Re: [URGENT] Get Status of the Data Pipeline after trigger using Power Automate

JatinSaini — Tue, 24 Dec 2024 13:39:44 GMT

Hi lbendlin ,
Thanks for the revert.
I have followed your shared documentation but I have one major query that, how will i get the jobInstanceID for the Pipepline which i triggered, as it does not have anything the body of the response?

Re: [URGENT] Get Status of the Data Pipeline after trigger using Power Automate

lbendlin — Tue, 24 Dec 2024 13:51:14 GMT

The instance id is in the "location" field of the response.

Re: [URGENT] Get Status of the Data Pipeline after trigger using Power Automate

JatinSaini — Tue, 24 Dec 2024 14:34:08 GMT

Hi lbendlin ,
The API is not generatiing anything post response, I was running the api through the HTTP Connector via Power Automate, but the Body is empty.

Re: [URGENT] Get Status of the Data Pipeline after trigger using Power Automate

lbendlin — Tue, 24 Dec 2024 15:35:26 GMT

I'd call that a bug. If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

Re: [URGENT] Get Status of the Data Pipeline after trigger using Power Automate

V-yubandi-msft — Wed, 25 Dec 2024 15:33:55 GMT

Hi JatinSaini ,

Thanks for reaching out to the Microsoft Fabric Community Forum.

lbendlin providing useful information However, it appears that you are encountering an issue where the body is empty when running the API through the HTTP Connector via Power Automate. Please double-check the following steps to resolve this issue.

If the API returns an empty response body when triggering the pipeline, it could indicate.

The API doesn’t directly give a Run ID or status information in the trigger response.
The pipeline trigger request might be asynchronous. This means the triggering API call doesn't immediately give the Run ID, and you may need another API call to fetch it.
Some APIs provide a separate endpoint to check recent pipeline runs or get details of an active run.

Note: Ensure that the API is meant to return a response body. Some APIs might only give a status code without a body.

Enable Response Logging in Power Automate.

Check if the HTTP Connector in Power Automate logs headers or metadata in the response.
Even if the body is empty, sometimes headers have extra details like an operation ID or a URL to check the run status.
If the API gives an error status code (like 400, 404, 500), the response body may be empty or may have error details. Always look at the status code first.
If the API needs authentication, make sure you're giving the right credentials (like an API key or OAuth token). An authentication failure can also result in an empty response.

Query for Recent Pipeline Runs.

Use the API endpoint (if available) to fetch recent pipeline runs.
Filter the results by trigger time, user, or other unique parameters to identify your specific instance.

Use a Custom Identifier in the Trigger Request

When triggering the pipeline via API, some systems let you send custom metadata or tags as part of the request payload.
For instance, you can include your username, a timestamp, or a custom tag (like Initiator: 'Your Name') in the request body.
Use this metadata to query and differentiate your run.

Cors and Security Policies

Cors Issues: If you're calling an API hosted on a different domain, Cross-Origin Resource Sharing (CORS) policies might stop the response from coming back. This is particularly important if you're using a custom connector.
Firewall or Security Settings: Check if there are any firewall rules or security settings that could be blocking the response from reaching Power Automate.
Use Postman or Curl: Test the API outside of Power Automate with tools like Postman or Curl to see if you get a response. This can help you figure out whether the issue is with the API or Power Automate.

For more information, please refer below link:

HTTP actions reference - Power Automate | Microsoft Learn

If my response solved your query, please mark it as the Accepted solution to help others find it easily!

And if my answer was helpful, I'd really appreciate a 'Kudos'.

Re: [URGENT] Get Status of the Data Pipeline after trigger using Power Automate

V-yubandi-msft — Mon, 30 Dec 2024 09:26:43 GMT

Hi JatinSaini ,

We wanted to follow up as we haven’t heard back from you. Could you kindly confirm if the solution we provided resolved your issue?

If you need any further assistance, please don’t hesitate to let us know. Your feedback is important to us, and we look forward to your response.