Azure data factory

Question

I am working on azure ADF pipeline return value. its populating a wrong syntax when I click activity outputs, it gives below which I have to add my properties (declared_return_value) to it and its failing

it was not giving the correct syntax which **@activity('set_variables_activities_with_airflow').output.pipelineReturnValue.**declared_return_value.

Answer 1

@FRANK OPOKU KODUAH

Based on your scenario, it seems you're trying to access a return value from a child pipeline executed via an Execute Pipeline activity in Azure Data Factory (ADF). The syntax you're currently using refers to output.properties.returnValue, which is typically used for other activities like Web or Custom activities not for Execute Pipeline activities.

To retrieve a value returned from a child pipeline, you should use the following expression:

@activity('set_variables_activities_with_airflow').output.pipelineReturnValue.declared_return_value

Here:

• 'set_variables_activities_with_airflow' is the name of your Execute Pipeline activity.
• declared_return_value is the key name you've defined in the Return activity of the child pipeline.

For more details refer: Return values from a child pipeline

Please ensure that:

• Your child pipeline contains a Return activity.
• The key you're trying to access (declared_return_value) is correctly defined in that Return activity.

I hope this information helps.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Answer 2

Hi there FRANK OPOKU KODUAH,

thanks a lot for posting your question on the Microsoft Q&A portal.

I took a look at your question about azure data factory, and I’ll try to help. Azure data factory is a powerful tool for data integration, but sometimes things can get a bit tricky, especially if you're just starting out.

From what I understand (and correct me if I'm wrong), you're having some trouble with [specific issuebut since the link doesn’t provide exact details, I’ll give a general example]. For instance, if it's about pipeline failures, a common fix is to check the activity logs in the monitor section of azure data factory. Microsoft’s docs explain this really well here: Azure Data Factory Monitoring.

If your problem is more about connecting to a data source, make sure your linked service is configured correctly with the right credentials. Sometimes a small typo in the connection string can cause big headaches )) The official guide on linked services is here: Linked Services in ADF.

And hey, if you can share more details (like error messages or screenshots), that’d be awesome it’ll help narrow down the solution!

Again, thanks for using the Q&A platform, and don’t hesitate to ask follow-up questions if something’s still unclear.

If you haven’t already, the azure data factory documentation is a goldmine for troubleshooting: Azure Data Factory Docs

Best regards, 
Alex
P.S. If my answer help to you, please Accept my answer
PPS That is my Answer and not a Comment
https://ctrlaltdel.blog/