MyRapidi
MyRapidi
Menu

Search our Wiki

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:

  1.  LT - Less than
  2.  LTE - Less than or equal to 
  3.  GT - Greater than
  4.  GTE - Greater than or equal to
  5.  EQ - Equal to 
  6.  NEQ - Not equal to 
  7.  BETWEEN - Within the specified range. In your request, use key-value pairs to set highValue and value. You can refer to this  example.
  8. 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 .
  9. 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.
  10. HAS_PROPERTY - Has a value for the specified property.
  11. NOT_HAS_PROPERTY - Doesn't have a value for the specified property.
  12. 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.
  13. NOT_CONTAINS_TOKEN - Doesn't contain a token.