Besides accessing your ParaSQL database directly using industry standard JDBC and ODBC interfaces, you can also access your database (both read and write) using ParaSQL's REST API. For example, you might use a tool like curl to securely read data from your database.
In its simplest form, a single line of code in a shell script might use curl to query a table in your database and export it to a local CSV file on your computer:
You can even paste the above URL into a web browser and download a CSV file.
In the above URL you would need to replace YOUR_API_KEY with a valid API Key. To create an API Key and set what permissions it has, see Tools > API Keys... (in the ParaSQL design window).
The next parameter is the action parameter; this tells the API what action to take. All other parameters depend upon the value of the action parameter and are thus described below.
Any of the actions may be used with either GET or POST. Any POST body must be x-www-form-urlencoded encoded.
Allows you to run an SQL query and retrieve the results in either CSV or JSON format.
Allows you to send an INSERT, UPDATE or DELETE statement to update the database. (A single INSERT statement may insert many rows in a single call; see the MySQL reference manual for details.)
This feature is configurable and must be enabled for your account.
This action allows you to convert an HTML document into a PDF file. The HTML must be in XHTML format meaning that all elements are closed (i.e. <br> will NOT work but <br/> will). Most of CSS 2.1 is supported.
Two parameters are required:
A PDF file will be generated and stored in the database's storage bucket. The response will look like the following:
In the above JSON response the "data" element is in ParaSQL DocumentField format. See the SQL/REST Documentation for example usage.
Responses to Server API calls are limited to ~32MB.
Actions must complete in less than 60 seconds.