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
Payroll → Get Calculation
AI-generatedSummary
Retrieve payroll calculation records from the TOTVS RM system using an optional SQL filter and selecting specific fields.
Inputs
- SQL Filter — A standard RM SQL filter string to narrow results, supporting operators like =, LIKE, AND, OR, IN. Example: CODCOLIGADA=1 AND CODSITUACAO='A'
- Select Fields — Comma-separated list of payroll calculation fields to return. Leave empty to return all fields.
- Company Code Override — Numeric value to override the company code from credentials. Use 0 to apply the credential's default.
- RM Context — Additional RM context string in the format 'KEY=VALUE;' to override credential defaults for this request.
Output shape
A list of payroll calculation records matching the filter, each represented as a JSON object with the chosen fields.
If no SQL filter is provided, all payroll calculations are returned (subject to default pagination if applicable). Selecting specific fields filters the output data. Errors during request execution are returned per item if 'Continue On Fail' is enabled, otherwise the node errors out.
Examples
Example 1: Get payroll calculations where company code equals 1 and status is active, returning only employee badge and department codes.
Set SQL Filter to 'CODCOLIGADA=1 AND CODSITUACAO='A'', set Select Fields to 'CHAPA,CODSECAO'
Example 2: Retrieve all payroll calculations without filtering, showing all available fields.
Leave SQL Filter and Select Fields empty.