CODEWITHSUNDEEP
jsonluagoogle-sheetscoronasdk
Catlard
Catlard

Reputation: 893

Lua can't decode google Sheet JSON?

I'm trying to decode a JSON string in Corona, using Lua. json.decode seems to work for older google sheets, but not for newer ones -- instead of a string of JSON data, I seem to get a lot of HTML and who knows what. It looks like this:

http://pastebin.com/rXVi5UBC

Am I getting a 404 webpage, or am I missing something? Is there some recent change to google sheets API that would have caused my data not to come down? I'm trying to parse a document like this by using the standard Lua json:decode() function.

S

Upvotes: 0

Views: 632

Answers (2)

Helena M.
Helena M.

Reputation: 63

(Apologies it would not allow me to comment...)

I'm trying to do a similar reading of the JSON in a google spreadsheet. Could you explain how you exported it into JSON and some other steps you followed? I can't seem to get it just right...

Upvotes: 1

Catlard
Catlard

Reputation: 893

I found out the reason why it wasn't working -- turns out NEW google sheets documents need to be "published" in order to be accessed via the API.

https://support.google.com/docs/answer/37579?hl=en

Upvotes: 1

Related Questions