fluig_rm_query
Query TOTVS RM databases using stored SQL statements. Provide statement code, fields, and optional branch/application to retrieve read-only data.
Instructions
Query TOTVS RM through the stored-SQL bridge dataset: a registered statement code plus branch (CODCOLIGADA) and application (CODAPLICACAO). Read-only. The columns the statement returns must be declared.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| branch | No | CODCOLIGADA (default "0"). | |
| fields | Yes | Columns the statement returns. | |
| params | No | Extra statement parameters as {NAME: value}. | |
| application | No | CODAPLICACAO (default "G"). | |
| statementCode | Yes | RM statement code, e.g. "WS.247". |