ImportJSON

ImportJSON copied to clipboard

New ImportJSON Implementation

16

Hi, Just thought I would let people here know about a new JSON Import function I have created. I thought it would be OK to post here as development of...

qeet

Read list of URLs from cell range

1

enhancement: read list of URLs from cell range ```js /** * Read list of URLs from range * Ex1: ImportJSON_RASG("sheet9!C2:C7") * Ex2: ImportJSON_RASG("myNamedRange") */ function ImportJSON_RASG(cellRange, query, parseOptions) { var...

yodog

How to add timer?

2

Hello and thank you for this amazing code! https://puu.sh/IWNt6/5d8a15138d.png I am using multiple calls in cells and I am reaching max quotas limit very often. Therefore I would like to...

mrfrankito

 I want to sync data from kobotoolbox with google sheet when executing error like image. Hope the solution fixes the error. Thank. Vans

Vannnnnnnn-s

Support 1D- and 2D-arrays as input for URLs to allow usage inside ARRAYFORMULA

6

This works now `=arrayformula(IMPORTJSON("https://www.binance.com/api/v3/ticker/price?symbol="&A2:B4&"", "/symbol,/price",))`

roman-orekhov

Bit of a newbie question, I'm afraid, but I'm struggling to figure out the correct syntax for using ImportJSONViaPost to access data from the GivEnergy API. The curl syntax is...

zacchaeus80

Import from Sleeper

1

I am trying to import from an API (https://api.sleeper.app/v1/players/nfl) If I use this syntax then it times out =ImportJSONAdvanced ("https://api.sleeper.app/v1/players/nfl") If I use this syntax to try and select certain...

djahngir

How to add Api Key header

1

Hello. Thank you so much for your code. It has proved to be extremely helpful for so many tasks. I do have a question though. Which function should I use...

Carlos-OL

Function does not compile; Exception: Attribute provided with no value: url

2

Chrome Version 97.0.4692.99 (Official Build) (arm64 )

outovhush

Repeats value for column on next line if next value is false

1

Check example json below. The field "underAvvikling" is set to true in the first object. On the next (and on all following rows) it is set to false. Still it...

ronnieoymoen