The JSON array format is similar to the JSON object format, except instead of a JSON object per row, there is a JSON array per row where each column value is an element in the array.
The following is an example JSON array response to SELECT * FROM DBC.DBCInfo with includeColumns set to true.
{
"queryDuration": 11,
"queueDuration": 3, "results": [
{
"columns": [
{
"name": "InfoKey",
"type": "VARCHAR"
},
{
"name": "InfoData",
"type": "VARCHAR"
}
],
"data": [ [
"VERSION", "15.00.00.01"
], [
"LANGUAGE SUPPORT MODE",
"Japanese"
], [
"RELEASE", "15.00.00.01"
]
],
"resultSet": true, "rowCount": 3, "rowLimitExceeded": false
}
]
}