Function
This object is used to query the CRM+ system.
Please see the following page on how to build a query successfully: CRM+ Querying
Parameters
| Parameter | Purpose |
|---|---|
| Object Name | The name of this object instance |
| Query | The SQL query to be executed. For example: SELECT * FROM Contacts WHERE phone='%2B$caller'; |
Outputs
| Output | Used when ... |
|---|---|
| OK | A 200 result is retrieved which is not empty (result.* contains data). |
| Not Found | All other http results and also 200 results, where the retrieved result is empty. |
| Error | When a technical error happens trying to access the service. |
Variables Provided
| Variable | Provided | Contains |
|---|---|---|
| $crmplus.url | Always | The URL pointing to the CRM+ instance. |
| $crmplus.* | When data is retrieved | Variables containing all retrieved data from the JSON result. |
Release
FROM RELEASE 3.26