Search - Joel Lipman .Com

1. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... enter your own organization ID here for ZohoBooks and ZohoInventory v_BooksOrgID = 12345678901; // // evaluate v_currentDate = zoho.currentdate.toString("yyyy-MM-dd"); v_OrderDate = zoho.currentdate.toString("yyyy-MM-dd"); v_Page ...; Created on 27 April 2023
2. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // //info "Request Sent ...; Created on 29 March 2023
3. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... = zoho.currenttime.toString("yyyy-MM-dd ") + m_ShiftBuildUp.get(v_WorkDay).get("open").leftpad(5).replaceAll(" ", "0") + ":00"; v_FinishTime = zoho.currenttime.toString("yyyy-MM-dd ") + m_ShiftBuildUp.get(v_WorkDay).get("close").leftpad(5).replaceAll(" ...; Created on 28 March 2023
4. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... output to developer for debug purposes v_Date = zoho.currentdate.subDay(v_Index).toString("yyyy-MM-dd"); info v_Date; // // set criteria of what shipment orders to retrieve m_Criteria = Map(); m_Criteria.put("date",v_Date); // // ...; Created on 21 March 2023
5. 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
6. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // info "Request Sent t ...; Created on 01 March 2023
7. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... systems: l_CsvFileRows = List(); l_CsvFileRows.add("Me,Myself,I"); l_CsvFileRows.add("a,b,c"); // v_CSVFilename = "Test.csv"; f_CSVFile = l_CsvFileRows.toString("\n").toFile(v_CSVFilename); // // ...; Created on 01 March 2023
8. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... evaluate (specify here your dates [time set to midnight]) v_timeFrom = zoho.currenttime.subDay(0).toString("yyyy-MM-dd'T'00:00:00.000'Z'"); v_timeTill = zoho.currenttime.addDay(1).toString("yyyy-MM-dd'T'00:00:00.000'Z'"); // // ...; Created on 28 February 2023
9. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... = "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2222"; v_Endpoint = "https://" + v_ShopID + "/admin/api/" + v_ShopifyApiVersion.toString() + "/graphql.json"; // // set header parameters m_Header = Map(); m_Header.put("Content-Type","application/json"); m_Header.put("X-Shopify-Access-Token",v_AccessToken); // // ...; Created on 20 February 2023
10. 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
11. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... zoho.currenttime.toString("HH:mm:ss"); // // loop through our list for this page for each r_Candidate in l_Candidates { v_CountTotal = v_CountTotal + 1; v_CandidateZohoID = ifnull(r_Candidate.get("CANDIDATEID"),0); r_Associate ...; Created on 08 February 2023
12. Zoho Deluge: Generate a loop or list of any size: / Zoho /; ... my list to populate l_CheckDates = List(); // // loop through generated list and add dates for each index v_Index in l_GeneratedList { if(v_Index>0) { l_CheckDates.add(zoho.currentdate.addDay(v_Index).toString("yyyy-MM-dd")); } } ...; Created on 21 October 2022
13. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... + v_TLD); l_Params.add("grant_type=refresh_token"); v_Url = "https://accounts.zoho."+v_TLD+"/oauth/v2/token?" + l_Params.toString("&"); r_AccessToken = invokeUrl [ url: v_Url type: ...; Created on 17 October 2022
14. Zoho Inventory: Mark a package slip as delivered and shipped: / Zoho /; ... check the form was ticked and there is a package ID specified if(input.Mark_as_Complete && input.Zoho_Package_ID != "") { v_PackageID = input.Zoho_Package_ID; r_PackageSlip = zoho.inventory.getRecordsByID("packages",v_BooksOrgID.toString(),v_PackageID,"ab_inventory"); if(r_PackageSlip.get("package") ...; Created on 14 July 2022
15. 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
16. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); info x_Params; // // s ...; Created on 31 March 2022
17. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... = Document[Parent_Record == v_CrmContactID.toString() && Document_Name == r_Attachment.get("File_Name")]; if(r_CheckIfDocumentAlreadyExists.count() > 0) { r_NewDocumentRecord = Document[ID == ...; Created on 11 March 2022
18. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... field clear Calendar_Day_Select; input.Calendar_Day_Select:ui.add("<"); for each index v_DateIndex in { input.Calendar_Day_Select:ui.add(zoho.currentdate.addDay(v_DateIndex).toString("EEEE") + ...; Created on 09 March 2022
19. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; ... e Meeting"); // // the start time m_ScheduleMeeting.put("Start_DateTime",zoho.currenttime.addBusinessDay(1).toString("yyyy-MM-dd'T'HH:mm:ss","America/New_York")); // // the end time m_ScheduleMeeting.put("End_DateTime",zoho.currenttime.addBusinessDay(1).addMinutes(30).toString("yyyy-MM-dd'T'HH:mm:ss","America/New_York")); // ...; Created on 02 March 2022
20. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... v_AccessToken); // // set endpoint to retrieve 5 products v_Endpoint = "https://" + v_ShopID + "/admin/api/" + v_ShopifyApiVersion.toString() + "/products.json?limit=5"; // // curl (zoho invoke) request r_GetProduct ...; Created on 14 February 2022