8.7

Table Of Contents
l
Output records in Json: Select to output the records in JSON format. This allows
easy handling of the results through scripting in Workflow or in the Designer.
The JSON structure 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 is an example of the JSON output:
[
{
"schema": {
"columns": {
"ID": "STRING",
"Date": "DATETIME"
},
"tables" : {
"detail": {
"columns": {
"ItemTotal": "CURRENCY",
"ItemShipped": "FLOAT",
"ItemOrdered": "BOOLEAN"
}
},
"detail2": {
"columns": {
"ItemUnitPrice": "CURRENCY",
"ItemOrdered": "INT"
}
}
}
},
"id": 3678077,
"datasetid": 2392921,
"fields": {
"ID": "CU19762514",
"Date": 1331096400000
},
"tables": {
"detail": [{
"id": 3678078,
"fields": {
"ItemTotal": "2300.00",
"ItemShipped": 2.0,
Page 566