Hi,
Could i ask you how the loop would be changed if i am downloading a table rather than a column only. Something like below.
Now, i would want to show Str1 to Str4 in the listbox, while storing in a dictionary Str1 ... Str4 as keys with the numbers "1" to "4" as the values ...
(i.e. a mapping from the strings to their respective identifiers
I tried to add the accessor [0] of [1], such as: trim(JsonManager.GetJsonValue("","[1]","Yes")), to access the strings, when building the listbox, but this didn't work.
thank you!
Daniel
{
"range": "Sheet1!A4:B7",
"majorDimension": "ROWS",
"values": [
[
"1",
"Str1"
],
[
"2",
"Str2"
],
[
"3",
"Str3"
],
[
"4",
"Str4"
]
]
}