List Leads Supported Filters

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

Query ParamSalesforceZoho CRM
createdAfterAA
createdBeforeAA
updatedAfterAA
updatedBeforeAA
convertedAfterANA
convertedBeforeANA
ownerIdAA
createdByIdAA
emailAA

Remarks:

  • 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.

Salesforce

  • 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 (createdById in [...])

Zoho CRM

  • 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 [...])