Search - Joel Lipman .Com

21. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... a message handler or participation handler. As for the usage, simply ask the Cliq Bot a question and it will forward the query and respond with the response from the OpenAI API. Setup a Zoho Cliq ...; Created on 13 February 2023
22. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... where our client wants to query Zoho Recruit via the API but couldn't find a database table to determine who has been associated to what job. In Zoho Recruit reports (Analytics), you can include the "Associate" ...; Created on 08 February 2023
23. Zoho Analytics: Set Up a Widget Displaying Sales Person: / Zoho /; What? A quick article to display a value in a column in a widget in Zoho Analytics. Why? Because I keep forgetting how to do it. How? I've done this for a query that amalgamated all the ...; Created on 24 October 2022
24. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... build URL to query l_Params = List(); l_Params.add("refresh_token="+v_RefreshToken); l_Params.add("client_id="+v_ClientID); l_Params.add("client_secret="+v_ClientSecret); l_Params.add("redirect_uri=https%3A%2F%2Fsign.zoho." ...; Created on 17 October 2022
25. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... = " } } }"; m_GraphQl = Map(); m_GraphQl.put("query", v_GraphQl); // // Let's test with this GraphQL query v_Endpoint = "https://" + v_ShopID + "/admin/api/" + v_ShopifyApiVersion.toString() + "/graphql.json"; r_GetProduct ...; Created on 14 February 2022
26. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... can use the following code, note that the parameter is the eBay Item ID: void API.fn_eBayQuery_GetItemTransaction(int p_ItemID) { /* Function: fn_eBayQuery_GetItemTransaction() Input: ...; Created on 22 January 2022
27. 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
28. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... ******************************************************************************* // Generate your access token to connect to Xero and query Xero records // See my article: https://www.joellipman.com/articles/crm/zoho/zoho-deluge-sync-to-xero-api.html // v_TenantID ...; Created on 10 January 2022
29. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... + r_GeoCode.get("latitude")); l_Params.add("lng=" + r_GeoCode.get("longitude")); l_Params.add("by=position"); } // // query with a GET method r_Timezone = getUrl("http://api.timezonedb.com/v2.1/get-time-zone? ...; Created on 15 December 2021
30. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... sunday but we want to start counting from Monday 00:00 v_FirstDateOfWeek = zoho.currentdate.toStartOfWeek().addDay(1).toString("yyyy-MM-dd"); // // build up COQL Query v_CoqlQuery = ...; Created on 02 December 2021
31. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... these in a cURL request (same thing really): string API.fn_ShopifyQuery_UploadPhoto(int p_Position, int p_ProductID) { v_Output = ""; m_Header = Map(); m_Header.put("Content-Type","application/json"); // ...; Created on 17 October 2021
32. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... Map datatype. How? I'm not going to go into detail on how I create an access token to query the eBay Trading API as you can read this in my article: Joellipman: Zoho Creator: Push to eBay Listings. ...; Created on 13 October 2021
33. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... It then outputs a JSON list as a response and the total record count: void API.fn_ShopifyQuery_GetActiveProducts() { m_Header = Map(); m_Header.put("Content-Type","application/json"); // // ...; Created on 12 October 2021
34. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... up a SQL query, or more specifically, a COQL - CRM Object Query Language Try using distinct on a single-line text field Adapt the query for unique values in a lookup field I won't demonstrate ...; Created on 08 October 2021
35. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... notification preferences are setup. This one didn't tell me much first time I ran it but I can use it later on to check if my "setting the notifications" process worked. void API.fn_eBayQuery_GetNotificationPreferences() { /* ...; Created on 20 September 2021
36. Zoho Deluge: Zoho Bookings Get Available Slots: / Zoho /; What? This is an article of code snippets to query a Zoho Bookings instance from within Creator. This one focuses on getting the available slots. Why? This is for a Creator app which had a form ...; Created on 23 June 2021
37. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... D = r_CreateCrmQuote.toMap().get("data").get(0).get("details").get("id"); } } } Retrieving a record with 2.1 JSON The following is a snippet when querying a CRM module (invoices) from a CRM functio ...; Created on 17 May 2021
38. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; What? This is an article documenting how to create a Zoho Creator Widget which includes the Bootstrap and jQuery frameworks as well as other JavaScript functionality. Why? Quite simply that at ...; Created on 24 October 2020
39. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; ... own version of Bootstrap and jQuery. This is the first example I have where you would want dynamic content in a Zoho Creator page without the use of JavaScript or 'Widgets JS'. How? Here are some ...; Created on 22 October 2020
40. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... I have found to work each time is using the CRM Object Query Language or Zoho's COQL. Similar to SQL but subject to similar issues of escaping special characters... 1. Setup a CRM Connection to Search ...; Created on 28 August 2020