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.