Search - Joel Lipman .Com

21. 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
22. 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
23. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... // send request to chatgpt openai r_ChatGPTResponse = invokeurl [ url :"https://api.openai.com/v1/chat/completions" type :POST parameters:m_Params.toString() headers:m_Header detailed:true ]; if(r_ChatGPTResponse.get("responseCode" ...; Created on 06 March 2023
24. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ReturnAll"); // // specify only the active list m_ActiveList = Map(); m_ActiveList.put("Include",true); m_ActiveList.put("ListingType","FixedPriceItem"); m_ActiveList.put("Sort","ItemID"); // // ...; Created on 01 March 2023
25. 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
26. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... API.fn_ShopifyQuery_UpdateAllProducts() { // init v_CountTotal = 0; v_CountUpdated = 0; v_PerPage = 10; b_HasNextPage = true; v_Cursor = ""; l_CsvFileRows = List(); // // start preparing ...; Created on 20 February 2023
27. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... = invokeurl [ url :"https://api.openai.com/v1/chat/completions" type :POST parameters:m_Params.toString() headers:m_Header detailed:true ]; if(r_ChatGPTResponse.get("responseCode") == ...; Created on 13 February 2023
28. ZohoCRM: Import Attachments: / Zoho /; ... := fn_Slugify(v_NewFile) v_NewFile := fn_MD5(v_NewFile, true) "_" v_DisplayName StringLower, v_NewFile, v_NewFile ; find the foreign key v_ForeignKey := "-" v_FKCount := 0 GuiControlGet, ...; Created on 16 January 2023
29. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... var v_DealRate4 = r_DealDetails.Rate_Year_4_0; // default setting for alerting user let b_ShowAlertMessage = true; // specific values based on trigger field if (v_RateCard == ...; Created on 09 December 2022
30. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... les Person ID" IS NOT NULL ORDER BY "Invoice ID" DESC ) i ON i."Customer ID" = c."Customer ID" LEFT JOIN "Sales Persons" sp4 ON sp4."Sales Person ID" = i."Sales Person ID" And for true profits, we ...; Created on 03 November 2022
31. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; ... School do you go to?_ID"); b_SchoolPaid = if(r_CandidateDetails.get("Paid School") == "true",true,false); // v_CandidatePlacedCount = 0; v_CandidateGraduatingCount = 0; v_CandidateGraduatingNextCoun ...; Created on 19 October 2022
32. ZohoCRM: ZDK Client Script to retrieve Contact Email: / Zoho /; ... saving the record. At time of print however, I can't get a formula field to retrieve a field from another CRM record. // freezes the GUI? ZDK.UI.freeze(true); // attempt try { // get ...; Created on 20 July 2022
33. Zoho Inventory: Mark a package slip as delivered and shipped: / Zoho /; ... HH:mm")); m_Params.put("tracking_number","N/A"); l_UrlParams = List(); l_UrlParams.add("salesorder_id=" + v_SalesOrderID); l_UrlParams.add("package_ids=" + v_PackageID); l_UrlParams.add("is_delivered=true"); l_UrlParams.add("organization_id= ...; Created on 14 July 2022
34. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... as you would any other reading stuff. It’s true you need to go through an initial set-up process which essentially boils down to getting your email ID added to the approved list as well as finding out ...; Created on 29 June 2022
35. Zoho Creator: Embed Forms/Reports on a Page: / Zoho /; What? Well known by most but this serves as a quick reminder to myself and anyone else on how to embed a form or a report into a Zoho Creator page. Why? Cos How? The below is a template ...; Created on 05 May 2022
36. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... URL of the hosted image if(r_ResponseXML.containsIgnoreCase("Success") || r_ResponseXML.containsIgnoreCase("Warning")) { v_BiggestHeight = 0; x_RespondedXML = r_ResponseXML.replaceFirst("xmlns=\"urn:ebay:apis:eBLBaseComponents\"","",true); x_PictureSets ...; Created on 31 March 2022
37. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... the Location of your product variant (where "1234567890" is the location ID) to get the recent 10 products updated today: { productVariants( first: 10 reverse: true query: "updated_at:>'2022-02-14T00:00:00+0000'" ...; Created on 14 February 2022
38. Zoho CRM: searchRecords with sorted results: / Zoho /; ... true); r_UpdateAccount = zoho.crm.updateRecord("Accounts", v_AccountID, m_UpdateAccount); // optional: output response of update request info v_AccountID + "::" + r_UpdateAccount.toString(); } ...; Created on 10 February 2022
39. Zoho Deluge: a HTML Entity Decoder: / Zoho /; ... = v_StringToDecode.replaceAll(v_HtmlKey, m_HtmlEntity.get(v_HtmlKey), true); } // // output return v_StringToDecode; } Usage: v_TestString = "Father & Sons"; v_DecodedString = thisapp.DataCleansing.fn_DecodeHtmlEntities(v_TestString); info ...; Created on 27 January 2022
40. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022