Strictly speaking, this is not an integration item as the following SQL calls can only be made from within the application. However, they can provide useful information for other activities.
There are two ways SQL calls can be made:
1. Go to Charts & Reports, click on + New Report and then select SQL Console
2. Go to Settings (small cog, lower left of the screen), click on SQL Console
It is imperative that any calls made to a database contain the correct syntax. This being the case, the allowable SQL calls are included in the attached TXT file. Please copy the calls directly from your browser or download as a TXT file.