I have a few sheets based on Google Sheets that could import data from a URL with the IMPORTDATA formula. That formula allows me to get a Json response from a API URL request.
For instance, I could use a url shortening API service, like:
=IMPORTDATA(“https://cutt.ly/api/api.php?key=[API Key]&short=[Long URL]&text=[Title]”)
That would return all the elements of the successful request:
I couldn’t find any Coda formula to do the same thing – is there a way to get the response of a URL in the Coda document?
I would like to shorten URL’s generated on a table using the Cuttly API, but right now I can just create the URL – without getting it’s response.