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
Customers / Suppliers → Get Person
AI-generatedSummary
Retrieves a single customer or supplier record from the TOTVS RM database using an optional SQL filter.
Inputs
- SQL Filter — Standard RM SQL filter. Supports: =, LIKE, AND, OR, IN. Example: NOME LIKE '%JOHN%'.
- Select Fields — Comma-separated list of fields to return. Leave empty to return all fields.
- Company Code Override — Leave 0 to use the company code configured in the credential.
- RM Context — Additional RM context string. Leave empty to use credential defaults.
Output shape
a single record
If the API returns an array, it is wrapped in an array for n8n output.
Examples
Example 1: Retrieve a person by name
Set SQL Filter to 'NOME LIKE ''%SMITH%''' and leave other fields empty.
Example 2: Retrieve only specific fields for a person
Set Select Fields to 'CODIGO,NOME,TELEFONE' and leave SQL Filter empty.