Both the SELECT service and the OPERATION service return a similar error structure.
The only difference lies in the error.query parameter which is only returned by the OPERATION service.
{
status: "error",
error:
{
code: 120,
description: "Unknown column 'COTEL2' in 'field list'",
query: "UPDATE client_goose_DEV001.CON_TRO SET CORAS=..."
}
}The following error codes may be given:
|
Code
|
Description
|
|---|---|
|
50
|
Limit API calls exceeded: max 5 per second |
|
51
|
Limit API calls exceeded: max 50000 per day |
|
99
|
JSON format not valid |
|
100
|
Format field 'operation' not valid |
|
101
|
Format field 'code' not valid |
|
102
|
Format field 'key' not valid |
|
103
|
Format field 'table' not valid |
|
104
|
Format field 'id' not valid |
|
105
|
Format field 'fields' not valid |
|
106
|
Format field 'data' not valid |
|
107
|
Format field 'from' not valid |
|
108
|
Format field 'unknown' not valid |
|
110
|
Key not authorized |
|
111
|
IP or Key not authorized |
|
120
|
SQL Query error |
Do you want to ask us something?
Contact us at support@gooseapp.com