Bug report - v3 contacts API not able to find emails with special characters using IN operator

Developer Support APIs & Integrations
1

Not sure if this is the correct place to report bugs, but couldn’t find any other.

IN operator for email: not working

31109i8873482D35DC5952.png
31109i8873482D35DC5952.png399×400 35 KB

EQ operator for email: working

31111i73BDD866B2AE8638.png
31111i73BDD866B2AE8638.png380×400 36.6 KB

2

Hey @davidfrankl,

The current supported operators on the search v3 API are:

  • EQ
  • NEQ
  • LT
  • LTE
  • GT
  • GTE
  • HAS_PROPERTY
  • NOT_HAS_PROPERTY
  • CONTAINS_TOKEN
  • NOT_CONTAINS_TOKEN

As such, I wouldn’t expect the IN operator to be working.

3

Hi Wendy,

Thanks for your quick response. IN is indeed working - we have been using it for few weeks now. Seems to be undocumented/experimental functionality. It is working for all regular chars, but not special ones. Though not really a bug if it is not “official”.

31169i44245FD3EA07421C.png
31169i44245FD3EA07421C.png400×283 26.7 KB

4

Hey @davidfrankl,

While the `IN` operator may appear to be working previously for you, HubSpot doesn’t currently support this function and I do not believe it is part of our product roadmap to support the `IN` opeartor in the near future.

In this case, one other suggestion that I have for your team is to create a list within HubSpot and use the Get contacts in a list | Contact Lists API to retrieve the contacts in a list.