{
"statusCode": 200,
"statusDescription": "OK",
"numRows": 0,
"data": [ {} ],
"result": [
{
"data": {
"columnNames": [
"xxx", "yyy"
],
"numRows": 2,
"result": [
{
"xxx":"aaa", "yyy":"bbb"
},
{
"xxx":"ccc", "yyy":"ddd"
}
]
}
}
],
"elapsedTime": 6,
"errors": []
}
-------------------------------------------
JOLT: compare the 'result' value to the 'select' result (this operation is meaningful only if it returns a single result set)
--------------------------------------------
[
{
"operation": "shift",
"spec": {
"statusCode":"statusCode",
"statusDescription":"statusDescription",
"result": {
"*": {
"data": {
"columnNames":"columnNames",
"numRows":"numRows",
"result": "data"
}
}
},
"elapsedTime":"elapsedTime",
"errors":"errors"
}
}
]
--------------------------------------------
RESULT
--------------------------------------------
{
"statusCode" : 200,
"statusDescription" : "OK",
"columnNames" : [ "xxx", "yyy" ],
"numRows" : 2,
"data" : [ {
"xxx" : "aaa",
"yyy" : "bbb"
}, {
"xxx" : "ccc",
"yyy" : "ddd"
} ],
"elapsedTime" : 6,
"errors" : [ ]
}
CODE