ImportJSON

ImportJSON copied to clipboard

Hi! Some time ago I used this amazing script on a google sheet and as I remember, it didn't take me more than a couple of minutes, to find out...

leolamanna

Recently, I have observed an issue with duplicate lines being imported. I can't seem to pinpoint the issue, but this seems to have occurred for other folks in an [old...

dwolff22

Take only first value from list of returned values

26

Hi. I am wondering whether it's somehow possible to take only first value (or value at location `i`) when receiving a list of values in json. For example, for this...

ronlut

Return data on the next column instead of next row?

1

Just discovered this project and it is awesome! I was wondering if it is possible to return the data on the next Column instead of the next Row. Right now...

gusflopes

Hi there - the importJSON fuction is not parsing the NULL values correctly in this flight data API for Denver: http://aviation-edge.com/v2/public/timetable?key=33e556-819cf8&iataCode=den&type=departure The fuction works properly for the Seatle API: http://aviation-edge.com/v2/public/timetable?key=33e556-819cf8&iataCode=sea&type=departure...

seankirkconnell

Error - "Unknown function: ImportJSON"

2

Hello. I use ImportJSON to update my Facebook Catalog and Google Ads data feed, but from time to time (1-2 times a week) I get an "unknown function" error. It...

andersjohansenn

ImportJSON with request Header

7

Hi all, I'm trying to import a JSON payload into Google Sheets, but the service I'm trying to consume requires an "authorization" key/value pair supplied in the request header: https://groups.caremonkey.com/api/docs/...

phrak

Windows users cannot checkout

1

In the archive there are 150 files with a ? in their name. I forked this repo and cannot checkout locally (Windows machine). Had to hack my way around it...

krijnsent

ERROR - Result too Large

1

I am trying to get a bunch of data in from this API: https://tookanapi.docs.apiary.io/#reference/task/view-all-tasks but I only get the Result Too Large response. I know it is set up correctly...

MisterCreosote

ImportJSON stopped working

2

I tried today and it's Error Loading data… I used version 1.5 Test: =ImportJSON("http://date.jsontest.com", "/date", "noInherit, noTruncate") I think this error from Google Sheet, not from the function itself. Is...

AndreyAzimov