Allows you to work with complex Json objects from your event sheet.
Hi,
I got it to work! (and noticed the loadstring in the example).
I got one problem left, though -- probably related to the json format google sheet returns:
It looks like this:
In trying to get the values into a dictionary or array, i am getting lots of brackets like: [[["str1"]]]
and when trying to loop over things its not clear to me what the query expression is after "values", to get at individual strings.
The objective is to get all of them into a listbox.
any thoughts are much appreciated.
Dan
{
"range": "Sheet1!A4:A7",
"majorDimension": "ROWS",
"values": [ [ "str1" ],
[ "str2" ],
[ "str3" ]
]
}
Here is an example when i use array.asJson:
{"c2array":true,"size":[22,1,1],"data":[[[["str1"]]],[[["str2"]]],[[["str3"]]]]]]}
Was this generated from the JsonManager. What might be easier if you have a sample project I can look at to see if I can help
Thank you.
Yes, its basically the to array function applied to JsonManager and then the array is displayed as json.
I will put together a sample project.
Is there a way i can send it to you?
if you just put it up on google drive, one drive, etc... and just share it and send me the link I'll be more than happy to take a look