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

Record → GET

AI-generated

Summary

Retrieve one or more records from a specified Creatio CRM entity using OData query parameters to control selection, filtering, expansion of related entities, and the number of records returned.

Inputs

  • Authentication (required) — Choose the authentication method: OAuth2 or Username & Password.
  • Subpath Name or ID (required) — Specify the Creatio entity to query by selecting from the list or providing an ID via expression.
  • Select Field Names or IDs — Optionally select specific fields to return from the entity.
  • Top — Limit the number of records returned. Defaults to 10.
  • Filter By Formula — Provide a formula to filter which records are included; evaluated per record, includes those where result is truthy.
  • Expand — Comma-separated list of related entities to include (expand) in the response.
  • Append Request — Choose whether to append the original request details to the response.

Output shape

a list of records, each returned as a separate item with JSON containing the record's data

If 'Append Request' is true, each output item includes both request parameters and the response data. If no records match, returns an empty list. Supports pagination via 'Top' parameter but does not automatically paginate beyond the specified limit.

Examples

Example 1: Fetching up to 5 contact records with their names and emails, filtering out empty names, and expanding related account data

Set 'Subpath Name or ID' to 'Contact'; 'Select Field Names or IDs' to ['Name','Email']; 'Top' to 5; 'Filter By Formula' to 'NOT({Name} = "")'; 'Expand' to 'Account'.

Links

Discussion