Zoho Deluge: Search Records with Special Characters (COQL)https://joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 reliable enough I have found to work each time is using the CRM Object Query Language or Zoho's COQL. Similar to SQL but subject to similar issues of escaping special characters... 1. Setup a CRM Connection to Search Records via API I won't go into...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 as a test but remember to remove this before going Live. sendmail [ from :zoho.adminuserid to :"info@joellipman.com" subject :"TEST ebay Webhook Notification" message :m_Payload ] */ return r_CreateRecord; Save the function While still on the CRM...

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

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 = v_OutputMessage + "Generated and attached file to CRM record. "; } // // to generate and send via email m_MergedData.put("subject","Document for " + r_ContactRecord.get("Salutation") + " " + r_ContactRecord.get("Last_Name"));...

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

Zoho CRM: Schedule a Call using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

18 November 2021 m_ScheduleCall.put("Owner",v_LeadOwnerID); m_ScheduleCall.put("What_Id",v_LeadID); m_ScheduleCall.put("Subject","Scheduled Call with " + v_CustomerName); m_ScheduleCall.put("Call_Start_Time",v_SystemAppointmentDateTimeStart);...

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

Zoho CRM: Schedule a Meeting using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-meeting-using-deluge.html

02 March 2022 example, a lead record but can be almost any kind of record) m_ScheduleMeeting.put("What_Id",98765432109876543); // // the subject m_ScheduleMeeting.put("Event_Title","TEST Consultation: Call with TEST LEAD"); // // the description...

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

Amazon Kindle: Send PDFs to your Kindlehttps://joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 Also, you can send multiple PDF files at the same time, as it is with any email client. You can also use ‘Convert’ as the subject and send it to Kindle. The file gets automatically converted to the Kindle format. Fix for PDF file now showing on the...

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

Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 evidence that the workflow was triggered and ran this function sendmail [ from :zoho.adminuserid to :"info@joellipman.com" subject :"Client Test: ZB: Payment Received for Invoice " + v_InvoiceRef message :"Workflow was executed and function ran:...

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

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 info r_Attach; // // to send this as an email as well sendmail [ from :zoho.adminuserid to :"info@joellipman.com" subject :"ZohoSign Test - Request: " + v_RequestId + " - Document: " + v_DocumentId message :"Please find attached your requested...

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

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 modification of your data. That being said, it's important to note that the use and distribution of trained models may be subject to legal or ethical considerations, depending on the nature of the data and the intended use of the model. Therefore, if...

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

Zoho Creator: Sendmail a list of attachmentshttps://joellipman.com/articles/crm/zoho/zoho-creator-send-mail-a-list-of-attachments.html

20 July 2023 l_Downloads.add(r_Download2); // sendmail [ from: zoho.adminuserid to: "info@joellipman.com" subject: "Test File: List" message: "This is just a test" attachments: file: l_Downloads ] } Yields

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 + ".json"); // // send this to us via email sendmail [ from :zoho.adminuserid to :"me@joellipman.com" subject :"All Products from " + v_MyWordPressSiteUrl + " as of " + zoho.currenttime.toString("yyyy-MM-dd HH:mm:ssXXX") message :"Please see the...

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

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

22 April 2024 } /* // sendmail [ from :zoho.adminuserid to :"me+DEBUG_SHOPIFY_EXAMPLE@joellipman.com" subject :"CLIENT Payload and Hash Comparison" message :v_VerifyHash + " " + v_ShopifyHash + " " + m_Payload.toString() ] // // to cut even more time, we could store...

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

Zoho Analytics: Create a Monitoring System with Imageshttps://joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 AS "Record Owner", img5."ZohoAnalytics Image URL" AS "Status Image" FROM ( SELECT tsk."Id" AS "RecordID", tsk."Subject" AS "RecordName", tsk."Task Owner Name" AS "RecordOwner", tsk."Modified Time" AS "ModifiedTime", if(to_date(tsk."Modified Time") >...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 " + zoho.currenttime; // if(b_DebugMode) { sendmail [ from :zoho.adminuserid to :"me+DEBUGZOHOSIGNWEBHOOK@joellipman.com" subject :"My ZohoSign Webhook - ANY EVENT" message :v_DebugMessage ] } return ""; Related List for Custom Module Just for good...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 + " "; // v_StatusCode = 200; // v_To = ""; l_bcc = List({}); // sendmail [ from :zoho.loginuserid to :v_To bcc: l_bcc subject :v_Topic message :v_Message ] } catch(e) { v_StatusCode = 403; } // m_PayloadResponse = Map();...

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