Does NAV 2018 have the ability to use jsonpath to navigate a json file? Xpath works with XML files but I don’t think jsonpath works but maybe I am using the wrong format.
{
“book”: {
“title”: “Book Title goes here”,
“numberOfPages”: “100”
}
}
Using the above made up example other languages would allow the syntax below to retrieve the value 100:
$book.numberOfPages
Check out codeunit 1237 Get Json Structure and 5459 Json Management.
Thanks for the reply!
Codeunit 1237 is for transforming Json to XML. Codeunit 5459 is what I am using for all of my json work but there isn’t anything that jumps out at me in there that will do what I am asking.
Any other thoughts?
Take a look at ParseWebResponseError in codeunit 1297 Http Web Request Mgt.
The JSONMgt.GetValue looks like what you’re after.