Breaking News: Grepper is joining You.com. Read the official announcement!

Import Json

Add Answer

Precious Penguin answered on February 18, 2022 Popularity 10/10 Helpfulness 1/10

answer Import Json

related python import json

related py import JSON

Import Json

Comment

/**
* Imports JSON data to your spreadsheet Ex: IMPORTJSON("http://myapisite.com","city/population")
* @param url URL of your JSON data as string
* @param xpath simplified xpath as string
* @customfunction
*/
function IMPORTJSON(url,xpath){
  
  try{
    // /rates/EUR
    var res = UrlFetchApp.fetch(url);
    var content = res.getContentText();
    var json = JSON.parse(content);
    
    var patharray = xpath.split("/");
    //Logger.log(patharray);
    
    for(var i=0;i<patharray.length;i++){
      json = json[patharray[i]];
    }
    
    //Logger.log(typeof(json));
    
    if(typeof(json) === "undefined"){
      return "Node Not Available";
    } else if(typeof(json) === "object"){
      var tempArr = [];
      
      for(var obj in json){
        tempArr.push([obj,json[obj]]);
      }
      return tempArr;
    } else if(typeof(json) !== "object") {
      return json;
    }
  }
  catch(err){
      return "Error getting data";  
  }
  
}

Popularity 10/10 Helpfulness 1/10 Language javascript

Source: www.chicagocomputerclasses.com

Tags: import javascript json

Link to this answer
Share Copy Link

Contributed on Feb 18 2022

Precious Penguin

0 Answers Avg Quality 2/10

Closely Related Answers

python import json

Comment

import json
with open('filename.json', 'r') as file:
    json_data = json.load(file)

for key, value in json_data.items():
    print(key + ':' + str(value))

Popularity 10/10 Helpfulness 5/10 Language python

Source: Grepper

Tags: json

Link to this answer
Share Copy Link

Contributed on Nov 28 2023

Innocent Iguana

0 Answers Avg Quality 2/10

py import JSON

Comments(1)

with open(source_file) as source:
    json_source = source.read()
    data = json.loads('[{}]'.format(json_source))

Popularity 9/10 Helpfulness 2/10 Language whatever

Source: stackoverflow.com

Tags: import im

Link to this answer
Share Copy Link

Contributed on Sep 21 2022

Glorious Grebe

0 Answers Avg Quality 2/10

Import Json

Contents

More Related Answers

Import Json

Closely Related Answers

python import json

py import JSON

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.