8.8

Table Of Contents
allows for easy handling of the results through scripting in Workflow or in the Designer.
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,
"ItemOrdered": false
}
},
{
Page 610