XPath for Json String

Question

I have JSON string like below :

{
    "ConfigurationJsonResult":
    [
        2246,
        2247,
        2248,
        2249,
        2250,
        2251,
        2252,
        2253,
        2254,
        2255
    ]
}

My problem is i want to get 1st value i.e 2246 using xPath.

I have tried using /ConfigurationJsonResult[1] but it gives me [2246,2247.....2255], i just want 2246. How to achieve it.

It is called JSONPath according to the link and it is not XPath — Mosty Mostacho
– Mosty Mostacho, Commented Dec 5, 2013 at 6:29
@Popeye the link you have posted describes a library to parse json data using jsonpath which is analogous to xpath but not xpath itself. With standard js functions you cannot do it. However you can translate a xpath to jsonpath and do it using simple function. — Vikram Rao
– Vikram Rao, Commented Dec 5, 2013 at 6:38

Vikram Rao · Accepted Answer · 2013-12-05 06:48:23Z

1

You can write a mapping function to convert xpath to jsonpath and use converted string to access the data.

function xpathToJsonPath(xpath) {
   var jsonPath = xpath.replace("//","..");
   //Simillarly other mappings
   return jsonPath;
}

var data = jsonPath(object, xpathToJsonPath("$..author"));

Mappings are given the link you have shared - http://goessner.net/articles/JsonPath/

You can do plenty of improvements on this like extending this as a function to prototype etc.

answered Dec 5, 2013 at 6:48

Vikram Rao

5063 silver badges16 bronze badges

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

1 Comment

erikbstack Over a year ago

In some regards such a translation is actually a nice idea. It's also possible to take a json file, json.reads() it and then print it as xml to use libxml2 support. For the given usecase it's too much of an overhead though, imho.

Collectives™ on Stack Overflow

XPath for Json String

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related