API: Error Management

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

Trial
Administration
User Area
To login, simply fill out the fields below.

We use cookies to assure the website’s functionality and to take into account your browsing choices in order to offer you the best experience on our website. In addition we reserve the right to use third-party cookies. To learn more please see our Privacy Policy and Cookie Policy. By continuing to browse the website, the user agrees to use cookies.
OK