Syntax for filtering the json value which is in nested loop

Question

We have pipeline where will get the output in the json format which we need to filter the nested loop as shown in the below.

"output": [
{
"name": "aopjrfowair",

                "Type": "customer"
               }

]

I need to fetch the "type" value which is in array. what will be syntax to write in the filter activity.

Answer 1

Hi @Pavan Rakesh ,

Thank you for posting query in Microsoft Q&A Platform.

Assuming some activity called abcd has this output property inside output json of it, consider writing your expression as below to get Type property value.
@activity('abcd').output.output[0].Type

Please check below video for better idea.
How to read JSON output of one Activity in to another Activity in Azure Data Factory

Hope this helps.

------------

Please consider hitting Accept Answer. Accepted answers help community as well.