Filtering with HubSpot
On any HubSpot integration,you can set up a maximum of 5 filters on every transfer ( Source Control being included). This is a limitation on the HubSpot side and it does not allow more than 5 filters at the time on a specific transfer. You can use operators in filters to specify which records should be returned. Values in filters are case-insensitive, with the exception of the IN and NOT_IN operators which require lowercase values. You can use the following operators in a filter:
- LT - Less than
- LTE - Less than or equal to
- GT - Greater than
- GTE - Greater than or equal to
- EQ - Equal to
- NEQ - Not equal to
- BETWEEN - Within the specified range. In your request, use key-value pairs to set highValue and value. You can refer to this example.
- IN - Included within the specified list. In your request, include the list values in a values array. Inputted values must be in lowercase. You can refer to this example .
- NOT_IN - Not included within the specified list. In your request, include the list values in a values array. Inputted values must be in lowercase.
- HAS_PROPERTY - Has a value for the specified property.
- NOT_HAS_PROPERTY - Doesn't have a value for the specified property.
- CONTAINS_TOKEN - Contains a token. In your request, you can use wildcards (*) to complete a partial search. For example, use the value *@hubspot.com to retrieve contacts with a HubSpot email address.
- NOT_CONTAINS_TOKEN - Doesn't contain a token.