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