endpoint with google sheet content (and other cloud file services)

[avelino]

I was thinking about the future of the project and whether we should bring other types of integrations into the moclojer core.

e.g. Google Sheet integration

putting moclojer as a no-code tool to transform spreadsheet (google sheet) in api

configuration:

- endpoint:
    method: GET
    path: /google-sheet-file1
    response:
      status: 200
      headers:
        Content-Type: application/json
      external-body:
        provider: gsheet
        file: https://docs.google.com/spreadsheets/d/...

---

If you have declared the configuration body and external-body on the same endpoint, the body will have higher priority, allowing external requests to the cloud service.

tabs: ends tab becomes a “sub endpoint” of the api, example where the file has the following tabs tab1, tab2 and tab3, the endpoint for this file would look like this:

• /google-sheet-file1 - “first tab” is not named (tab1), if it is possible to identify which is the first tab
• /google-sheet-file1/tab2
• /google-sheet-file1/tab3

I haven't thought much about how to access private files (how to pass access tokens), it is a subject that we need to evolve this discussion to turn it into an issue when we have the minimum defined.

[vmesel]

This would be highly applicable to financial markets people that only use spreadsheets to work. My guess is that it's a great integration to have.

[matheusfrancisco]

I can see a lot of value in this integration, there are a lot of places using spreadsheets that could automate some work.

[matheusfrancisco]

I haven't thought much about how to access private files (how to pass access tokens), it is a subject that we need to evolve this discussion to turn it into an issue when we have the minimum defined

I will do a kick search in the next few days to see how we could connect with private files.

[rafaeldelboni]

I like the idea, but my first thoughts was about access tokens, permissions and rate limits.

Is the configuration file a safe place where I could add my Gdrive token directly on a specific the header and proxy it to the Gdrive API?

[matheusfrancisco]

it might not be the safe place, the token could be on env vars, what do u think? have any thoughts on where we could add it?

about permissions and rate limits, this could be on the config file from this integration right it? 🤔

[avelino]

I started implementing this feature with xlsx here #152

Google Sheet is not yet supported, but we'll get there!