Technical references

When using certain HubSpot CRM activities, such as Get Record or List All Records, you can filter results with the help of the following operators:

• HAS_PROPERTY - Should be used when you want to filter records based on a field having a value or not. For example, if you want to return records where first name field has a value, you must mention firstname within the HAS_PROPERTY field.
• NOT_HAS_PROPERTY - Should be used when you want to filter records based on a field not having a value. For example, if you want to return records where first name field does not have a value, you must mention firstname within the HAS_PROPERTY field.
• CONTAINS_TOKEN - Should be used when you want to return records for which a value does not exist. For example, if you want to return records where the value Howdy exists, you must type in Howdy or just How within the CONTAINS_TOKEN field.
• NOT_CONTAINS_TOKEN - Should be used when you want to return records where a value does not exist. For example, if you want to return records where value "Howdy" does not exist, you must type in "Howdy" or just How within the CONTAINS_TOKEN field.

For more details, visit the HubSpot API docs.