Query
Use this web serivce to run SQL queries against the myAvatar database. Note: This is only supported on systems running Caché 2017 or higher.
This service contains the following call:
- SubmitQuery
SubmitQuery
The SubmitQuery call has four parameters: SystemCode, UserName, Password and Query. The properties, dictionaries, and default values are listed for each parameter in the tables below.
Parameters with no Properties
| Parameter | Property | Value Accepted | Notes |
| SystemCode | N/A | Avatar System Code | Examples: SAMPLE, LIVE, UAT,etc. |
| UserName | N/A | Avatar User ID | |
| Password | N/A | Avatar Password | |
| Query | SQL Query |