Search - Joel Lipman .Com

21. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... request XML as a string r_ResponseXML = invokeurl [ url :v_Endpoint type :POST parameters:x_Params headers:m_Headers ]; // // output response info r_ResponseXML; // // ...; Created on 13 October 2021
22. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... query v_CoqlQuery = "select distinct Currency from Quotes where Subject!=''"; // // build up parameters m_Params = Map(); m_Params.put("select_query",v_CoqlQuery); // // invokeUrl r_Coql ...; Created on 08 October 2021
23. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... url: v_Endpoint type: PUT parameters: m_ShippingAddress.toString() connection: "joels_connector" ]; info r_UpdateSO; } } Source(s): Zoho Community ...; Created on 22 September 2021
24. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... invokeurl [ url :v_TokenEndpoint type :POST parameters:m_Params headers:m_Headers ]; //info r_eBayResponse; if(!isnull(r_eBayResponse.get("access_token"))) { // ...; Created on 20 September 2021
25. ZohoCRM: zoho.crm.searchRecords only returns certain records: / Zoho /; ... searchRecords function requiring it's 5th parameter which defaults to "not converted" records: =zoho.crm.searchRecords(,,,,,); The solution: The long answer/investigation is getting a JSON response ...; Created on 29 July 2021
26. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... it Shopify - Webhook - Order Update Specify the Category, I'm going to say Standalone Specify the Function parameters/Arguments EXACTLY as this: crmAPIRequest of data type string. IMPORTANT! It won ...; Created on 15 July 2021
27. Zoho Deluge: Zoho Bookings Get Available Slots: / Zoho /; ... to allow customers to make a booking based on the configuration and appointments in a ZohoBookings instance. How? The getAvailableSlots function requires as parameters according to documentation ...; Created on 23 June 2021
28. Zoho CRM REST API: Stop Workflow from Triggering: / Zoho /; ... = invokeurl [ url :v_Url type :PUT parameters:m_Data.toString() connection:"ascentbusiness" ]; or l_Quotes = List(); l_Quotes.add(m_CreateCrmQuote); m_Data = Map(); m_Data.put("data",l_Quotes); m_Data.put("trigger",[]); v_Url ...; Created on 16 June 2021
29. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... :POST parameters:m_Data.toString() connection:"myconnection" ]; or if converted to JSON, the request would read as: { "data": { "Subject": "My Test Quote", "Quoted_Items": [ { ...; Created on 17 May 2021
30. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... = invokeurl [ url :v_Url type :POST parameters:m_CreateTimeLog connection:"joels_connector" ]; info r_CreateTimeLog; Example #2: Pushing a time log defaulting to the current time as start ...; Created on 30 April 2021
31. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... 's Awesome Life"); m_NestedRequest.put("data[item_price]","priceless"); r_PostResponse = invokeurl [ url :"https://api.joellipman.com/my_test_api.php" type :POST parameters:m_NestedRequest ]; ...; Created on 03 February 2021
32. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... Customization > Forms > Leave Under "Form Properties" > Tick the box under "Validation" for "Custom Validation" to create a function: Ensure you select parameters to input rather than retrieving ...; Created on 10 December 2020
33. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... we'll go into more detail: Create a function that accepts a form of records Create a workflow that understands the function parameters Create a function Why are we doing this first? Well ...; Created on 06 December 2020
34. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... call it "Notify". Add the 2 parameters p_NotifyTitle and p_NotifyContent to the page: Then drag a HTML snippet onto the page with the following: /* optional: hide some of the wrapper div boxes: ...; Created on 06 November 2020
35. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... page (new or existing), select "Widgets" and drag your new Widget to the page: Don't forget to click on the page settings (cog in the top right) and add a parameter, in this case "name": Great! ...; Created on 24 October 2020
36. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... up parameters m_Params = Map(); m_Params.put("select_query",v_CoqlQuery); // // invokeurl r_Coql = invokeurl [ url :"https://www.zohoapis.eu/crm/v2/coql" type :POST parameters:m_Params.toString() ...; Created on 28 August 2020
37. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... to say connected. Done! Now you can use this in your custom function with the invokeURL without the need for a header parameter: response = invokeUrl [ url: "https://books.zoho.com/api/v3/estimates?organization_id=12346789" ...; Created on 12 August 2020
38. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... Return } SplitPath, sFile, _FileExt, _Dir, _Ext, _File, _Drv If ( p[p.length()] = "xInfo" ) ; Last parameter is xInfo { p.Pop() ...; Created on 07 August 2020
39. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... file You might have tested using the trusty sendmail function and then got an error when adding the "attachments" parameter. As a reminder, content-type in the sendmail is not supported in Zoho Creator ...; Created on 15 May 2020
40. Zoho Deluge: Duplicate/Clone a Record: / Zoho /; ... for "Invoices": /* Function: fn_Button_CloneInvoice Purpose: This function duplicates a CRM invoice Parameters: p_InvoiceID (CRM ID of the invoice) Returns: Nothing Author: Joel Lipman Date Created: ...; Created on 17 March 2020