2022.2

{
"first":"xmlget('/request[1]/values[1]/first[1]',Value,KeepCase,NoTrim)",
"last":"xmlget('/request[1]/values[1]/last[1]',Value,KeepCase,NoTrim)",
"email":"xmlget('/request[1]/values[1]/email[1]',Value,KeepCase,NoTrim)"
}
A JSON string that contains nested data:
{
"name":"Peter Parker",
"email":"parkerp@localhostcom",
"ExtraData":"foobar",
"detail": [{"id":"inv123","ExtraData":"hello"},{"id":"456","Ex-
traData":"world"}]
}
JSON Record Data List example
A JSON Record Data List describes a list of data fields (as name/value pairs), a data table schema and
nested data records (if any) for one or more data records. Below is an example of such a JSON Record
Data List.
{
"data": {
"schema": {
"columns": {
"ID": "STRING",
"Gender": "STRING",
"FirstName": "STRING",
"LastName": "STRING"
}
},
"fields": {
"ID": "CU00048376",
"Gender": "M.",
"FirstName": "Benjamin",
"LastName": "Verret"
}
}
}
For more examples, see the REST API Cookbook.
Page 79