Search Companies

Type of filter to use. If you set Use Filters? to No, then select -- No Filters --. Otherwise, choose from:

• Equal to

• Not equal to

• Less than

• Less than or equal to

• Greater than

• Greater than or equal to

• Has property value

• Does not have property value

• Contains word

• Does not contain word

HubSpot CRM allows you to create up to three filter groups, each of which can contain up to three filters.

This is an example of a filter checking for entries whose first name is Alice:

{
    "propertyName": "firstname",
    "operator": "EQ",
    "value": "Alice"
}

Similarly, you can filter entries by whether they have a property:

{
    "propertyName": "enum1",
    "operator": "HAS_PROPERTY",
}

You can filter entries that don't have a specific property:

{
    "propertyName": "enum2",
    "operator": "NOT_HAS_PROPERTY",
}

Multiple entries in a filter group are combined using a logical AND operator. Consider the following example:

{
    "propertyName": "associations.company",
    "operator": "EQ",
    "value": "Example"
},
{
    "propertyName": "associations.contact",
    "operator": "EQ",
    "value": "123"
},
{
    "propertyName": "associations.deal",
    "operator": "EQ",
    "value": "456"
}

The results of the preceding filter group would match all entries whose company is Example and the contact ID is 123 and the deal ID is 456.

If you have multiple filter groups, then a logical OR grouping is used to combine their results. As an example, you have three filter groups: filtergrp1, filtergrp2, and filtergrp3. The filters within each group are combined using the AND operator. The resulting entries are compiled by combining the groups using the expression filtergrp1 OR filtergrp2 OR filtergrp3.

Alternatively, suppose that your card has two input properties, input1 and input2, and has a filter group, filtergrp1. Then the resulting set combines the results of: (input1 AND input2) OR filtergrp1.

See the HubSpot CRM Search API for a complete list of supported object types, properties, and operators for use with custom filters.