2021.1

JSON Record Data List (with Email Parameters)
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, along with additional parameters used specifically
in an content creation operation for email.
This structure is variable, allowing specification for email output to either the file store or directly
to a SMTP mail server, with a number of additional parameters.
This structure is used specifically by the Content Creation (Email) service when creating
content directly without the prerequisite of the data mapping process.
Structure
The structure initially consists of an object with the following name/value pair:
l data – the data for the data record or data records, consisting of either an object or an
array of one or more objects respectively with the following name/value pairs:
l schema – the data table schema for the data record, consisting of an object with the
following name/value pairs:
l columns – a list of the data columns/fields in the data table schema and their
corresponding data types, consisting of an object with one or more
name/value pairs:
l <name> – the name (name) and data type of the data field (value of either
BOOLEAN, STRING, HTMLSTRING, INTEGER, FLOAT, DATETIME or
CURRENCY) (type of string)
l tables – a list of any nested data tables in the data record, consisting of an
object with one or more name/value pairs:
l <name> – the name (name) of the data table and the data table schema
for the data records it contains, consisting of an object with the following
name/value pair:
l columns – a list of the data columns/fields in the data table schema
and their corresponding data types, consisting of an object with
one or more name/value pairs:
l <name> – the name (name) and data type of the data field
(value of either BOOLEAN, STRING, HTMLSTRING,
INTEGER, FLOAT, DATETIME or CURRENCY) (type of
string)
Page 119