Skip to content

Export JSON from Spreadsheet ? #884

Open

Description

@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 ?

Activity

  1. JoeGermuska commented on Oct 11, 2024

    @JoeGermuska
    Member

    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.

  2. Jacques-Olivier-Farcy commented on Oct 11, 2024

    @Jacques-Olivier-Farcy
    Author

    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!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions