Search - Joel Lipman .Com

1. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; What? This is an article documenting how to send a Zoho Deluge Map request to an API which is expecting nested/2d/multi-dimensonal arrays. In the example below, we are posting to a PHP script for testing ...; Created on 03 February 2021
2. Importing Joomla articles to WordPress posts: / Wordpress /; ... WordPress site. If post_type is to be post then append with ?p= otherwise use ?page_id=. Articles: ------ MIGRATING JOOMLA v1.5.# CONTENT TO WORDPRESS v3.2.# ------ ----------------------------------------------------------------- INSERT ...; Created on 16 August 2011
3. How to make a HTML form post its variables to itself: / Hypertext Markup Language /; The Issue You have a PHP page which generates a HTML form. When the user submits the form, you want the same PHP page to process the data. Solution I've seen a lot of people write CGI requests but ...; Created on 17 September 2009
4. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... + "/images.json"; r_UploadPhoto = invokeurl [ url :v_Endpoint type :POST headers:m_Header parameters: m_Params.toString() ]; v_Output = r_UploadPhoto; } return v_Output; } Sends ...; Created on 17 October 2021
5. 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
6. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... = invokeUrl [ url :"https://www.zohoapis.eu/crm/v2/coql" type :POST parameters: m_Params.toString() connection: "joels_coql_connection" ]; // // output info r_Coql; But ...; Created on 08 October 2021
7. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; ... City Another City Test State Test Zip Another State Another PostCode Test Country A different Country But the packing slip would display the Ship to address as the ...; Created on 07 October 2021
8. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; ... + v_CrmProductID + "/photo?restrict_triggers=workflow"; r_CrmPhoto = invokeurl [ url: v_Endpoint2 type: POST files: r_CreatorPhoto connection: "joels_crm" ]; info r_CrmPhoto; } } ...; Created on 27 September 2021
9. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... "Test Street 2", "city": "Test City", "state": "Test State", "zip": "Test Postal Code", "country": "Test Country" } } However, if you try forcing the billing or shipping address in yo ...; Created on 22 September 2021
10. Zoho Creator: Add a subform while creating a record: / Zoho /; ... Contact_Name.last_name=v_ContactSname Billing_Address.address_line_1=v_AddressLine1 Billing_Address.district_city=v_AddressCity Billing_Address.state_province=v_AddressCity Billing_Address.postal_Code=v_AddressZip ...; Created on 14 July 2021
11. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... post to the "Product_Details" key but to the respective module line item API name as per the following screenshot: Following the API names in this example, the Deluge code to send would be something ...; Created on 17 May 2021
12. 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
13. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... can book longer than a month): // set criteria to search for clashing annual leave dates (pre/post 1 month check) l_SearchCriterias = List(); m_SearchCriteria = Map(); m_SearchCriteria.put("searchField","From"); m_SearchCriteria.put("searchOperator","After"); m_SearchCriteria.put("searchText",v_GivenDateFrom.subMonth(1).toString("dd-MMM-yyyy")); l_SearchCriterias.add(m_SearchCriteria); m_SearchCriteria ...; Created on 10 December 2020
14. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... = 0; v_MatchedAccountID = 0; v_SearchName = "Father & Sons (Incorporated)"; // // replace apostrophes with double apostrophe for sql v_SearchName = v_SearchName.replaceAll("'","''",true); // // replace ...; Created on 28 August 2020
15. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... a perfectly ok post on the Microsoft website? Well I could bookmark that page or save myself a click... How? To test any of the following, type the windows key and select "Run..." ( + R). Then ...; Created on 30 July 2020
16. COVID-19: Working from Home: / Articles /; ... back is suffering terribly. I figured on a personal DSE assessment and setup my workstation as a more permanent solution. For fun, our office have posted what taking your work home, including the work ...; Created on 05 July 2020
17. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... url :v_AttachUrl type :POST files:r_FileDownload connection:"myconnector" ]; v_OutputMessage = v_OutputMessage + "File: " + v_FileInternalName.toString() + " CRM ...; Created on 15 May 2020
18. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... If you use POST then this adds/creates a record and if it already exists you will get a . Documentation advises that the payload is empty which is not true in my case. This is my invokeUrl: v_DataEndpoint ...; Created on 06 February 2020
19. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... from a 7 year old post; but now you can apply a containsIgnoreCase function to search the records: ... l_ProductDetails = Product[Product_Name.containsIgnoreCase(v_Name)]; ... Lastly, there ...; Created on 21 November 2019
20. Zoho Deluge - Modify the product line items in an invoice module: / Zoho /; ... item and posting the map back to the record. In the following example, we are swapping out the product "123456789012345678" with the product "987654321098765432" and p_InvoiceID is the ID of the invoice ...; Created on 22 August 2019