2021.1

{jobid}')",
"pages":"lookup(OLCS_jobs, pages, jobid, '%{jobid}')",
"documents":"lookup(OLCS_jobs, documents, jobid, '%{jobid}')",
"recordsetid":"lookup(OLCS_jobs, recordsetid, jobid, '%{jobid}')"
}
An example where the entire JSON string is provided in a Job Info variable:
%1
A JSON string constructed with information retrieved from an XML job data file (see "XML data
selections" on page60):
{
"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","ExtraData":"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.
[
{
"schema": {
"columns": {
"ID": "STRING",
"Date": "DATETIME"
Page 93