2022.2

l
a JSON Record Data List (see the REST API Cookbook). A JSON Record Data List is a pro-
prietary JSON object type. It includes a schema entry with information about the types of all
fields at the beginning of the record, and the data set with values after the schema. This structure
allows for easy handling of REST API return values through scripting in Workflow or in the
Designer; see "JSON Record Data List example" on the facing page.
JSON string examples
The following JSON string samples show various techniques to incorporate data in a JSON string.
A simple JSON structure holding the first and last name of a person:
{
"first": "Peter",
"last": "Parker"
}
A JSON string with references to local variables and a Job Info variable (see "About variables" on
page238):
{
"first":"%{first}",
"last":"%{last}",
"email":"%2"
}
A JSON string containing a local variable and various Data Repository selections (see "Data Repos-
itory lookups" on page51):
{
"jobid":"%{jobid}",
"account":"lookup(OLCS_jobs, account, jobid, '%{jobid}')",
"datafile_name":"lookup(OLCS_jobs, datafile_name, jobid, '%{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 selec-
tions" on page53):
Page 78