Hubspot company filters

How To
, , , ,
1

Hi everyone,

I might be less smart that the average make user but I just noticed an issue when using the OR in the Hubspot company filter. It should be pretty simple but apparently I can’t figure out how to get what I want.

What I’m trying to achieve: Filter companies where:

hs_lead_status = “Meeting booked” OR “Won”

What I have tried:

Equal to (EQ) : “Meeting booked or Won” → Only takes the meeting booked status

In (IN) : "[“Meeting booked”,”Won”]

Below is what in get in the input

json

      {
                    "a": "hs_lead_status",
                    "b": "Meeting booked",
                    "o": "EQ"
                },
-------------------------
{
    "a": "hs_lead_status",
    "b": "\"Meeting booked\",\"Won\"",
    "o": "IN"
}

And also without the inner quotes:

json

{
    "a": "hs_lead_status",
    "b": "Meeting booked,Won",
    "o": "IN"
}

Question: What’s the correct syntax for the IN operator with multiple string values in HubSpot filters? Should it be comma-separated strings, an array, or something else?

Thanks for your help!