Creatio icon

Creatio

Read and write records in Creatio CRM (contacts, accounts, leads, opportunities, custom objects) via OData. Use to look up, create, update, or delete Creatio CRM data.

Actions24

File → GET

AI-generated

Summary

Retrieve one or more records from a specified Creatio OData entity with optional filtering, selection of fields, and expansion of related entities.

Inputs

  • Authentication (required) — Choose authentication method: OAuth2 or Username & Password.
  • Subpath Name or ID (required) — Select or specify the Creatio OData entity name to query.
  • Select Field Names or IDs — Optionally select specific fields to return for each record.
  • Top — Number of records to return, default is 10.
  • Filter By Formula — Formula to filter records; only records where the formula evaluates to true (not 0, false, empty) are included.
  • Expand — Comma-separated list of related entities to expand in the response.
  • Append Request — If true, appends the original request parameters to the response data.

Output shape

a list of JSON objects representing the matching records

Returns an array of records matching the criteria. If 'Append Request' is enabled, each output item includes the request parameters alongside the response. Returns an empty array if no records match the filter.

Examples

Example 1: Get up to 5 records from the 'ContactFile' entity selecting only 'Id' and 'Name' fields, filtering by a formula to exclude empty names.

Set 'Authentication' to your preferred method, 'Subpath' to 'ContactFile', 'Select' to ['Id', 'Name'], 'Top' to 5, and 'Filter' to "NOT({Name} = '')".

Links

Discussion