ImportJSON

ImportJSON copied to clipboard

My column headers get reorderd randomly when the formula is re-applied

scorpion-hue

Exception: DNS error in import JSON function

2

I'm using the script three days ago and it worked perfectly until today. The function doesn´t retrieve the data and appears the next error in my google sheets cell: Exception:...

csanmar1410

Is latest version 1.5 or 1.6?

1

Hi, your notes say 1.6 is latest, but the code header says 1.5...

snorkywhale

Hello I am using your script to Manage my campaigns in Facebook from google sheets and it's working perfectly for me , thank you for it. so my issue now...

mustavanov

Parse numbers from string by default and add 'noParseNumbers' option …

6

…as recommended in bradjasper/ImportJSON#7

ralphilius

**Goal:** Import client data from Facebook Graph API into a Google Sheet to create a dynamic Facebook Ads Dashboard **What I've tried:** Used ImportJSON with a Graph API query created...

lbrb-sam

your example code: `=ImportJSON("https://mysafeinfo.com/api/data?list=bestnovels&format=json&rows=20&alias=cnt=count,avg=average_rank,tt=title,au=author,yr=year", "/title") ` returns Reference does not exist error because "/title" should be "/Title".

Zaffer

Reordering columns via allHeaders is broken

1

Let's say I have a JSON response that will create 26 columns worth of data, but I just want the first 3 in reverse order. `=importJson("example.com/json_abcs", "/c, /b, /a")` isn't...

ciscorucinski

If a value is 0 then my cell gets empty

3

Is there any way to read 0 as 0 and not getting an empty cell? Seems like I could do this afterwards but makes things a lot more complicated..

davidguva

i don't how to import this site ,please help me https://bet.hkjc.com/football/getJSON.aspx?jsontype=search_result.aspx&startdate=20201106&enddate=20201106&teamid=default&pageno=1 i had try this ,but no work... =ImportJSON("https://bet.hkjc.com/football/getJSON.aspx?jsontype=search_result.aspx&startdate=20201106&enddate=20201106&teamid=default&pageno=1","noInherit,noTruncate,rawHeaders")

hancoryan