ImportJSON
ImportJSON copied to clipboard
bradjasper
Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet
I am doing some API calls from a game server that I'm playing with. And I using a different sheet to pull API information, and another to parse and display...
ImportJSONFromSheet tries to read the whole spreadsheet and parse the json on it. On my use case I had a spreadsheet with a different json objects per row and mixed...
I just want to request json when I open the spreadsheet Now this function request too many times to my server Could I restrict the function to request in case...
Hello all, First of all, thank you to Brad and Tommy and the rest of the contributors for making such a useful script. It will be hugely helpful to me...
``` // Insert the data //*********************my code if (value == null) { data[state.rowIndex][headers[path]] = "null"; return true; } else { //******* data[state.rowIndex][headers[path]] = value; dataInserted = true; } ```
Hi, I'm using the script 17 times in one sheet and everyday it works and it's getting the data for few times then after that it doesn't get any data...
If !rawHeaders is set, then I modified this: ```Javascript function defaultTransform_(data, row, column, options) { if (data[row][column] == null) { if (row < 2 || hasOption_(options, "noInherit")) { data[row][column] =...
I want to have the query to update the importjson command at specific times. I can do this using an automatic update trigger which I can set at specific times....
The JSON server that I am using limits the data per page, and I would like to consult all the pages that have in the database, How do I inform...
Hello, I am using this script ImportJSON to import data market into my spreadsheet and I am getting this kind of Error. I know that google sheets has a limit...
Metadata
Owner
Metadata
Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet