Search - Joel Lipman .Com

1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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:"ab_recruit" ]; //info ...; Created on 08 February 2023
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. Zoho Inventory: Mark a package slip as delivered and shipped: / Zoho /; ... != null) { if(r_PackageSlip.get("package").get("salesorder_id") != null) { v_SalesOrderID = r_PackageSlip.get("package").get("salesorder_id"); } if(r_PackageSlip.get("package").get("shipment_order") ...; Created on 14 July 2022
16. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... OnSubmit > click on Create Workflow Select you want to run some Deluge Script and plug in the following code if(!isnull(input.Zoho_Inventory_ID)) { // // specify your own Inventory/Books organization ...; Created on 31 March 2022
17. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... = zoho.crm.getRelatedRecords("Attachments","Contacts",v_CrmContactID,1,200,m_SortCriteria); for each r_Attachment in l_Attachments { if(r_Attachment.get("id") != null) { v_AttachmentEndpoint = "https://www.zohoapis.com/crm/v2/Contacts/" ...; Created on 11 March 2022
18. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... = ifnull(p_SKU,""); v_GraphQl = " product } } } }"; m_GraphQl = Map(); m_GraphQl.put("query", v_GraphQl); // // Send this GraphQL query v_Endpoint = "https://" + v_ShopID + "/admin/api/" + v_ShopifyApiVersion.toString() ...; Created on 14 February 2022
19. 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
20. Zoho CRM: searchRecords with sorted results: / Zoho /; ... expressions then separate each with parenthesis joined by "and" or "or". Nulls are not returned. Set the "ModuleToSearch" to the API Name of the module you want to search. Method #1: zoho.crm.searchRecords() ...; Created on 10 February 2022