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. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. Convert Past Date to Time Ago in PHP: / Personal Home Page /; ... // get seconds ago $v_Seconds = strtotime('now') - strtotime($p_Date); // set unit labels $a_UnitLabels = array('year','month','week','day','hour','minute','second'); // set unit values ...; Created on 16 May 2019
12. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... logic and highlight any changes you may need to make. 1. First: the variables are in arrays Well mostly. Simply because we'll be working with JSON data and this encodes/decodes easily into PHP ...; Created on 02 February 2019
13. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
14. Zoho Deluge - Get Full Day Name: / Zoho /; ... = today; Day_Name = My_Date.toString("EEEE"); // returns "Monday" Method #1: We're going to populate two arrays / lists; retrieve the index value; and use this in the second array as follows: // ...; Created on 08 November 2018
15. Zoho Deluge - Get English Ordinal: / Zoho /; ... built-in functions of Zoho deluge. Method #1: Using a list/array, I'm going to check the date against the 3 exceptions to this rule (11th, 12th and 13th of each month): // get the date (eg. 1, ...; Created on 08 November 2018
16. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... = ''; // expecting alphanumeric string $STORE_PATH = ''; // expecting *.json - needs to be writeable by system account $SCOPES = array($GAPIS_AUTH . 'userinfo.email', $GAPIS_AUTH . 'userinfo.profile'); ...; Created on 31 October 2018
17. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; ... true); // set authorization header curl_setopt($ch1, CURLOPT_HTTPHEADER, array('Content-Type: '.$mime_type, 'Content-Length: ' . filesize($file), 'Authorization: Bearer ' . $access_token) ); ...; Created on 29 October 2018
18. Accessing Apimo WebService API: / API Miscellaneous /; ... file_get_contents. Just storing this in case. // cURL With SSL via method GET: FAIL $header = array( "Content-Type: text/xml;charset=UTF-8", "Accept: gzip,deflate", "User-Agent: WWPC uAPI Test", "Cache-Control: ...; Created on 29 March 2016
19. Joes Quicklist Weblinks (JQW) Downloads: / Downloads /; ... Strict Standards Issue: New Operator removed for PHP5+. - Fixed Bug: Object without reference: Child object design converted to Object array.- Date Uploaded: Thu, 31st Oct 2013 3.0 - Fixed Bug: Version ...; Created on 07 September 2015
20. TravelPort Universal API - Ping Request with PHP-cURL: / API Miscellaneous /; Applies to: TravelPort Universal API PHP 4 or 5 cURL What? An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using ...; Created on 27 April 2015