Zoho CRM REST API Search records with special characters

Zoho CRM REST API Search records with special characters

Hello,

I am struggling to search records in Zoho CRM, which contain special characters in the fields I am comparing to.
I am using the REST API of CRM so search Accounts based on the Account_Name.

The documentation also provides a lot of information, but seems outdated: https://www.zoho.com/crm/developer/docs/api/v2/search-records.html

The doc explains parentheses or comma need to be escaped and encoded. This is not true. When following the instructions and search something like (Last_Name:equals:Burns%5C%2CB) instead of (Last_Name:equals:Burns,B), the API searches for "Burns%5C%2CB". While searching with (Last_Name:equals:Burns,B) works perfectly fine.

However this is not my main problem. The character & can be used in the URL to represent a logical AND. But a lot of our companies use this character in their name.
When searching for (Account_Name:equals:test & company) I get this:
{"code":"INVALID_QUERY","details":{},"message":"invalid query formed","status":"error"}
I tried escaping and encoding: (Account_Name:equals:test %5C%26 company) or (Account_Name:equals:test+%5C%26+company)  ... and many more configurations
But then the API searches for the provides strings: "test %5C%26 company" or "test+%5C%26+company"

How can I search by comparing strings containing "&"?

      Zoho SalesIQ Resources



            Zoho TeamInbox Resources

              Zoho DataPrep Resources


                  Zoho CRM Plus Resources

                    Zoho Books Resources


                      Zoho Subscriptions Resources

                        Zoho Desk Resources

                          Zoho Projects Resources


                            Zoho Sprints Resources


                              Qntrl Resources


                                Zoho Creator Resources


                                  Zoho WorkDrive Resources




                                      Zoho Campaigns Resources

                                        Zoho CRM Resources

                                                    Design. Discuss. Deliver.

                                                    Create visually engaging stories with Zoho Show.

                                                    Get Started Now


                                                      Zoho Show Resources


                                                        Zoho Writer Writer

                                                        Get Started. Write Away!

                                                        Writer is a powerful online word processor, designed for collaborative work.

                                                                  有料プランをご利用の方