JSON as custom object variable indexing

[Alvin_Hili1]

Hi All,

We have data in variable %JsonAsCustomObject% as shown below:

If we want to get the data from the firs record, we'd use %JsonAsCustomObject['1']% or if we use %JsonAsCustomObject['1']['name']% we get "root"

But we need to use variables in when indexing for data. So form the above example,where %Temp_Index% is set to 0, we'd like to be able to use %JsonAsCustomObject[Temp_Index]%, but when we try this, we get the error message "Variable 'JsonAsCustomObject' does not support indexing."

Thanks.

[itomti · Accepted solution]

Your variable needs to be of type string.

Convert it from a number to text. That way you will be able to access the property with a text representation of a number.

[Alvin_Hili1]

Thanks, it worked.

I converted the %Temp_Index% variable from number to text format, and used it to access specific data in the custom object: %JsonAsCustomObject[Temp_Index]% or %JsonAsCustomObject[Temp_Index]['totalFolders']%