Data entry via spreadsheet google rest API

Hi everyone

I am using a google spreadsheet api to fetch data from a spreadsheet. I am getting data in JSON format.

I am using this api in my outsystems app. I have called API in preparation and is working a loop on the response of api method  but when I am assigning data, only valueitem is present. 

 



Also the output does not have 2nd column.

Also when I debug the method I got something [0] and [1].

But I can't access this second element i.e. [1].

How to access that?

Hi Shubham,

Check if this properties stay mandatory = true and  have default value.

Sometimes this values affect to get some columns.


Regards