Chaffy-0

Results 7 comments of Chaffy-0

is there alternative project like this project?

Scrapy

How to add a trigger

Posted this to a similar question. I'm not sure this is what you're looking for but you might give a try. https://blog.datawrapper.de/live-json-in-google-sheets/

How to trigger ImportJSON with a script

Give this a look. https://blog.datawrapper.de/live-json-in-google-sheets/

How can I use this with the changes to scripts?

I created a new Google Sheet, renamed the default code.gs file to ImportJSON.gs, copy and pasted the code, saved it, then ran it. I had to authorize the app in...

Trouble with quote marks

Maybe try replacing those with single quotes.

extracting only specific column from the ImportJSON request response?

=QUERY(ImportJSON("API_URL"),"select Col1") Col1 needs to be the column you want. i.e. Column1 = Col1, Column2 = Col2, etc...

How to parse/transform values such as epoch to datetime??

I added a new column next to the timestamps and used this formula where "A1" is the first timestamp in your results. =(LEFT(A1,10)/86400)+DATE(1970,1,1)