List Contacts
ploomes_contacts_listSearch and list contacts in Ploomes CRM using OData filters for exact match, text search, or date ranges. Supports pagination, field selection, and related entity expansion.
Instructions
Search and list contacts in Ploomes CRM. Supports OData filtering, sorting, field selection, and pagination.
Available $expand values: Type, Company, Tags, OtherProperties, InteractionRecords, Attachments, Documents, Products, Contacts.
$filter examples:
Exact match: "Name eq 'João Silva'"
Contains text: "contains(Name, 'Silva')"
Starts with: "startswith(Email, 'joao')"
By status: "StatusId eq 1"
By type: "TypeId eq 2"
Date filter: "CreateDate ge 2025-01-01T00:00:00Z"
Custom field: "OtherProperties/any(o: o/FieldId eq 12345 and o/StringValue eq 'valor')"
Combined: "TypeId eq 1 and contains(Name, 'Silva') and StatusId eq 1"
Use ploomes_contacts_types_list to discover valid TypeId values. Use ploomes_contacts_status_list to discover valid StatusId values. Use ploomes_contacts_origins_list to discover valid OriginId values.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filter | No | OData $filter expression. Examples: "Name eq 'João'", "contains(Name, 'Silva')", "StatusId eq 1", "TypeId eq 2 and contains(Email, '@empresa.com')", "CreateDate ge 2025-01-01T00:00:00Z", "OtherProperties/any(o: o/FieldId eq 12345 and o/StringValue eq 'valor')" | |
| select | No | Comma-separated fields to return. E.g.: "Id,Name,Email,TypeId,StatusId,OwnerId". NOTE: Phone is NOT selectable — omit it from $select and use $expand=Phones instead. | |
| expand | No | Related entities to include. Available: Type, Company, Tags, OtherProperties, InteractionRecords, Attachments, Documents, Products, Contacts. E.g.: "OtherProperties,Tags,Company" | |
| orderby | No | Sort expression. E.g.: "Name asc", "CreateDate desc", "Revenue desc" | |
| top | No | Max items to return (default 50, max 300) | |
| skip | No | Items to skip for pagination. Use with $top to paginate through results. |