Search - Joel Lipman .Com

1. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... than 1 second m_Payload = crmAPIRequest.toMap(); m_Blank = Map(); // // you created an app that generated a client ID and a client secret and resulted in an access token // the client secret used ...; Created on 22 April 2024
2. 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
3. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
4. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... type: POST parameters: m_Params.toString() headers: m_Header ]; //info r_ChatGPT_Request; l_Choices = ifnull(r_ChatGPT_Request.toMap().get("choices"),{}); for each r_Choice ...; Created on 06 March 2023
5. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... Another REST API CRM function which generates an eBay Access Token for me r_Response = getUrl("https://www.zohoapis.eu/crm/v2/functions/fn_ebay_getaccesstoken/actions/execute?auth_type=apikey&zapikey=1003."); if(!isnull(r_Response.toMap().get("details"))) { if(!isnull(r_Response.toMap().get("details").get("output"))) { v_AccessToke ...; Created on 31 March 2022
6. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... + "/graphql.json"; r_GetProduct = invokeurl [ url :v_Endpoint type :POST parameters: m_GraphQl.toString() headers:m_Header ]; return r_GetProduct.toMap(); } Job done! Yields something ...; Created on 14 February 2022
7. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... = ""; l_DisallowedProfiles = List(); l_DisallowedOptions = List(); // // capture event m_Webhook = crmAPIRequest.toMap(); // // check if user info is provided if(!isnull(m_Webhook.get("user_info"))) { // // ...; Created on 11 February 2022
8. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... = ""; v_AccessToken = ""; r_Response = getUrl("https://www.zohoapis.com/crm/v2/functions/fn_api_getxeroaccesstoken/actions/execute?auth_type=apikey&zapikey="); if(!isnull(r_Response.toMap().get("details"))) { if(!isnull(r_Response.toMap().get("details").get("output"))) { v_AccessToken ...; Created on 10 January 2022
9. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... ]; r_Response = r_NewProduct.toMap(); if(!isnull(r_Response.get("product").get("id"))) { v_ShopifyProductID = r_Response.get("product").get("id").toLong(); ...; Created on 17 October 2021
10. ZohoCRM: Deluge: Map a custom field from user profile: / Zoho /; ... = r_UserDetails.toMap(); if(!isnull(m_UserDetails.get("Division"))) { v_DivisionID = ""; v_DivisionName = m_UserDetails.get("Division"); l_CrmDivisions = zoho.crm.searchRecords("Divisions","Name:equals:" ...; Created on 01 September 2021
11. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... to a map m_Payload = crmAPIRequest.toMap(); // // get webhook signature v_ShopifySignature = "SIGNATURE_FAIL"; if(!isnull(m_Payload.get("headers"))) { if(!isnull(m_Payload.get("headers").get("x-shopify-hmac-sha256"))) { v_ShopifySignature ...; Created on 15 July 2021
12. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... D = 0; if(r_CreateCrmQuote.toMap().get("data") != null) { if(r_CreateCrmQuote.toMap().get("data").get(0) != null) { if(r_CreateCrmQuote.toMap().get("data").get(0).get("details") != null) { v_ResultingQuote ...; Created on 17 May 2021
13. Zoho Deluge: Convert Map to HTML Table without a FOR loop: / Zoho /; ... = l_Data.toString(); info v_Data; // yields // , Some formatting and a lot of replaceAll: l_Keys = List(); l_Keys = v_Data.toMap().keys(); v_DataHtml = v_Data.replaceAll("},{", true); v_DataHtml ...; Created on 11 January 2021
14. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... r_ApiResponse= invokeurl [ url :"https://people.zoho.com/people/api/leave/getEmployeesOnLeave" type :POST parameters: c_Params.toMap() connection: “peoplecf” ]; v_EmployeeCo ...; Created on 10 December 2020
15. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... be applied Solution: I have to convert the node into a map: info m_Response.get("item").toMap().get("item_id"); // yields: 123456789012345678 Problem: Inserting a date time string into a date ...; Created on 06 February 2020
16. Zoho Deluge - InvokeConnector and useful snippets: / Zoho /; ... { info r_UserDetails.get("id"); } List CRM Users (ActiveUsers) from Creator or other Zoho App Note the use of .toMap() required for other apps to read this JSON string response: l_Users= ...; Created on 23 January 2020