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

Schema → GET

AI-generated

Summary

Retrieve records from a specified Creatio entity table using OData, allowing optional filtering, selection of fields, record limit, and expansion of related entities.

Inputs

  • authentication (required) — Select the authentication method to use: OAuth2 or Username & Password.
  • subpath (required) — Choose or specify the Creatio entity table name (subpath) to query.
  • select — Optionally select specific field names or IDs to include in the response.
  • top — Specify the maximum number of records to return (defaults to 10).
  • filter — Provide an OData filter formula to include only records matching the criteria.
  • expand — Specify related entities to expand in the response as a comma-separated list.
  • appendRequest — Optionally append the original request parameters to the response for debugging or auditing.

Output shape

a list of JSON objects each representing a record from the selected Creatio entity table

The output includes one item per record returned from Creatio. If 'appendRequest' is enabled, each item includes the request parameters used alongside the response data. Filtering, selection, expansion, and top parameters modify the records returned. If no records match, an empty list is returned.

Examples

Example 1: Retrieve up to 5 accounts with name and phone fields, filtering only active accounts

authentication: OAuth2; subpath: 'Account'; select: ['Name', 'Phone']; top: 5; filter: "{Active} eq true"; expand: ''

Links

Discussion