Run a SELECT query
vtiger_queryRun your own read-only query: SELECT <fields|*|count(*)> FROM [WHERE ...] [ORDER BY ...] [LIMIT offset,count]. One module only, no joins, no grouping brackets; at most 100 records per call. Only SELECT is accepted. GET /query.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | Example: select id,firstname,lastname from Contacts where mailingcity = 'Boston' or mailingcity = 'Austin' order by createdtime desc limit 0,25 |