Dynamic row number in array within table

Hi,

What would be the syntax to replace [1] with a dynamic row number within the table? I tried every combination of "i" but can't get it to work. I keep getting null value returned. If I use a hard coded row number, e.g. Response[1]['city'], it works. Something like Response['i']['city'], Response[i]['city'], Response['@i']['city'] or Response[@i]['city'] doesn't.

 

 

Asked by Jason West on Fri 6/21/24 4:41 PM Last edited Fri 6/21/24 5:14 PM
Sign In to leave feedback or contribute an answer

Answer (1)

This answer has been marked as the accepted answer
Michael Ligouri Wed 6/26/24 5:36 PM

Hi Jason, can you give me the application name and flow name this is in?

Cheers,
Mike Ligouri
Technical Support Consultant

No feedback
Application is: ZJason - Core - Lab 7
Flow is: API Connector - Recreate - Jason West Thu 6/27/24 11:24 AM
So all you'd have to do there is when you run the API Ninjas call, under the response, click the Set Data Model button. That will give iPaaS the info it needs for how the response should be constructed, and then you can iteratively select values from the JSON. I've done that for you in the flow. - Michael Ligouri Thu 6/27/24 12:50 PM
Thank you for the "how to". It's appreciated. - Jason West Thu 6/27/24 2:54 PM