Actions41
- ── Framework ── Actions
- DataServer (Generic) Actions
- Employees (HR) Actions
- Payroll Actions
- Invoice (Stock) Actions
- Stock Movement Actions
- Accounts Payable/Receivable Actions
- Accounting Entry Actions
- Customers / Suppliers Actions
- Users Actions
- Companies Actions
- Enrollment (Education) Actions
Accounts Payable/Receivable → List Entries
AI-generatedSummary
Retrieve a list of financial entries (accounts payable/receivable) from the TOTVS RM ERP system using flexible filtering, pagination, sorting, and field selection.
Inputs
- SQL Filter — Apply a standard RM SQL filter to narrow down entries. Supports operators like =, LIKE, AND, OR, IN. For example: CODCOLIGADA=1 AND CODSITUACAO='A'.
- Page Size (limit) — Set the maximum number of entries to return, between 1 and 500. Defaults to 50.
- Offset (start) — Specify the starting index for pagination (zero-based). Defaults to 0.
- Order By — Define the sorting order of results, e.g. "NOME ASC".
- Select Fields — Provide a comma-separated list of specific fields to return. If empty, all fields are returned.
- Company Code Override — Override the company code (CODCOLIGADA) used for the request; leave 0 to use the company code set in credentials.
- RM Context — Additional RM context string (e.g., CODSISTEMA=S;CODUSUARIO=admin;CODFILIAL=1). Leave empty to use default credential context.
Output shape
a list of financial entry records, each represented as a JSON object
Results reflect applied filter, pagination (start and limit), ordering, and selected fields. The response is always an array of JSON objects. Errors may appear as error messages within each result item if 'Continue on Fail' is enabled.