Export JSON from Spreadsheet ?

[Jacques-Olivier-Farcy]

Hi,

I Already used this great tool a few times and i am enjoying it a lot!
I want to use the JSON method, is there a way actually to export a JSON file from a google spreadsheet ?

[JoeGermuska]

Good question. This isn't something currently supported, but it would not be difficult.

I don't have time to finish this out right now, but I just pushed (d153d53) something that would let one, in a browser, run

let url = 'https://docs.google.com/spreadsheets/u/1/d/1xuY4upIooEeszZ_lCmeNx24eSFWe0rHe9ZdqH2xqVNk/pubhtml'
TL.exportJSON(url).then(console.log)

With that, we could add an "Export JSON" button to the authoring page which executed this call and then marshalled it as a browser download. I am not going to have time for that for at least a week and a half, though.

Anyone comfortable working with JS source could check out the TimelineJS3 repository, run npm start, and run that in the console of the test page and then copy the console output into a file.

we'd take a patch that adds the UX part, but i won't even have a chance to review it until week after next at the soonest.

[Jacques-Olivier-Farcy]

Hey thank you for your quick answer, no hurry, glad to see it could be possible.
I am not a dev, but i will ask around me some help to try this "let url" thing happened!