Search - Joel Lipman .Com

1. Zoho Creator: Input Color Picker: / Zoho /; ... = v_CssStyle; Code for On User Input of Color Picker: if(!isNull(input.Color_Picker) && !input.Color_Picker.contains("button")) { v_HeximalRef = input.Color_Picker.getsuffix("background-color:").getprefix(";"); input.Hexadecimal ...; Created on 14 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 /; ... convert a Zoho Project DateTime to a DateTime datatype (given 12/12/2023 12:00:00 PM... remove ambiguity: mm/dd or dd/mm?) if(!isNull(m_PastEvent.get("scheduled_on"))) { if(m_PastEvent.get("scheduled_on").contains(" ...; Created on 22 July 2024
5. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... = "Hi there! This is an email to advise that the synchronization between your Zoho People and Zoho Analytics instances failed. The last synchronization data we have is as follows: "; if(!isNull(m_DataSourceInfo.get("datasourceName"))) { for ...; Created on 02 July 2024
6. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... in l_RelatedTasks { if(!isNull(m_RelatedTask.get("Subject"))) { if(m_RelatedTask.get("Subject")=="Follow Up Non Converted Lead") { m_Delete = map(); m_Delete.put("module", "Tasks"); m_Delete.put("id",m_RelatedTask.get("id")); r_Delete ...; Created on 14 May 2024
7. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... // resolve connection details if(!isNull(r_ShopifyConnection.get("data"))) { m_Data = r_ShopifyConnection.get("data"); v_ShopifyID = ifnull(m_Data.get("Shop_ID"),""); v_APIVersion = ifnull(m_Data.get("API_Version"),""); v_AccessTo ...; Created on 22 April 2024
8. 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
9. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... r_WorkdriveUpload; if(!isNull(r_WorkdriveUpload.get("data"))) { // // set permissions to public and visible m_Headers = Map(); m_Headers.put("Accept","application/vnd.api+json"); for each r_Data ...; Created on 05 December 2023
10. 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
11. 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
12. 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
13. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... v_OrderDate); info p_eBayOrderRef; // // get books tax rates m_Taxes = Map(); r_Taxes = invokeurl [ url :"https://books.zoho.eu/api/v3/settings/taxes?organization_id=" + v_BooksOrgID type :GET connection:"joel_books" ]; if(!isnull(r_Taxes.get("taxes"))) { for ...; Created on 27 April 2023
14. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
15. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... { if(!isnull(r_Shipment.get("status"))) { v_ShipmentStatus = r_Shipment.get("status").get("statusCode"); info v_ShipmentStatus; } } } // // return response return v_ShipmentStatus; ...; Created on 21 March 2023
16. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... == 200) { // // retrieve the answer in text l_Choices = r_ChatGPTResponse.get("responseText").get("choices"); for each m_Choice in l_Choices { if(!isnull(m_Choice.get("message"))) { if(m_Choice.get("message").get("role ...; Created on 06 March 2023
17. ZohoCRM: Get All eBay Active Listings: / Zoho /; What? Another one of these articles talking about getting all the active product listings from eBay for a specific client. Why? Our use-case scenario here is that we want to get an inventory ...; Created on 01 March 2023
18. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
19. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... = "\"" + v_ProductHandle + "\""; } v_Shopify_Created = v_ProductCreated.getPrefix("Z").replaceAll("T"," "); v_Shopify_PublishedStr = if(!isNull(v_ProductPublished),v_ProductPublished,v_Shopify_Created); v_Shopify_Published ...; Created on 20 February 2023
20. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... 200) { // // retrieve the answer in text l_Choices = r_ChatGPTResponse.get("responseText").get("choices"); for each m_Choice in l_Choices { if(!isnull(m_Choice.get("message"))) { if(m_Choice.get("message").get("role")=="assistant") { // / ...; Created on 13 February 2023