ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttp://mail.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 + p_QuoteID type :GET parameters:m_ApprovedConverted connection:"zcrm" ]; // should be checking here that data contains any rows but I'm going on the basis that this quote exists in CRM and at least 1 line item is mandatory l_CrmProductLineItems =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Webhooks & Shopify API: Keep Disappearinghttp://mail.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 */ // // set your own REST API endpoints for the webhooks here (we are only checking order update or inventory level update) v_CrmOrderUpdateWebhook =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Determine your Statement Execution Limithttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-determine-your-statement-execution-limit.html

31 July 2024 some proof using code. How? We're going to use a quick snippet of some code. So create a function in the Zoho App you are checking, or somewhere you can write some Zoho Deluge code. Note that requesting an increase of the limit or an upgrade to the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Workdrive: Getting Team Folder IDhttp://mail.joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 configured" or an unhelpful blank response. Getting the folder ID This applies to if you click on "My Folders" and then checking the URL https://workdrive.zoho.com/home/{dunno_id}/privatespace/folders/{folder_id} Getting the teamfolder ID: Access the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM & Xero: Function to pull most recent invoiceshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 { // // initialize v_CrmProductID = ""; l_CrmProductAvailableTaxes = List(); l_CrmProductAvailableTaxes.add("NONE"); // // checking this is a valid line item and not an error message by it having an ItemCode v_CrmProductName =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM & Xero: Function to pull most recent quoteshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 in m_ThisQuote.get("LineItems") { // // initialize v_CrmProductID = ""; l_CrmProductAvailableTaxes = List(); // // checking this is a valid line item and not an error message by it having an ItemCode //v_CrmProductName =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Comparing two mediawiki siteshttp://mail.joellipman.com/articles/cms/mediawiki/comparing-two-mediawiki-sites.html

17 September 2010 add the SQL queries I used to this article but I'm in the middle of carrying out this process and it's due in two hours. Checking both MediaWiki have the same article content: Print Special:AllPages from both sites and do an eye-check (I basically...

• Type: Article
• Author: Joel Lipman
• Category: MediaWiki
• Language: en-GB

Drop If Object Existshttp://mail.joellipman.com/articles/database/t-sql/drop-if-object-exists.html

03 August 2012 use. If it's wrong then just post a comment at the bottom of this page. Go go go Note that in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one. -- drop a stored procedure if it exists IF...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Zoho Deluge: Check Time Booking Slotshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-check-time-booking-slots.html

05 December 2018 Just wanted a note to get in my head the logic if checking a requested time slot isn't a double-booking (as in, the time slot doesn't overlap a previous booking. How? Given a date/time and a duration, we will work out the requested start and end time:...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB