List Engagements Supported Filters

The following table shows the list of filters supported in the List Engagements API.

Query Param	Salesforce	Hubspot	Zoho CRM
`createdAfter`	A	A	A
`createdBefore`	A	A	A
`updatedAfter`	A	A	A
`updatedBefore`	A	A	A
`accountId`	A	A	A
`contactId`	A	A	A
`dealId`	A	A	A
`leadId`	A	NA	A
`direction`	A	A	A
`status`	A	A	NA

For query params that accepts , separated list of string, if the native API does not support multiple values, only the value at the 0th index will be honored.

Different CRMs handle combinations of these filter types differently.

A maximum of 30 filter values is allowed.
For Date and Amount filters, the filters are applied in an "AND" operation. That means the record must match all those conditions. For example, (createdAfter = XYZ AND updatedBefore = ABC)
If you use filters from different groups — like one for date and another for owner — Salesforce combines them using OR. So a record will be shown if it matches any of the filter groups. For example, (createdAfter = XYZ AND updatedBefore = ABC) AND (contactId in [...]) OR (dealId in [...])

The total number of matching records must be under 10,000. If your filters return more than that, you’ll get an error with status code 400.
A filter query can use only up to 5 groups in HubSpot. When more than five groups are combined, HubSpot throws an error.
Different groups are combined using OR, meaning a record only needs to match one group. For example,
(createdAfter AND createdBefore AND amount filters) OR (contactId in [...]) OR (dealId in [...])

For Date and Amount filters, the filters are applied in an "AND" operation. That means the record must match all those conditions. For example, (createdAfter = XYZ AND updatedBefore = ABC)
If you use filters from different groups — like one for date and another for owner — Zoho CRM combines them using OR. So a record will be shown if it matches any of the filter groups. For example, (createdAfter = XYZ AND updatedBefore = ABC) OR (contactId in [...])

Updated about 20 hours ago