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?

Rank: #177

Hi Shubham,

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

Sometimes this values affect to get some columns.