...
Below is the single parameter for making an SQL POST request.
Parameter | Required | Data Type | Options | Notes |
|---|---|---|---|---|
sql | yes | string |
SQL SELECT statement |
Using the Data Dictionary
...
| Code Block | ||
|---|---|---|
| ||
POST DOMAIN/KEY/sql.json |
Headers:
Key | Value |
|---|---|
Content-Type | application/json |
Pcr-Html-Encoded | TRUE |
Body:
Key | Value |
|---|---|
sql | SELECT RECID FROM SERVICES |
This call will be expected to RECIDs from the SERVICES Table in JSON format.
...