topic Re: Issue with filters on search API - filters not handling JSON escaped text in APIs & Integrations

Issue with filters on search API - filters not handling JSON escaped text

RReiffer — Thu, 28 Mar 2024 14:29:35 GMT

I have been running a search using

/crm/v3/objects/deals/search

and the filter as follows:

{

"filterGroups":[

{

"filters":[

{

"propertyName": "dealname",

"operator": "EQ",

"value": "{{ CTX.opp_name }}"

}

]

}

]

}

Now this works EXCEPT when the variable CTX.opp_name contains a single quote as it will error out. I then changed it so the variable was set this way CTX.opp_name|json_escape. It then runs BUT the search will NOT find anything. It's like the API is ignoring the escaped character and not feeding it to the actual internal search.

The actual string was as follows:

"Test Quote for a 50" TV"

The escaped JSON string was

"Test Quote for a 50\" TV"

Now in other areas I can escape the text just fine, just not in the search.

Re: Issue with filters on search API - filters not handling JSON escaped text

RReiffer — Thu, 28 Mar 2024 17:48:42 GMT

I have tried the double "" method and several other methods of pre-encoding the string (including standard escapes and Microsoft based ones) - the issue is at some point the API point takes the "converted" string but it then can not find the deal by name even though it exists. From what I have read it appears that the filter command on HubSpot API searches does not process JSON escape or any other escape method for that matter.

Re: Issue with filters on search API - filters not handling JSON escaped text

BDeveloper8 — Tue, 13 Jan 2026 20:27:48 GMT

Same exact problem here -- did you find a solution ? Tried many of the same workarounds it sounds like you did.