Zoho Deluge: Search Records with Special Characters (COQL)
This is an article to remind me how to search for CRM records by a value that may contain an ampersand or parenthesis.
Knowledge base / Since 1999
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search141 entries / matching CRM
Clear filters
This is an article to remind me how to search for CRM records by a value that may contain an ampersand or parenthesis.
This is slightly different to my article Zoho Deluge: Get Refresh/Access Token API v2 (Zoho to Zoho service) and different to my Zoho CRM: APIv2 using PHP & cURL (3rd-Party to Zoho), in that this details how to setup a connection to use in an invoke URL statement. Specifically for Zoho Books, Subscriptions or Inventory...
This is an article to document how to use Zoho Deluge to download a file that was uploaded into a Zoho Creator form and then to attach it to a Sales Order in Zoho Books.
So this is a super quick note that I'll probably remember anyway but just in case, I'm writing this article so I don't spend time researching it later.
A very quick article on how to push a multi-select picklist from CRM to Creator.
This is an article to document a standalone function which generates an access token from within Zoho CRM so you can access your Xero instance. There are 3rd-party API libraries and SDKs out there but as usual with financial technologies (fintech), I don't trust them. Here's how to do it in pure Deluge with a Zoho CRM...
This is an article with the snippet of code required to duplicate or clone a record in Zoho CRM using Zoho Deluge.
A quick article on how to debug some errors in Zoho.
So this is an article with some common snippets of code that use the InvokeConnector and do things we can't do in shortcode.
Working principle
This site exists as a practical knowledge base built from real-world experience across systems, platforms, and technologies since 1999. Much of the content documents solutions, edge cases, and working patterns that were learned through investigation where documentation was incomplete or absent, and is shared to reduce the same friction for others.
Recently Added
Zoho Books: Change a Purchase Order's Delivery Address over API Zoho CRM: Presenting ABM for Zoho CRM: Expand and retain your customers with precision Zoho CRM: Announcing the new SKILL.md for Zoho CRM and the updated OAS repository! Zoho CRM: Allow Only Administrators To Change Task Owners Zoho Billing: Workflow does not exist!Protected notes
Log in for protected notes and any private client projects assigned to your account.