Issue while reading a JSON script array output using Foreach loop in ADF

Question

I have an array output from ACTIVITY script like this

Input json array
  {
  "result":[
  {
  "Val":[
  {"pqr":1,"srt":2},
  {"pqr":1,"srt":2}
  ]
  }
  ]
  }

How can I iterate this nested json object using a Foreach loop. I am getting error while I use @activity(script).output .result. Val to get the array values. Error: The length cannot be evaluated because property value doesn't exist

@wBob yr right ,sure this is corrcet json{ "result":[ { "Val":[ {"pqr":1,"srt":2}, {"pqr":1,"srt":2} ] } ] } — Being Real
– Being Real, Commented Jul 16, 2022 at 10:20

wBob · Accepted Answer · 2022-07-16 11:41:03Z

2

Set your For Each activity Items to:

@activity('Script').output.result[0].Val

and use it within the activity using the @item() syntax, e.g.

@string(item().pqr)

edited Jul 16, 2022 at 11:41

answered Jul 16, 2022 at 11:14

wBob

14.4k3 gold badges26 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Being Real Over a year ago

@string(item().Val[0]. pqr)->Here the o/p is not looping ,it is only taking first array value I want to get both the values of pqr inside for loop

Being Real Over a year ago

Thank a lot ,i got stuck on this for a while

wBob Over a year ago

Please upvote and make as answer (green tick) of this has been helpful!

Being Real Over a year ago

Sure wBob I have one query also,I am getting my xml response from restpi,But the columns names i getting from xml response through lookup activity arein fformat @pqr,@xyz like this.So I am unable to read the values inside foreach .(@string(item().@BookedLossu) ->showing error so how to read the column nvalues from xml

wBob Over a year ago

That’s a separate question really. Why not upvote and mark this one as answered, and open a new one with your sample data and expected results? I am sure someone will be able to help you.

|

Collectives™ on Stack Overflow

Issue while reading a JSON script array output using Foreach loop in ADF

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related