DBExec-return
This JSON is the data structure returned by the DBExec() function; this JSON data structure is also returned when executing SQL statements using the exec() method of objects created by the Dial() function.
Attributes
| Name | Type | Description |
columns | array | Column names of the queried data, string array. |
values | array | The specific data queried, where each data item corresponds to the column names. The values field is a two-dimensional array, with each element being an array representing one data record. |
See Also
Remarks
Example of querying data from database:
json
{
"columns":["TS","HIGH","OPEN","LOW","CLOSE","VOLUME"],
"values":[
[1518970320000,100,99.1,90,100,12345.6],
[1518960320000,100,99.1,90,100,12345.6]
]
}