Zoho Books: System Values Mapshttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-books-system-values-maps.html

07 November 2023 + v_BooksOrgID type :GET connection:"zbooks" ]; m_Warehouses = Map(); l_Warehouses = ifnull(r_Warehouses.get("warehouses"), List()); for each m_Warehouse in l_Warehouses { m_Warehouses.put(m_Warehouse.get("warehouse_name"),...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://joellipman.com/component/content/article/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html?catid=129&Itemid=165

05 December 2023 :"https://desk.zoho.eu/api/v1/tickets/" + p_TicketID + "/attachments" type :GET connection:"zdesk" ]; l_AttachmentDetails = ifnull(r_Attachments.get("data"),{}); for each r_Attachment in l_AttachmentDetails { m_Attachment = r_Attachment.toMap();...

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

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://joellipman.com/articles/crm/zoho/zoho-books/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

07 March 2024 sure you can lock it down to just the scopes you need. void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID) { v_OrderID = ifnull(input.p_OrderID,0).toLong(); /* ******************************************************************************* Function:...

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

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 + r_DealDetails.get("Contact_Name").get("id") type :GET connection:"zcrm" ]; // l_ContactDetails = ifnull(r_ContactDetails.get("data"), List()); for each m_ContactDetails in l_ContactDetails { if(!isNull(m_ContactDetails.get("Tag"))) { for each m_Tag in...

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

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 [ url :"https://www.zohoapis.com/crm/v8/Deals/" + p_DealID + "?fields=Pipeline" type :GET connection:"zcrm" ]; l_DealData = ifnull(r_RecordDetails.get("data"),List()); for each m_DealData in l_DealData { if(!isNull(m_DealData.get("id"))) { r_DealDetails...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 // // retrieving the set of values from 'arguments' passed in the javascript code m_Arguments = ifnull(m_RequestParams.get("arguments"), Map()); // if(!isNull(m_Arguments.get("p_AccountID"))) { v_AccountID = m_Arguments.get("p_AccountID").toString();...

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

Zoho Survey: Zoho CRM Webhookhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-survey-zoho-crm-webhook.html

01 October 2025 then you're stuffed. ******************************************************************************* */ v_WebhookBody = ifnull(crmAPIRequest.toMap().get("body"),""); v_WebhookBodyDecode = zoho.encryption.urlDecode(v_WebhookBody); v_WebhookBodyString =...

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

Cheat Sheet for mySQL vs t-SQLhttps://joellipman.com/articles/else/database/cheat-sheet-for-mysql-vs-t-sql.html

31 January 2013 Other If-then-else IF( expression,value_if_true,value_if_false ) IIF( expression,value_if_true,value_if_false ) If Null IFNULL(column_name,value_if_null) ISNULL(column_name,value_if_null) Rank/Rownum (@rownum:=@rownum+1) AS Rownum LIMIT from_index,...

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