Tariscope 4.6.Tariscope API guide
Tariscope API Methods
21. sql
This is a POST method that allows you to perform any query to the Tariscope database (select, insert, delete, update).
Note: We recommend that you carefully assess the risk of granting full access to perform this method.
The query parameters are specified in JSON format in the query body as an SQL query. Example of a query body to get the names of subscribers and their IDs that are included in the subscriber group with ID = 74
{
“query”: “select ID, FullName from Abonents where DepartmentID = 74”
}
Example query: