TOTVS RMInstall

Summary

Fetches accounting entries from the TOTVS RM Accounting Entry module by calling the CttLancData DataServer REST endpoint. The node authenticates with the configured TOTVS RM credential, obtains a JWT, and sends a GET request to <baseUrl>/rmsrestdataserver/rest/CttLancData. The only parameter that affects this operation is SQL Filter: when set, it is sent as the filter query parameter in RM filter syntax (supports =, LIKE, AND, OR, IN; for example CODCOLIGADA=1 AND CODSITUACAO='A'), so use it to select the entry or entries to retrieve. Leave it empty to request without a filter. Select Fields, Company Code Override, and RM Context are displayed in the UI for this operation but are not used by the readRecord implementation. The DataServer response is parsed as JSON and returned as the node output; if the response is an array, each element becomes one output item, otherwise the object is wrapped in an array. Each output item includes a pairedItem reference to the input item that produced it.

Inputs

• SQL Filter — Standard RM SQL filter sent as the filter query parameter. Supports =, LIKE, AND, OR, IN. Example: NOME LIKE '%JOHN%'. This is the only parameter that affects the Get Entry request.
• Select Fields — Declared in the UI for readRecord, but not used by the Get Entry implementation.
• Company Code Override — Declared as a company code override, but not used by the Get Entry implementation.
• RM Context — Declared as additional RM context, but not used by the Get Entry implementation.

Output shape

json

Returns the parsed JSON response from the CttLancData DataServer. If the response is an array, each element becomes one output item; otherwise the object is wrapped in an array. Each output item includes a pairedItem reference to the input item that produced it.

Links

• n8n community nodes installation guide