# Special Characters in crm\_objects query

**URL:** <https://community.hubspot.com/t/special-characters-in-crm-objects-query/114219>\
**Category:** CMS Development\
**Tags:** enterprise\
**Created:** [August 10, 2024, 12:12pm UTC](https://community.hubspot.com/t/special-characters-in-crm-objects-query/114219 "2024-08-10T12:12:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![MBujak](https://avatars.discourse-cdn.com/v4/letter/m/22d042/32.png) [@MBujak](https://community.hubspot.com/u/MBujak)\
**Post date:** [August 10, 2024, 12:12pm UTC](https://community.hubspot.com/t/special-characters-in-crm-objects-query/114219/1 "2024-08-10T12:12:32Z")

</div>

I have a question about query crm objects when the value of the specific property contains special characters. In this case it’s ampersand (&).  
I have custom property, which is multiple checkboxes type, and one of the value is “Disinfectants & Solutions” - so it contains whitespaces and ampersand:

 ![MBujak_0-1723291818850.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/c/cbc6f142e65acc27e33111c631a834f4a3c4ee40.png)

In the module on the page user can filter products by this property. And it works fine for values without special characters. But for this value with ampresand it always returns 0 results even when there are products with these values assigned.  
My code is this:

![MBujak_1-1723291835140.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/5/8/5837cf306738d6c44791bde9a3868a5fa583f25a.png)

The final query is:  
“limit=100&offset=0&emea\_\_eu\_\_\_\_product\_line\_\_contains=Disinfectants & Solutions”  
and it returnes 0 results.  
The query for other value like this:  
“limit=100&offset=0&emea\_\_eu\_\_\_\_product\_line\_\_contains=Mops”  
works fine and return the correct rows collection.  
Is there a way to query for the value with the special characters in it and get correct results?

---

<div class="post-metadata">

**Author:** ![Jaycee\_Lewis](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jaycee_lewis/32/61352_2.png) [@Jaycee\_Lewis](https://community.hubspot.com/u/Jaycee_Lewis)\
**Post date:** [August 12, 2024, 2:54pm UTC](https://community.hubspot.com/t/special-characters-in-crm-objects-query/114219/2 "2024-08-12T14:54:22Z")

</div>

Hey, @MBujak 👋 I think you need to handle the spaces and special character. Have you tried something like this?

`"limit=100&offset=0&emea __eu____ product_line__contains=Disinfectants%20%26%20Solutions`

Talk soon! — Jaycee

---

<div class="post-metadata">

**Author:** ![evaldas](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/evaldas/32/69160_2.png) [@evaldas](https://community.hubspot.com/u/evaldas)\
**Post date:** [August 13, 2024, 10:54am UTC](https://community.hubspot.com/t/special-characters-in-crm-objects-query/114219/3 "2024-08-13T10:54:27Z")

</div>

[@Jaycee\_Lewis](https://community.hubspot.com/t5/user/viewprofilepage/user-id/127074) that seens logical and was my initial though too but does not look like that works.

I was not able to locate any documentation regarding special characters and it would be great to know whether special characters can be used at all.

It appears that spaces are allowed and there is one workaround that will work as long as the other options do not contain the same words:

`"limit=100&offset=0&emea __eu____ product_line__contains=Disinfectants Solutions"`

This would return items that contain “Disinfectans & Solutions” but it would also return items that contain “Desinfectants & Cleaning Solutions”