API Server for Firebird

Designed to retrieve data from Firebird databases
through API requests

Features

The server is accessed through the standard GET, POST methods, the parameters of which specify SQL, written in JSON format. The query result is returned as an array of JSON format.

  • The server supports methods: GET, POST, PUT, DELETE . 
  • Ability to control:  GET only for SQL SELECT,  POST only for SQL INSERT, PUT only for SQL UPDDATE, DELETE only for SQL DELETE or option "POST for all" with check SELECT, INSERT, UPDATE, DELETE. Rights are determined for each user individually.
  • Connection - requires Basic Authorization, need username and password, registered on the server (button Users)
  • Monitoring all circulation processes.
  • Using. It can be used to access from JavaScript or PHP, and from mobile applications via web requests to databases located on computers with Windows.
  • Working conditions: For server operation is implied  dedicated IP address and port forwarding from the input router.

Settings

Allow HTTP

works as an HTTP server and allows you to receive files from a directory \htdocs

Allow SQL Commands

allows you to get results from fixed teams without authorization
by the name of the command a file must be formed in the directory \sql
example:
Command \users = http://127.0.0.1:8080/users => will use the file \sql\users.sql ,
the request may contain JSON parameters for SQL.; {"Date1": "01.01.2020", "Date2": "01.02.2020"} 

Parameters

Parameters in Body: JSON format
Request example:
{
"DB": {
"DatabaseName": "127.0.0.1:E:\\base\\Base.FDB",
"UserName": "user",
"Password": "pas" ,
"CharSet" : "WIN1251",
"SQLDialect": 1,
"RoleName": "",
"DBParams" : ""
},
"SQL": "Select id, name from USERS"
}

or sample default database query:
{
"SQL": "Select id, name from USERS"
}


Examples

SELECT response example:
{
"result": true,
"error": "",
"table": {
"fields":[
{
"name": "id",
"type": "Integer",
"type_code":500,
"size": 2
},
{
"name": "name",
"type": "String",
"type_code":448,
"size": 30
}
],
"rows": [
{
"id": 1,
"name":"user1"
},
{
"id": 2,
"name":"user2"
}
]
}
}


Example response for INSERT/UPDATE/DELETE:
{
"result": true,
"error": "",
}


Response example:
{
"result": false,
"error": "Erorr SQL parsing"
}


Response example:
{
"result": false,
"error": "No authorization"
}


Download API Server for Firebird

Purchase

Use license sold on 1 computer,
without limit on the number of users.
The price is 20 euros.
For purchase questions, send a message.

© Copyright 2020 Rikosoft - All Rights Reserved