Search - Joel Lipman .Com

21. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... the week number: c_Order = Order[ID == 123456890123456890]; if(c_Order.Order_Date != null) { v_ThisDate = c_Order.Order_Date.toString("EEEE, dd-MMM-yyyy u w"); v_ThisWeek = if(c_Order.Order_Date.toString("u").toLong()==7,c_Order.Order_Date.subDay(1),c_Order.Order_Date).toString("w"); } // ...; Created on 06 July 2023
22. 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
23. 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
24. 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
25. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... "days": "Saturday", "business_timing": [ "09:00", "15:00" ] } ], "daily_timing": null, "week_starts_on": "Monday", "same_as_everyday": false, ...; Created on 28 March 2023
26. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... Developer API Documentaiton: https://developer.dhl.com/api-reference/shipment-tracking#reference-docs-section */ // // initialize v_ShipmentStatus = "error"; v_TrackingNumber = ifnull(p_TrackingNumber,0); // // ...; Created on 21 March 2023
27. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... = ifnull(invoice.get("balance"),0); // // Get custom Amount to Pay from Invoice l_CustomFields = invoice.get("custom_fields"); if(l_CustomFields.size() > 0) { for each m_CustomField in l_CustomFields { if(m_CustomField.get("label") ...; Created on 16 March 2023
28. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... initialize v_Response = previousParam; m_Response = Map(); m_Response.put("todo","prompt"); l_Messages = List(); // // capture latest message from user v_Message = ifnull(userInput,""); m_Thread ...; Created on 06 March 2023
29. 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
30. 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
31. 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
32. 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
33. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... */ v_CandidateZohoID = ifnull(p_CandidateID,0); r_Associated = invokeurl [ url :"https://recruit.zoho.com/recruit/v2/Candidates/" + v_CandidateZohoID + "/associate" type :GET connection:"my_connection" ]; //info ...; Created on 08 February 2023
34. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... // check if end date is specified and if it is then add to this row v_EndDate = null; v_EndDateValue = ZDK.Page.getField('Actual_Finish_Date').getValue(); if (v_EndDateValue !== null) ...; Created on 09 December 2022
35. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... AS "PO Item Tax", poi."Quantity" AS "PO Qty", poi."FCY Tax Amount" AS "PO Line Tax", if_null(pshipping."PO Delivery", 0) AS "PO Total Shipping", if_null(pdiscrepancy."PO Discrepancy Total", 0 ...; Created on 03 November 2022
36. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; ... r_CandidateDetails; if(!isNull(r_CandidateDetails.get("Which School do you go to?"))) { v_SchoolName = r_CandidateDetails.get("Which School do you go to?"); v_SchoolID = r_CandidateDetails.get("Which ...; Created on 19 October 2022
37. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... POST ]; // // output v_AccessToken = ifnull(r_AccessToken.get("access_token"), ""); // // use the access token to query requests m_Header = Map(); m_Header.put("Authorization","Zoho-oauthtoken ...; Created on 17 October 2022
38. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... get the quote details given a record ID r_QuoteDetails = zoho.crm.getRecordById("Quotes",p_QuoteID); // // check target email is not null/blank if(!isnull(r_QuoteDetails.get("Email"))) { v_Url ...; Created on 18 August 2022
39. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... hasn't been populated l_Appointments = Appointment[Zoho_Inventory_Package_Slips == null] sort by Added_Time desc range from 0 to 100; for each c_Appt in l_Appointments { // // get package references ...; Created on 18 August 2022
40. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... ""; v_PaymentDate = null; v_Last4Digits = ""; r_UpdateInvoice = Map(); // // evaluate v_InvoiceID = invoice.get("invoice_id"); v_CustomerID = invoice.get("customer_id"); v_BooksOrgID = organization.get("organization_id"); v_InvoiceRef ...; Created on 17 August 2022