Search - Joel Lipman .Com

1. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... m_Header detailed: true ]; // // parse response if(r_ShipmentDetails.get("responseCode")==200) { l_Shipments = r_ShipmentDetails.get("responseText").get("shipments"); for each r_Shipment in l_Shipments ...; Created on 21 March 2023
2. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... There are several steps, so first we will set up the ZIA action "Ask ChatGPT" using the GUI, then we will capture the question using Deluge code and query the OpenAI ChatGPT API to return a response. ...; Created on 06 March 2023
3. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonProducts = List(); // // start preparing CSV file to email for export v_ReportCSV = "ItemID,ItemName,Price,CurrencyCode,QuantityAvailable,SKU,DateCreated"; l_CsvFileRows ...; Created on 01 March 2023
4. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... response or response of info: try holding down the ALT key and pressing 255, then releasing the ALT key and save the change to your code. This will not display a character but is a new line... Thought ...; Created on 01 March 2023
5. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... as a string x_ResponseBody = invokeurl [ url :v_Endpoint type :POST parameters:x_Params headers:m_Headers ]; Parsing the response into JSON or a Deluge Map This can be appended to the ...; Created on 28 February 2023
6. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... :POST parameters:m_GraphQl.toString() headers:m_Header ]; //info r_GetProductVariants; // // parse the response if(r_GetProductVariants.get("data") != null) { if(r_GetProductVariants.get("data").get("productVariants") ...; Created on 20 February 2023
7. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... and respond with the responses I programmed it to answer with. Any variations of the questions it did not understand, it would return a response similar to Siri or Ask Google where it includes the keywords ...; Created on 13 February 2023
8. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... there's more documentation on the API for Zoho Books, we're going to apply this solution to Zoho Books. How? We're not going to go into detail on how to parse an eBay response here (see my other articles ...; Created on 21 June 2022
9. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... URL and retrieve this Get Zoho CRM to generate an XML request to upload the photo to eBay's Hosted Picture Services Get Zoho CRM to parse the eBay response and return the eBay hosted URL Detailed ...; Created on 31 March 2022
10. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; What? Following on my article of creating a task using Zoho Deluge and scheduling a call using Zoho Deluge, here's an article on creating a Meeting or an Event using Zoho Deluge. Why? Because ...; Created on 02 March 2022
11. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... parse the response if(!isnull(r_GetProduct.get("data"))) { if(!isnull(r_GetProduct.get("data").get("productVariants"))) { if(!isnull(r_GetProduct.get("data").get("productVariants").get("edges"))) ...; Created on 14 February 2022
12. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... / return response return m_Output; Click "Save" and Done! Yields: Additional Note(s): If the user's profile is blank, the rule will not apply to them. l_Disallowed = List(); l_Disallowed.add("Joel"); if(l_Disallowed.contains("")) { in ...; Created on 11 February 2022
13. Zoho CRM: searchRecords with sorted results: / Zoho /; What? This is an article to document how to use the searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system ...; Created on 10 February 2022
14. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... request XML as a string r_ResponseXML = invokeurl [ url :v_Endpoint type :POST parameters:x_Params headers:m_Headers ]; // // output response info r_ResponseXML; /* // // ...; Created on 22 January 2022
15. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; ... I'm going to show you the code first of how to parse the eBay Transaction data and then the code to create a Shopify Order: Parse an eBay Transaction Notification (XML) x_ResponseBody = input.Payload.getJSON("body"); v_MainNodeName ...; Created on 21 January 2022
16. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... in your function) m_Payload = crmAPIRequest; // // initialize response variable m_Response = Map(); // // get xero signature v_XeroSignature = "SIGNATURE_FAIL"; if(!isnull(m_Payload.get("headers"))) { if(!isnull(m_Payload.get("headers").get("x-xero-signature"))) { v_XeroSignature ...; Created on 10 January 2022
17. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... JSON request r_TwilioResponse = invokeurl [ url :v_Endpoint type :POST parameters:m_Data ]; // // display to user/developer the response return r_TwilioResponse; Adapting it to trigger ...; Created on 16 December 2021
18. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... + l_Params.toString("&")); // // if we got a response from the third-party API, let's go through the CRM picklist options to find the relevant one if(!isnull(r_Timezone.get("zoneName"))) { v_TimeZone ...; Created on 15 December 2021
19. Zoho CRM: Schedule a Call using Deluge: / Zoho /; ... If that were the case, it would have been a 5 minute job. Instead, it's turned into over an hour of figuring this out. So here's a working snippet of code: // test to get the JSON response format r_CallDetails ...; Created on 18 November 2021
20. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... and attach r_DownloadResponse = zoho.writer.mergeAndDownload("aaaabbbbccccddddeeeeffff000011112222333344445555", "pdf", m_MergedData, "joels_connector"); r_AttachResponse = zoho.crm.attachFile("Contacts" ...; Created on 21 October 2021