Fetch JSON data with 1 click

Hi all, I’ve just built this doc that enables you to get json data given a url.

Check it out: https://coda.io/d/Fetch-JSON-v1_dg4WCTa37F8/_su0fI

You need to install a Google Apps Script, all instructions in there. Once set up, you can reuse the tables in multiple documents.

The doc builds upon the great work of @Paul_Danyliuk, @Filmos and @Joe_Innes, using a lot of hidden experimental formulas and hacks. So it may break at any moment. That’s why the Data is isolated from the Engine. In any case, use it at your own risk.

Initially I started with an Integromat webhook but reached a dead end since for some reason in order to update a table you need to manually select the table. Zapier suffers from the same restrictions.

I wanted something portable that could be used in multiple documents. So the solution was to use the API, and GAS was the path of least resistance. It has a Coda API library, and SSO means is one less service to manage.

14 Likes

Here I was doing a round trip with the Coda API to get the href then breaking that up to get the row, doc, table, and column ids automatically. Thanks for sharing those formulas!

Thanks for this !
Very interested to see how you get the POST working