CURLSMBS and Google sheets OAuth

Add-Ons
1

Has anyone been able to connect to google sheets using the example project CURLS oAuth? I got the Chilkat one to work fine but would like to use MBS as I’m also using other of their plugins. I have the ConsumerKey, Secret, Accesstoken, but not sure what to use for the AccessTokenSecret or the parameters. I have the URL set as https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId} using the spreadsheet id from the one of interest.

Any help would be great.
Thanks
Sharon

2

This is not a direct answer, but if wanting to use CURL it appears you only want to read data, then if the sheet is publicly visible (a big if) and you are okay with getting in csv format, then you can use something like this:

var sock as new URLConnection
var URL as string
URL = "https://docs.google.com/spreadsheets/d/{{ID}}/gviz/tq?tqx=out:csv&sheet={{sheet_name}}"
URL = URL.replace("{{ID}}", sheetID)
URL = URL.replace("{{sheet_name}}", sheetName)
var data as string
data = sock.SendSync("GET", URL, 10 )

You will get the data back in CSV format, which you can parse with SplitCommaSeparatedValuesMBS() after you split into lines.

Edit: Added phrase about only wanting to read data if using CURL

3

I’d like to be able to read and write, I’m new to using APIs and only have reading working now using the chilkat plugin. I’ll give your suggestion a try though and see if I can get it to work.
Thanks!