Questions tagged [importjson]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
17 views

Function(“url”) With A1 Cell Contents as Part of URL Query

I am trying to import JSON data into Google Sheets essentially like IMPORTHTML("URL"&A1&"URL"). Basically trying to adjust the URL by the contents of Cell A1. It seems to ...
1
vote
0answers
15 views

Google Sheets: a cell calls an API for a changing currency price, but sometimes returns an error. How do I keep the last non-error price?

I'm using importJSON to grab a number that represents the current price of a currency. Sometimes, the API isn't available and returns an error message. Is there a way for me to record the last non-...
0
votes
0answers
73 views

#Error! in ImportJSON formula in google sheets

I have been successfully using the following ImportJSON formula in google sheets: =ImportJSON(csgoempire.com/api/v2/metadata/roulette/history?seed=1997, "/", "noInherit,noTruncate,...
1
vote
0answers
28 views

Combine imported JSON with Google Forms data

I've been watching the protests unfold and I see a lot of police brutality from videos and descriptions people have shared online. I found a GitHub where all of this is collected and I want to use ...
2
votes
2answers
319 views

Convert columns of ISO 8601 strings to dates in Google Sheets

I'm pulling data to my sheet from an API using an ImportJSON function. The data array contains mixed data, including several columns of ISO 8601 date strings in UTC. For example: 2020-06-02T00:00:00Z ...
-1
votes
2answers
2k views

Fetching JSON in Google Sheets (ImportJSONAdvanced not defined?)

Currently working on fetching data from an API with Basic Authentication. Through this script: https://gist.github.com/anemitz/8cc6ef6c41ea4cefe51a13fbd6d8676a function ImportJSONBasicAuthentication(...
19
votes
2answers
45k views

How to import JSON data into Google Spreadsheets?

There is IMPORTXML function to import data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. Is there any similar solution to import data in JSON ...