Extract values from JSON array using XPath?

Question

I'm pretty new to XPath... I need to extract only the values 2124,143 from this JSON array using XPath.

I tried few ways but didn't succeed. Any idea?

{  
       "legend_size":1,
       "data":{  
          "series":[  
             "2016-06-01",
             "2016-07-01"
          ],
          "values":{  
             "Download":{  
                "2016-07-01":143,
                "2016-06-01":2124
             }
          }
       }
    }

kjhughes · Accepted Answer · 2016-07-02 20:05:03Z

1

XPath (traditionally, prior to v3.1, which is not widely supported) is defined over XML, not JSON.

Alternatively, consider JSONPath, an "XPath for JSON," which is also supported by Dojo Toolkit.

In JSONPath, 2124 could be accessed as $.data.values.Download.2016-06-01

edited Jul 2, 2016 at 20:05

answered Jul 2, 2016 at 17:13

kjhughes

113k31 gold badges198 silver badges276 bronze badges

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

Comments

Michael Kay · Accepted Answer · 2016-07-02 19:23:52Z

0

In XPath 3.1, it would be

let $j := parse-json($input)
return array:for-each($j?data?series,
   function($date) {$j?data?values($date)})

XPath 3.1 is the first version of XPath to support JSON as well as XML.

answered Jul 2, 2016 at 19:23

Michael Kay

165k11 gold badges97 silver badges173 bronze badges

Collectives™ on Stack Overflow

Extract values from JSON array using XPath?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related