adamwongbrooks

JSONGetElement: Any way to give calculation/data as array index?

Discussion created by adamwongbrooks on Oct 11, 2018
Latest reply on Oct 11, 2018 by adamwongbrooks

I am trying to return data from a JSON API, and it works fine when I do the following:

 

JSONGetElement ( Result ; "[1]Description" )

JSONGetElement ( Result ; "[2]Description" )

JSONGetElement ( Result ; "[3]Description" )

JSONGetElement ( Result ; "[4]Description" )

 

However, it doesn't seem to work when I put anything other than a number in the brackets denoting the value's array index:

 

JSONGetElement ( Result ; "[Get ( RecordNumber )]Description" )

 

-or-

 

JSONGetElement ( Result ; "[field name here]Description" )

 

Can anyone help me do it this way, or conceive of a simple loop to achieve the same result?  Thank you!

Outcomes