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. Import Excel CSV file as JavaScript array: / Excel /; ... convert to a JavaScript array of objects var my_object_array = [ , , ]; What I want again: Read a CSV file already uploaded with JavaScript Populate a JS array with each ...; Created on 05 October 2015
3. Sort an associative array by values in Javascript: / JavaScript /; What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. ...; Created on 29 September 2015
4. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... { // store the search results into an array var recordArr = response.data; // quick loop to find the preferred name ...; Created on 14 March 2024
5. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... the customer record. Instead, when building the invoice, this had to be added (don't ever remember having to do this) as contact_ids (array/list). Instead the below script will show you how to use this ...; Created on 07 March 2024
6. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... / send an order array l_OrderIDs = List(); m_OrderID = Map(); m_OrderID.put("OrderID",p_eBayOrderRef); l_OrderIDs.add(m_OrderID); m_Params.put("OrderIDArray",l_OrderIDs); // // convert to xml and repla ...; Created on 27 April 2023
7. 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
8. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... on the employee record So now we just need to append the following code which loops through the map / associative array we just created and shove this onto every employee's record. My employee recor ...; Created on 28 March 2023
9. 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
10. 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
11. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... var json_Row = new Array(); var json_Arg = new Object(); // get some values beforehand which allows us to compare to the rows already present in the subform // first column to add ...; Created on 09 December 2022
12. Zoho Deluge: Generate a loop or list of any size: / Zoho /; ... it to a list, then lets you generate an array or list of any size. Why? My use case here is to run a schedule that will populate a list with the upcoming dates for the next week (and for any numbers ...; Created on 21 October 2022
13. Zoho Creator / eBay: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store. Why? The use-case was that I wanted to retrieve ...; Created on 13 October 2021
14. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... it sent a payload (like a webhook) to my CRM REST API function. The following includes UserDeliveryPreferenceArray but I've successfully subscribed without this. I'm just including it because I want to ...; Created on 20 September 2021
15. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; What? This is a quick article documenting how to update custom fields in a line items or product details section of a transactional module such as Quotes, Sales Orders or Invoices using code: Zoho Deluge. ...; Created on 17 May 2021
16. Zoho Deluge: Convert Map to URL Parameters: / Zoho /; What? A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters. How? Let's first define a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id"); m_Payload.put("redirect_uri","https://www.joellipman.com"); m_Payload.put("response_type","code"); m_Payload.put("scope","my_api_scopes"); m_Payload.put("prompt","login"); Great! ...; Created on 09 March 2020
17. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... D { FullPathArray := StrSplit(A_LoopFileLongPath, "\") ThisFolder := FullPathArray[9] PreferenceFile := A_LoopFileLongPath "\Preferences" ; Get the preferences file from the profile ...; Created on 07 January 2020
18. PHP - Remove newlines and spaces from StyleSheet: / Personal Home Page /; ... 0 0 85px; box-shadow: 5px 5px 5px 0px rgba(51, 51, 51, 0.3); }"; $v_AppStyleFormatted = preg_replace('/\s+/', ' ', $v_AppStyle); and a few str_replace arrays: // exceptions $a_ReplaceFrom1 ...; Created on 03 January 2020
19. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops: / AutoHotkey /; ... ; init DetectHiddenWindows, Off v_LeftMost := 0 v_Center := 0 v_RightMost := 0 a_MyArray := Array() ; get all monitors (excl. hidden/virtual) SysGet, v_MonitorCount, ...; Created on 18 July 2019
20. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... // NOTE: convert this to a JSON Array r_RecordUpdate = invokeUrl [ url :v_EndPoint type :PUT headers: m_Header parameters:m_Data.toString() ]; // NOTE: convert parameters variable to a string ...; Created on 17 July 2019