PRODUCT
PLUGINS
RESOURCES
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.
Windows 64 bit ODBC Driver
Click to download the MSI file.
Be sure to enable Force TLS Use when configuring the DSN.
Java JDBC Driver
Click to download the JDBC driver.
All MariaDB Connectors
Click to visit the MariaDB Connector download page.
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.
If responseFormat was CSV:
If responseFormat was JSON:
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.
Note that all API requests: