TOTVS RMInstall

Summary

List records from a specified TOTVS RM DataServer with optional filtering, pagination, field selection, and ordering.

Inputs

• DataServer Name (required) — Exact name of the DataServer to query (e.g. FopFuncData). Use 'List Available DataServers' under the framework resource to discover options.
• SQL Filter — SQL-style filter string supporting =, LIKE, AND, OR, IN to restrict returned records (e.g., NOME LIKE '%JOHN%').
• Page Size (limit) — Maximum number of records to retrieve per page, between 1 and 500. Defaults to 50.
• Offset (start) — Offset to start retrieving records from, for pagination. Defaults to 0.
• Order By — Field and direction to order results by (e.g., NOME ASC).
• Select Fields — Comma-separated list of specific fields to return. Leaves empty to return all fields.
• Company Code Override — Numeric company code to override credential default. Use 0 to apply credential's company code.
• RM Context — Additional context string for RM parameters (e.g., CODSISTEMA=S;CODUSUARIO=admin;CODFILIAL=1). Defaults to credential context if empty.

Output shape

a list of JSON objects representing the requested records

Records are returned in an array. Pagination is controlled via 'start' and 'limit' parameters. The output respects 'select' for returned fields and applies the SQL 'filter' for record selection. Errors per item may be included if 'Continue on Fail' is enabled.

Links

• n8n community nodes installation guide