Sign In

Database Connectors

AppSynergy uses MariaDB for its SQL database. This means you can use standard MariaDB and MySQL connectors and software to access your database. The recommended connectors are linked below.

You will need to create an API Key to grant access to any external users. See Tools > API Keys for details.

dataset_linked

Windows 64 bit ODBC Driver

Click to download the MSI file.
Be sure to enable Force TLS Use when configuring the DSN.

dataset_linked

Java JDBC Driver

Click to download the JDBC driver.

dataset_linked

All MariaDB Connectors

Click to visit the MariaDB Connector download page.

RESTful SQL API

SELECT

Execute a SQL query and return the results in either JSON or CSV format. The Security Role assigned to the API Key determines what is accessible.

Request

POST https://www.appsynergy.com/api?action=EXEC_QUERY&apiKey=YOUR_API_KEY { "sqlCmd": "SELECT * FROM MyTable", "responseFormat": "JSON" }

Response

If responseFormat was CSV:

Customer_ID,Name 1000,"Company A" 1001,"Company B"

If responseFormat was JSON:

{ "status": "OK", "errorMessage": "", "errorCode": "", "data": { "columns": [ { "tableName": "Customers", "columnName": "Customer_ID", "datatype": "BIGINT" }, { "tableName": "Customers", "columnName": "Name", "datatype": "VARCHAR" } ], "rows": [ { "values": [ { "value": "1000" }, { "value": "Company A" } ] }, { "values": [ { "value": "1001" }, { "value": "Company B" } ] } ] } }

INSERT/UPDATE/DELETE

Execute a SQL DML statement (i.e. INSERT/UPDATE/DELETE) and return the number of rows affected. The Security Role assigned to the API Key determines what can be modified.

Request

POST https://www.appsynergy.com/api?action=EXEC_DML&apiKey=YOUR_API_KEY { "sqlCmd": "UPDATE MyTable SET MyCol = 123 WHERE ID = 100" }

Response

{ "status": "OK", "errorMessage": "", "errorCode": "", "data": { "rowsAffected": 1 } }

API Limitations

Note that all API requests: