login about faq

Hi, Is there currently or in development the capability to use and access the google sheets API for xojo? I would like to be able to download and upload values to cells within a specific google sheet. As I understand it the CHilkat xojo plugin would give me the capability of getting access to google API docs but I don't see any provided method for editing google sheets within xojo. If this is correct I see my next best alternative to use the plugin to access google drive and import data from a google sheet or text file in google drive, modify it and then upload back to google drive. Thank you in advance for any advice you can give. regards, Matt

asked Oct 03 at 21:56

Coogan's gravatar image

Coogan
1


I think the answer is that the Google Sheets API is just another REST API like anything else.

In that sense, it's an API with various calls using POST, GET, PUT, DELETE, etc. where information is passed in one or more of the following:

  1. JSON request body
  2. Query params
  3. Request header fields

The HTTP response is a response status code with a JSON response body.

The task of writing code for any REST API is simply to form the correct HTTP request, which involves building the JSON for the request body, and to parse the JSON contained in the response body.

Chilkat is working on an online tool (which is in Beta now, but not yet widely announced) to do the following:

  1. Copy-and-paste sample JSON to generate code that creates the JSON, and..
  2. Copy-and-paste sample JSON to generate code that parses the JSON.

You can try it here: http://tools.chilkat.io/

link

answered Oct 04 at 10:23

chilkat's gravatar image

chilkat ♦♦
12.8k317363471

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×22
×12

Asked: Oct 03 at 21:56

Seen: 278 times

Last updated: Oct 04 at 10:23

powered by OSQA