SankhyaInstall

Summary

Queries multiple records of a Sankhya entity using a Gateway service, supporting filtering, field selection, and pagination.

Inputs

• rootEntity (required) — The name of the entity to query (e.g., Produto, Parceiro).
• fields — Comma-separated list of field names to return. Leave empty to return all fields.
• criteriaExpression — SQL-like filter expression (e.g., 'CODPROD IN (?, ?) AND ATIVO = ?').
• criteriaParams — Array of parameter objects with {value, type} where type is S (string), I (integer), F (float), or D (date).
• modifiedSince — Only return records modified after this ISO 8601 datetime.
• offsetPage — Page number for file-based pagination (default 0).

Output shape

A list of items, each containing the requested entity records.

Returns paginated results; the Gateway enforces 'offsetPage' as a required parameter for this operation type. Errors are wrapped in the node's error handling.

Examples

Example 1: List all active products with specific fields using a simple filter.

rootEntity: Produto, fields: 'CODPROD, DESCRPROD', criteriaExpression: 'ATIVO = ?', criteriaParams: '[{"value":"S","type":"S"}]', offsetPage: 0

Example 2: Retrieve records modified since a specific date.

rootEntity: Parceiro, modifiedSince: '2023-01-01T00:00:00Z', offsetPage: 0

Links

• n8n community nodes installation guide