Data Factory API field - pipelineReturnValue not available in logic app connector?

Rishit 45 Reputation points
2023-06-07T15:21:12.4433333+00:00

How can we access the output value from the data factory pipeline execution in logic apps through the "Get a pipeline run" action?

Is there any possible way to get the output from the data factory pipeline using logic apps?

REST API for data factory provides a field "pipelineReturnValue"-
https://learn.microsoft.com/en-us/rest/api/datafactory/pipeline-runs/get?tabs=HTTP

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,542 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,623 questions
0 comments No comments
{count} votes

Accepted answer
  1. VenkateshDodda-MSFT 24,951 Reputation points Microsoft Employee Moderator
    2023-06-08T09:12:22.5766667+00:00

    @Rishit Thank you for reaching out to Microsoft Q&A, apologize for any inconvenience caused on this.

    If you are using the built-in action, Get Pipeline run under data factory connector in logic app then you won't be able to pull the pipelineReturn Value. You can refer to this documentation, to understand what all the possible output values using the Get a pipeline run action.

    To pull the pipelineReturnValue using logic app you need to use HTTP action and along with it you need to use compose to pull those returnvalues from the HTTP action output.

    I have tested this in my local environment, by creating a consumption-based logic app with recurrence as trigger followed by HTTP action (to get pipeline run information) and compose to pull return value.

    Here is the workflow screenshot for your reference:

    User's image

    Here is the expression we have used in the compose action in the above workflow:

    body('HTTP')?['pipelineReturnValue']

    If you want to pull the pipelineReturnValue using built-in action, Get a pipeline run I would suggest you raise feedback request here. Our engineering team will actively monitor this feedback as well.

    Feel free to reach back to me if you have any further questions.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.