Chronic Bugs in their search API

Chronic Bugs in their search API

Hi,

I'd like to hear from other developers who are having problems using the Zoho CRM API. 

Very simple things, universally accepted search practices, simply don't work in the Zoho API. For instance, If you have a CRM Account with the name "My__Account" and the account name has 2 consecutive underscore characters, Zoho's API will fail with 207.  However, if you only have 1 underscore in the account name "My_Account", everything works great.

This bug is not isolated to the underscore. If you have an Account Name which accidentially has 2 consecutive spaces in the name "My  Account", the Zoho API will not find it. However, that same account does show up if you simply remove 1 of the spaces.

COQL is not any better at honoring simple globally accepted datbase rules for searching. It simply has different bugs.

I've contacted their Tech Support team multiple times over this problem and their back-end team does not seem to see any problems with it.

I started working in relational database systems in 1986, so I've had a good amount of experience in searching databasess. Through all that time I've learned that there are certain norms for searching, certain things which should work, like querying a database field with consecutive characters (like a space, or underscore), should not break the search query. 

Unfortunately, Zoho's backend dev team has ignored the globally acceptable practices.

something like this should work (my account name is an email address)

https://www.zohoapis.com/crm/v7/Accounts/search?criteria=(Account_Name:equals:my__email@domain.com)&fields=id,Account_Name

but this works
https://www.zohoapis.com/crm/v7/Accounts/search?criteria=(Account_Name:equals:my_email@domain.com)&fields=id,Account_Name


    • Sticky Posts

    • Kaizen #217 - Actions APIs : Tasks

      Welcome to another week of Kaizen! In last week's post we discussed Email Notifications APIs which act as the link between your Workflow automations and you. We have discussed how Zylker Cloud Services uses Email Notifications API in their custom dashboard.

    • Kaizen #216 - Actions APIs : Email Notifications

      Welcome to another week of Kaizen! For the last three weeks, we have been discussing Zylker's workflows. We successfully updated a dormant workflow, built a new one from the ground up and more. But our work is not finished—these automated processes are

    • Kaizen #152 - Client Script Support for the new Canvas Record Forms

      Hello everyone! Have you ever wanted to trigger actions on click of a canvas button, icon, or text mandatory forms in Create/Edit and Clone Pages? Have you ever wanted to control how elements behave on the new Canvas Record Forms? This can be achieved

    • Kaizen #142: How to Navigate to Another Page in Zoho CRM using Client Script

      Hello everyone! Welcome back to another exciting Kaizen post. In this post, let us see how you can you navigate to different Pages using Client Script. In this Kaizen post, Need to Navigate to different Pages Client Script ZDKs related to navigation A.

    • Kaizen #210 - Answering your Questions | Event Management System using ZDK CLI

      Hello Everyone, Welcome back to yet another post in the Kaizen Series! As you already may know, for the Kaizen #200 milestone, we asked for your feedback and many of you suggested topics for us to discuss. We have been writing on these topics over the

    Nederlandse Hulpbronnen