topic Re: Search API - How do I escape wildcard (*) character? in APIs & Integrations

Search API - How do I escape wildcard (*) character?

dmydlarz — Tue, 23 Jan 2024 10:13:53 GMT

In search API for CONTAINS_TOKEN there's wildcard operator - asterisk `*`.

What if I'm interested in searching literally for that character?

Let's say I want a list of deals that contains three asterisks in name?

How my query should look like?

As you may imagine this one doesn't return what I'm looking for (asterisks are treated as wildcards).

{ "filterGroups": [ { "filters": [ { "propertyName": "dealname", "operator": "CONTAINS_TOKEN", "value": "***" } ] } ], "properties": [ "dealname", "amount", "hs_object_id" ] }

Re: Search API - How do I escape wildcard (*) character?

GRajput — Tue, 23 Jan 2024 13:17:52 GMT

@dmydlarz

" " is used to search when length is not defined so here when you are using "***" in search then all the deals are coming up.
There is no way we can get deals with * in it.
We can't search with special char in API search.
what you can do here is use a loop from the results and then check whether the name includes *** them or not.
From the API response, you can filter out but not from Filter API.

I hope this will help you out. Please mark it as Solution Accepted and upvote to help another Community member.
Thanks!

@dmydlarz

Re: Search API - How do I escape wildcard (*) character?

dmydlarz — Tue, 23 Jan 2024 13:22:44 GMT

Thanks for clarfication 🙂