B4R Question reading/writing to google shared doc from ESP

[giggetto71]

Hi guys,
I am looking for a way to access (read/write) a shared sheet on google drive from an ESP connected to the network.
the sheet I have created is not restricted: I have chosen the option "Anyone with link". any chance?
thanks!
pierluigi

 

[hatzisn]

With IFTTT and you can write to a Google Sheet.

 

[hatzisn]

Have a look at this example:

 

[giggetto71]

thank you very much! this looks interesting. is there a lib in B4R for interacting with IFTT?

 

[hatzisn]

Why would you need this? It is just a post request using rHttpUtils2 library.

 

[giggetto71]

Ok. Got it thanks. I guess i would then need an example to go through. Can you suggest something i could start from? Thank you very very much!!

 

[hatzisn]

Pause the video above in the correct moments and copy the link to the server (it is server + the following) and also the JSON string to post. And in bocca al lupo.

 

[giggetto71]

@hatzisn , thank you very very very much..using Webhooks service in IFTTT I was able to create an event triggering to write on a google sheet by posting to the address as: (of course the key is not 12345678...)

https://maker.ifttt.com/trigger/MyEventName/with/key/12345678?value1=123&value2=456

and also with a B4J app:

Dim httptask As HttpJob
    httptask.Initialize("httptask",Me)
    httptask.PostString("https://maker.ifttt.com/trigger/MyEvent/with/key/12345678?value1=123&value2=456",Null)
    
    Wait For (httptask) JobDone(Job As HttpJob)
    
    If httptask.Success Then
.......

did not try yet from B4R but I expect should work the same, correct?
thanks again

 

[hatzisn]

Glad you did it. It looks like I created an example for nothing now that I took a break for the noon. I will post it anyway in case someone needs it.

Edit: Now that I read your message till the end it seems my effort was not in vain.

 

[giggetto71]

grandissimo! ευχαριστώ!