Hi,

I get this error from time to time, which then later on disappears and the gamefile loads ok (from dropboc cloud).

Any idea how to overcome this

thank you,

Dan

Hi,

I paid someone to write a simple rest API for Google Sheets, that can be used with Google's Application Engine. The code is written in node.js.

This essentially, allows reading and writing to a google sheet given a sheet ID and Range, via C2/C3 AJAX GET and POST.

I want to make the code available as open source to the C2/C3 community and want to know what the best open source license would be, so that it encourages anyone who wants to improve and contribute the improvements back to the code base.

The code should be usable for both private and commercial use.

much appreciating your suggestions,

Dan

Hi,

I am trying to use AJAX to call a web service app on google suite apps.

Due to security reasons the google apps server returns the result of a GET using a different URL than the one used in the AJAX GET call.

I am getting an error when trying to use GET.

I am wondering if this is related and if yes, how this could be overcome -- i.e. to obtain a response from GET via a redirect URL

thank you,

Dan

Google's redirect notice is at the end of this link:

developers.google.com/apps-script/guides/content

Redirects

For security reasons, content returned by the Content service isn't served from script.google.com, but instead redirected to a one-time URL at script.googleusercontent.com. This means that if you use the Content service to return data to another application, you must ensure that the HTTP client is configured to follow redirects. For example, in the cURL command line utility, add the flag -L. Check the documentation for your HTTP client for more information on how to enable this behavior.

Hello,

I am looking to hire someone to build a plugin for Google's authentication scheme in C3.

developers.google.com/identity/protocols/OAuth2

Apparently only with oAuth2 I can write to a google sheet from C3.

Can you help me with that, how much would it cost?

thank you,

Dan

Hi,

has anyone successfully implemented oAuth protocol in C3, to, say, access a google suite app such as a spreadsheet.

Some google apps support key based authentication, but i am running into problems for PUT requests. Other google apps, such as the Google SQL database requires oauth.

thanks,

Dan

Thank you.

In my case (with the way JsonManager looping works), there is a sub-event under the loop to test for conditions within the loop, and a parent event, that for the loop itself.

Placing an empty event underneave the jsonManager loop doesn't seem possible, but i can place it as a "sibling" underleave the top parent.

Will try this out once google sheets api comes online again -- for some reason, the google sheets api suddently stops responding to ajax calls, and after some wait (30 min? an hour?) it suddenly works again.

anyway, thanks, will give it a try

Dan

Hello,

I have a for loop that via a sub event / actions fills a listbox with values. During the filling, the listbox does not trigger any changed selection event.

I want to select the first item in the listbox after the for loop completes and all values are filled in, so that the selection triggers additional processing in filling in items in the UI -- for depending items.

I cant figure out how to add an action after a loop completed -- since the loop is within a subevent. and there is no way to add actions after the subevent at the level of the parent event.

any thoughts how this could be done are much appreciated,

thank you,

Dan

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

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

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

]

}

thank you!

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

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