Questions tagged [json]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
2 answers
187 views

Converting Google Sheet to JSON format while rows are vertical

I am trying to convert the Google Sheets into JSON format using Google App Script. It worked but I am not getting the right format and I am little struck. My sheet looks something like this in the ...
1 vote
1 answer
47 views

How to import a JSON-style table [['a', 'b'], ['c', 'd']] into Google Sheets?

Let's say I have copied a JSON-style string like this: [['a', 'what\'s up'], ['c', 'd']] into the clipboard (for example copied from my browser Dev Console, after some JS code). How can I easily ...
1 vote
1 answer
127 views

Trying to open an attachment in Slack: `{"ok":false,"error":"team_not_found"}` when clicking on "see it in full"

I am trying to open an attachment (JSON file, a few KBs) in Slack that someone sent me and get the error: {"ok":false,"error":"team_not_found"} when clicking on "...
1 vote
1 answer
90 views

Google sheets returning correct value from json data

Example sheet to clarify my problem: https://docs.google.com/spreadsheets/d/1e04XmYkirDJCucCv5Z1czCtg2OQkJfWyThjhF3uz8FQ/edit?usp=sharing I am fetching json data from a server, however on some fetches ...
3 votes
1 answer
508 views

Regex for JSON parsing in Google Spreadsheet Cell

I wanted to use the formula from this topic to extract "count" value in this JSON from a Google Sheet cell. [{"year":2022,"month":2,"count":720},{"year&...
0 votes
0 answers
20 views

How to get the RSS feed for a given Twitter user's posts without paying money?

First of all, Twitter has engineered their website to make it impossible (for me, and most) to extract any data from it. It fetches everything with JavaScript as massive JSON blobs and using all kinds ...
1 vote
2 answers
183 views

Splitting JSON-Formatted Single Column Into Rows and Columns in Google Sheets

PROBLEM Since Google Sheets doesn't natively support JSON data, which I'm importing, I'm trying to split the data into a matrix of four columns and an unfixed number of rows using only Google Sheets's ...
2 votes
1 answer
570 views

How to export (in JSON) a filtered view?

I use Google Spreadsheets as a "web service" to generate a JSON having the information to display in my website. It is OK to export a JSON file: var url = 'spreadsheets.//list/1gRIVkL117xxG8m9nQRa--...
4 votes
2 answers
9k views

Import JSON to Google Sheet using Google Apps Script

I am using Apps Script in Google Sheets to import JSON from Google Analytics. I have previously used the ImportJSON function to easily get the JSON from an open API just using =ImportJSON(url) within ...
5 votes
1 answer
9k views

Parse JSON from Google Spreadsheet Cell

I am working on an API with google spreadsheet and app script to retrieve JSON response; I am using ImportJSON function (custom function by Brad Jasper and Trevor Lohrbeer) to retrieve and parse JSON ...
-1 votes
3 answers
2k views

Parsing a non-nested JSON string in Google Sheets using formulas only

I have a cell with the following JSON data: {"rev2_0": "2,058", "rev2_1": "2,099", "rev2_2": "2,141", "rev2_3": "2,184", "revchg3_0": "3%", "revchg3_1": "6%"} In another cell, I want to get the ...
1 vote
1 answer
71 views

Extract Value from Poorly formed JSON result

I have a Google script that returns the following result set, but when I try to get the value for asking_price or asking_price_condition it comes back undefined. I assume it's because of some {} ...
1 vote
1 answer
589 views

Custom Script in Pivot Table Value Formula = Error Loading Data forever

I am very new to the Google Sheets platform, but I am not new to programming, and am comfortable creating and managing javascript code, and reading API documentation. I am working on a side project, ...
1 vote
3 answers
8k views

How can I retrieve records from a Google Spreadsheet in JSON format? [closed]

I'm trying to retrieve data from Google Spreadsheets with no success. I've gone through this: http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#RetrievingTables and this: ...
0 votes
1 answer
643 views

Get Published Google Doc in JSON

I have a published Google Doc at https://docs.google.com/spreadsheet/pub?key=0AtjON-ccqVTgdDhKeGx0UlZpUWUyLTFZV2szQlJyNnc&output=html that I want to retrieve in JSON. I've been trying this but it’...