Query By SQL API
Overview
This API endpoint retrieves processed entries by SQL in an app, identified by :app_id. You can use standard SQL syntax to manipulate all data sources in an APP.
!You can only retrieve data with this endpoint. Only **Select Clause** is allowed.
Endpoint
POST https://api.myboardtoday.com/app/:app_id/query
Path Parameters
- app_id (required): The unique identifier (uuid) of the app.
Request Body
- query (required, string): The query SQL. Simply treat a source as a database table and a field in the source as a column. Field names and source names are case sensitive and should always be escaped with backquote "`"!Field names and source names are case sensitive and should always be escaped with backquote "`"
Headers
- x-api-key (required): The API key for authentication.
Report Bugs, Request New Features, and Win $50 Every Month
We value your precious feedback. Please contact us when you find a bug or would like to request a new feature. (In the main panel, click on the bob logo on the top left corner, then in the Dropdown menu click on “contact for bugs or new features”). Every month we will select an “opinion leader” and reward him/her with $50 in cash.