How to access String name and price from this JSON data?

Question

I have established a connection but unable to access data.Help needed JSON data

[
    {
        "name": "Margherita",
        "price": 170
    },
    {
        "name": "Corn MAnia",
        "price": 170
    },
    {
        "name": "Triple Tango",
        "price": 210
    }
]

possible duplicate of https://stackoverflow.com/questions/9605913/how-to-parse-json-in-android — Ramesh sambu, Dec 11 '17 at 15:07
Possible duplicate of [How to parse JSON in Android](https://stackoverflow.com/questions/9605913/how-to-parse-json-in-android) — Johan, Dec 11 '17 at 15:15

score 0 · Answer 1 · edited Dec 22 '17 at 09:28

In MarkLogic Server, you can use the XPath language to traverse JSON and retrieve data. Code can be written in the Xquery language or Server Side JavaScript:

xquery version "1.0-ml";
let $doc:= xdmp:unquote('{"root":[{"name": "Margherita","price": 170}, {"name": "Corn MAnia","price": 170}, {"name": "Triple Tango","price": 210}]}')
return xdmp:document-insert('/doc/names.json', $doc)

To get data, use:

doc('/doc/names.json')/root[1]/name

or

doc('/doc/names.json')/root[2]/price/data()

How to access String name and price from this JSON data?

1 Answers1