How to convert a string to JSONPath

Question

I have a JSON object that has a few nested levels in it.

I am given a string that refers to the location of a specific object.

For instance, if my JSON object looked like:

countries: [
     canada: {
          capital: "ottawa",
          territories: [
               yukon: {
                    capital: "yellowknife",
                    ...
               }
               ...
          ]
          ...
     }

and I'm given the string

"countries.canada.territories.yukon"

I want to get the object for Yukon.

How can I do this?

Community · Accepted Answer · 2017-05-23 12:34:19Z

3

I use this,

function jsonPathToValue(jsonData, path) {
    if (!(jsonData instanceof Object) || typeof (path) === "undefined") {
        throw "InvalidArgumentException(jsonData:" + jsonData + ", path:" + path);
    }
    path = path.replace(/\[(\w+)\]/g, '.$1'); // convert indexes to properties
    path = path.replace(/^\./, ''); // strip a leading dot
    var pathArray = path.split('.');
    for (var i = 0, n = pathArray.length; i < n; ++i) {
        var key = pathArray[i];
        if (key in jsonData) {
            if (jsonData[key] !== null) {
                jsonData = jsonData[key];
            } else {
                return null;
            }
        } else {
            return key;
        }
    }
    return jsonData;
}

A test,

json = {"a1":{"a2":{"a3":"value"}}};
console.log(jsonPathToValue(json, "a1.a2.a3")); //=> shows: value

Inspired from here.

edited May 23, 2017 at 12:34

CommunityBot

11 silver badge

answered May 6, 2017 at 10:21

Georgios

20.2k9 gold badges99 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Moriarty Over a year ago

I feel like there must be a better way to do this

Joe Thomas · Accepted Answer · 2014-12-24 09:02:12Z

1

Probably not the most effecient way, but it works.

var n= {JSON};
var c="countries.canada.territories.yukon".split('.');
var p=n;
for(var i=0;i<c.length;i++){
   p=p[c[i]];
}
console.log(p);// p is your Yukon Element

if you want to edit the element use the eval function:

var myJSON= {JSON};
var c="countries.canada.territories.yukon";
c='myJSON["'+c+'"]';
c.replace(/\./g,'"]["');
eval(c+'={COOL_JSON_CODE}')
console.log(myJSON);// the Yukon element has cool new json code in it now

edited Dec 24, 2014 at 9:02

answered Dec 23, 2014 at 21:59

Joe Thomas

6,5376 gold badges29 silver badges38 bronze badges

1 Comment

CodyBugstein Over a year ago

The only problem with this is that it gives me the value of the object but not the reference. I can't update the object with p

CodyBugstein · Accepted Answer · 2014-12-24 11:26:06Z

0

I came up with a way to get it to work. It doesn't seem "right" but it's still an answer. (I will mark as accepted any answer better than this)

for (var key in currentObject){
       delete currentObject[key];
}

This clears out the Yukon object.

Updated fiddle: http://jsfiddle.net/ay1wpr5L/3/

answered Dec 24, 2014 at 11:26

CodyBugstein

23.5k69 gold badges226 silver badges386 bronze badges

1 Comment

FMaz008 Over a year ago

That's not answering the question you asked though...

Ahmad Qureshi · Accepted Answer · 2021-05-12 09:26:11Z

0

You can use eval function of javascript to evaluate the final result, Solution would look something like this

let countriesObj = {<your json object>}
let path = "countries.canada.territories.yukon";
let properties = path.split(".");
let propertyStr = "";
for(let property in properties){
    propertyStr+="['"+properties[property]+"']"
}

let result = undefined;
let expression = "result = countriesObj"+propertyStr+";";
eval(expression);
return result;

this will give you the exact result

answered May 12, 2021 at 9:26

Ahmad Qureshi

1884 silver badges20 bronze badges

Collectives™ on Stack Overflow

How to convert a string to JSONPath

4 Answers 4

1 Comment

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related