Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [json]

The tag has no usage guidance.

0
votes
0answers
21 views

Import a JSON query from https://finance.vietstock.vn

I've trying this for several days and I'm not able to load the data displayed below the graph in https://finance.vietstock.vn/VIC/tai-chinh.htm IMPORTHTML does not work because these fields are the ...
1
vote
1answer
16 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 {} ...
-2
votes
3answers
29 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
1answer
37 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, ...
2
votes
1answer
324 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--...
3
votes
1answer
6k 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 ...
17
votes
1answer
32k 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 ...
0
votes
1answer
569 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’...
1
vote
3answers
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: ...