topic Re: JSON "filterGroups" not filtering results in APIs & Integrations

JSON "filterGroups" not filtering results

NBiffen — Tue, 29 Apr 2025 14:13:10 GMT

If anybody can help but I have managed to build a POST body within Postman that returns the expected results. The body is:

Response:

However, when replicating this within HubSpot's API required format, it fails to identify the specific order and instead returns all results, whilst also displaying random data across the additional properties.

Please if anybody can shed some light on this, it would be very much appreciated.

Re: JSON "filterGroups" not filtering results

SteveHTM — Tue, 29 Apr 2025 19:39:33 GMT

@NBiffen - I think this could be quite simple. It looks like the 'IN' search test uses lowercase string literals for values in the filter - not totally obvious from the documentation, but can be critical in setting things up.

https://developers.hubspot.com/docs/guides/api/crm/search

I actually tend to use IN for ennumerated property values - and EQ )with 'value') for tests for single string values.

Hope that helps!

Steve

Re: JSON "filterGroups" not filtering results

NBiffen — Wed, 30 Apr 2025 12:49:45 GMT

Thanks Steve, appreciate the response. Unfortunately the "EQ" function doesn't return the direct match, but instead the entire list. Wherea's (through some trial and error) "IN" does return the required response.

However, where I am really baffled is that the API response is positive, but when entering this into HubSpot the results change and do not perform the "filterGroups" function.

I wasn't sure if I was missing something from the entry into HubSpot's UI?