List Deals Supported Filters

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

Query Param	Salesforce	Hubspot	Freshworks	Zoho CRM
`createdAfter`	A	A	A	A
`createdBefore`	A	A	A	A
`updatedAfter`	A	A	A	A
`updatedBefore`	A	A	A	A
`stageId`	A	A	A	A
`pipelineId`	NA	A	A	NA
`status`	NA	A	NA	A
`accountId`	A	A	A	A
`contactId`	A	A	A	A
`ownerId`	A	A	A	A
`createdById`	A	A	A	A
`amountGreaterThan`	A	A	NA	A
`amountLessThan`	A	A	NA	A

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 (ownerId in [...]) OR (contactId 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 (ownerId in [...]) OR (contactId in [...])

When multiple filter groups are combined, the filters are applied in an "AND" operation. This means a record will only show up if it matches every single filter you’ve used. For example, (createdAfter = XYZ AND updatedBefore = ABC) AND (ownerId in [...]) AND (contactId in [...])

Filtering by stageId uses the Deal Stage Name.
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 (ownerId in [...])

Updated about 22 hours ago