api.nisa.digital
2025-08-28
Comprehensive guide to our Pohoda/Pamica endpoints
/v1/sql/:uid
Run a read-only SQL SELECT for a unit and return rows.
Example
/v1/sql/88899460-4d0b-421b8d67-2023
Params
:uid - accounting unit identifier
Request
POST
text/plain
Request body is sql in plain text. Only SELECT allowed. Use :db placeholder for current unit DB.
POST
text/base64
Request body is base64 encoded sql. Only SELECT allowed. Use :db placeholder for current unit DB.
Response
200
text/json
{ json object }[]
Error Codes
400
Bad Request
Your request doesn't meet the required input format
401
Not Authorized
Your request doesn't meet authorization requirements
404
Not Found
The entity you're looking for is missing
460
Request Error
Requested operation wasn't performed, or XML import failed
500
Internal Error
We encountered an internal server error
503
Not Available
Requested entity is offline and cannot be reached, try again later
/v1/sql/one/:uid
Run a read-only SQL SELECT for a unit and return a single row.
Example
/v1/sql/one/88899460-4d0b-421b8d67-2023
Params
:uid - accounting unit identifier
Request
POST
text/plain
Request body is sql in plain text.
POST
text/base64
Request body is base64 encoded sql.
Response
200
text/json
{ json object } || null
Error Codes
400
Bad Request
Your request doesn't meet the required input format
401
Not Authorized
Your request doesn't meet authorization requirements
404
Not Found
The entity you're looking for is missing
460
Request Error
Requested operation wasn't performed, or XML import failed
500
Internal Error
We encountered an internal server error
503
Not Available
Requested entity is offline and cannot be reached, try again later