Ploomes CRMInstall

Summary

Retrieves multiple Field Options Table records from Ploomes CRM with support for pagination, filtering, sorting, field selection, expansion of related entities, and optional caching.

Inputs

• cacheStrategy — How to use in-memory cache for GET requests. Options: Disabled (no cache), Cache First (use cached response if available and valid), Fallback Only (always fetch from API; use cache only if the request fails). Default is Disabled.
• cacheTtl — Time-to-live for cached responses in seconds. Only applies when cacheStrategy is Cache First or Fallback Only. Default is 300 (5 minutes). Minimum value is 1.
• top — Maximum number of records to return ($top). Default is 1 for optimized queries. Minimum value is 1.
• skip — Number of records to skip for pagination ($skip). Default is 0. Minimum value is 0.
• select — Comma-separated list of fields to return ($select). Default is "Id". Example: Id,Name,Title.
• orderby — Field to sort by with optional direction ($orderby). Default is "Id". Example: Id desc, Name asc.
• useFilterBuilder — Whether to use the visual filter builder (true) or write a raw OData $filter string (false). Default is true.
• filterRaw — Raw OData $filter expression when Use Filter Builder is false. Example: Id eq 123 and Name eq 'John'.
• filterConditions — Visual filter conditions builder for OData $filter. Each condition includes Field, Operator, Value, Value Type, and Logical Operator to combine with the next condition.
• customPropertyFilters — Filters by custom field values (OtherProperties). Each filter requires Field ID, Value Property, Operator, Value, and optionally Value Is Numeric.
• collectionFilters — Filters by navigation properties. Each filter requires Filter Type (Collection (Any) or Direct Navigation), Navigation Property, Field, Operator, Value, and Logical Operator to combine with the next filter.
• useExpandBuilder — Whether to use the visual expand builder (true) or write a raw OData $expand string (false). Default is true.
• expandRaw — Raw OData $expand expression when Use Expand Builder is false. Example: OtherProperties,Owner($select=Id,Name).
• expandRelations — Visual builder for expanding related entities ($expand). Each expansion requires Property Name, optional $select (Nested), Use Nested Filter, $filter (Nested), Use Nested Expand, and $expand (Nested).
• expandNestedFilters — Visual builder for nested $filter conditions inside expansions. Each filter requires Expansion Property (must match an expansion), Field, Operator, Value, Value Is Numeric, and Logical Operator.

Output shape

fixed

The node has three outputs: Success, Error, Timeout. Success returns the array of Field Options Table records (potentially enriched with _fromCache or _fallback flags when caching is used). Error and Timeout return objects describing failures, each containing error message, status code, timeout flag, resource, operation, and timestamp.

Examples

Example 1: Get the first 5 Field Options Table records, selecting Id and Name, sorted by Name ascending.

Set top=5, skip=0, select='Id,Name', orderby='Name asc'.

Example 2: Retrieve records where a custom field (Field ID 123) equals 'Active' using the filter builder.

Enable useFilterBuilder, add a condition: Field = 'OtherProperties/any(o: o/FieldId eq 123 and o/StringValue eq 'Active')' or use the Custom Property Filters section with fieldId=123, valueProperty='StringValue', operator='eq', value='Active'.

Links

• n8n community nodes installation guide