jdon pluhin -- example that doesnt work well

Hi,

Below is a sample that doesnt seem to parse correctly.

dropbox.com/s/apzz8j7qw4t3nl0/jsonSample.c3p

if you can look at it,

thank you,

Daniel

thank you!

this is very educational example, how to use the constructs together.

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" ]

]

}

I solved it in a somewhat cumbersome way:

Since the loop apparently goes through all values in the table "breadth first" -- across each row, i added two subevents with condition 0 and 1, respectively. i then have a counter that "flip flops" between 0 and 1 (by adding one to a counter and then taking modulu 2).

Like this each subevent "knows" what column it handles.

But, i think its is pretty cumbersome and better if there is a simple way to access each column in a received row -- via a simple expression.

can this be done

grossd

I'll take a look and I'll get back to you with how to do that.

Hi,

Yes!

That is the approach I did as well. Just yours is much cleaner -- to use loop index (instead of a local variable) in the subevent to identify the column.

great.

thank you,

Dan