Search - Joel Lipman .Com

1. Zoho Deluge: Convert Hex to RGB: / Zoho /; What? A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some ...; Created on 11 October 2024
2. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... :GET headers:m_Header connection:"my_workdrive_connection" ]; if(!isNull(r_Subfolders.get("data"))) { for each m_Subfolder in r_Subfolders.get("data") { if(!isNull(m_Subfolder.get("attributes"))) { m_SubfolderNames.put(m_Subfolder.get("attributes").get("name"), ...; Created on 11 September 2024
3. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... = 12345000000678901; v_Template = zoho.sign.getTemplateById(v_TemplateID); v_OutputMessage = ""; // // get the Action ID for SIGN v_SendActionID = 0; if(!isNull(v_Template) && !isNull(v_Template.get("templates"))) { // ...; Created on 06 August 2024
4. Zoho Projects: Get All Events: / Zoho /; ... = invokeurl [ url :v_EndpointEvents type :GET parameters:m_Params connection:"my_projects_connection" ]; l_PastEvents = ifnull(r_PastEvents.get("events"),List()); for each m_PastEvent in l_PastEvents { // // ...; Created on 22 July 2024
5. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... response l_DataRows = ifnull(r_PurchaseOrders.get("data"),List()); // // build up related list header row l_HeaderColumns = List(); l_HeaderColumns.add(); l_HeaderColumns.add(); l_HeaderColumns.add(); // ...; Created on 09 July 2024
6. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... */ // // initialize v_LastSyncTime = null; v_LastSyncStatus = "?"; m_DataSourceInfo = Map(); // // read the TLD (eu or com or com.in) from the URL when logged into Zoho Analytics v_BaseURL = "https://analyticsapi.zoho.com"; // // ...; Created on 02 July 2024
7. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... = zoho.inventory.getRecordsByID("items", v_BooksOrgID, m_LineItem.get("item_id"), "zinventory"); m_BooksItem = ifnull(r_BooksItem.get("item"), m_Blank); v_BooksItemRate = ifnull(m_BooksItem.get("rate"),0.00); v_ThisQuantity ...; Created on 23 May 2024
8. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... lead record r_LeadDetails = zoho.crm.getRecordById("Leads",p_LeadID); // // get created time (no need to check if null?) v_LeadCreatedTime = r_LeadDetails.get("Created_Time"); // // convert to time ...; Created on 14 May 2024
9. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... - Not the used final version): 0) { if(c_Quote.Name != null) { v_Firstname = c_Quote.Name.first_name; v_Lastname = c_Quote.Name.last_name; } if(c_Quote.Email != null) { v_Email ...; Created on 07 May 2024
10. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... = zoho.creator.createRecord("myOwnerName","myAppName","myFormName",m_CreateRecord,m_Blank,"myCreatorConnection"); // // build the hash based on the payload body v_Data = ifnull(m_Payload.get("body"),""); v_VerifyHash ...; Created on 22 April 2024
11. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... = 0; v_TotalCategories = r_Categories.toJSONList().size(); for each m_Category in r_Categories.toJSONList() { if(!isNull(m_Category.get("count"))) { v_TotalProducts = v_TotalProducts + m_Category.get("count"); } } info ...; Created on 15 April 2024
12. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... 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: ...; Created on 07 March 2024
13. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... subform: void Standalone.fn_DownloadAndCacheAttachments(string p_TicketRef) { v_TicketRef = ifnull(p_TicketRef,""); c_TicketRecords = QC_Report_Table[Ticket_Number == v_TicketRef]; for each ...; Created on 26 January 2024
14. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... :GET connection:"zdesk" ]; l_AttachmentDetails = ifnull(r_Attachments.get("data"),{}); for each r_Attachment in l_AttachmentDetails { m_Attachment = r_Attachment.toMap(); v_Endpoint = m_Attachment.get("href") ...; Created on 05 December 2023
15. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... */ // // Go create a folder in workdrive, take the last hash string after the word /folders/ in the URL: v_TargetFolder = ifnull(p_WorkdriveFolder,"abcdefghijklmnopqrstuvwxyz12345678901"); v_ImageToDownload ...; Created on 05 December 2023
16. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... :GET connection:"zcrm" ]; v_MaxCount = ifnull(r_MaximumCount.get("count"),0).toLong(); v_Pages = ceil(v_MaxCount / v_PerPage); info v_Pages; Call with a criteria: v_PerPage = 200; v_CountCriteria ...; Created on 14 November 2023
17. Zoho Books: System Values Maps: / Zoho /; ... + v_BooksOrgID type :GET connection:"zbooks" ]; m_NominalAccounts = Map(); if(!isnull(r_ChartOfAccounts.get("chartofaccounts"))) { for each m_NomAccount in r_ChartOfAccounts.get("chartofaccounts") { m_NominalAccounts.put(m_NomAccount.get("account_name"),m_NomAccount.get("account_id")); } } info ...; Created on 07 November 2023
18. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... each r_Tax in r_Taxes.get("taxes") { m_Taxes.put(r_Tax.get("tax_percentage").toString(),r_Tax.get("tax_id")); } // // ---------------------- DETERMINE ZOHOBOOKS CUSTOMER ID ---------------------- if(!isnull(r_QuoteDetails.get("Account_Name"))) { v_AccountID ...; Created on 18 September 2023
19. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... the week number: c_Order = Order[ID == 123456890123456890]; if(c_Order.Order_Date != null) { v_ThisDate = c_Order.Order_Date.toString("EEEE, dd-MMM-yyyy u w"); v_ThisWeek = if(c_Order.Order_Date.toString("u").toLong()==7,c_Order.Order_Date.subDay(1),c_Order.Order_Date).toString("w"); } // ...; Created on 06 July 2023
20. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... + v_BooksOrgID type :GET connection:"zinventory" ]; m_Accounts = Map(); if(!isnull(r_ChartOfAccounts.get("chartofaccounts"))) { for each r_Account in r_ChartOfAccounts.get("chartofaccounts") { m_Accounts.put(r_Account.get("account_name"),r_Account.get("account_id")); } } // // ...; Created on 04 May 2023