Search - Joel Lipman .Com

1. 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
2. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... + "/products.json?status=active&limit=250&fields=id&order=id+asc&since_id=" + v_LastID; r_GetProducts = invokeurl [ url :v_Endpoint type :GET headers:m_Header ]; for each r_ShopifyProduct ...; Created on 12 October 2021
3. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; ... The above should yield something like: /1234567890123_my_beautiful_face.jpg ,"message":"photo uploaded successfully","status":"success"} Source(s): ZohoCRM REST API: Upload a Photo Zoho Deluge: ...; Created on 27 September 2021
4. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... = "-"; if(!isnull(r_Result.get("Valid_Till"))) { v_DateTill = r_Result.get("Valid_Till").toDate().toString("dd/MM/yyyy"); } m_DataRow.put("quote_name",m_LinkedValue); m_DataRow.put("valid_till",v_DateTill); m_DataRow.put("quote_status",r_Result.get("Quote_Status")); l_DataRows.add(m_DataRow); } } else { l_HeaderColumns ...; Created on 30 July 2021
5. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... : { "name": "Joel Admin", "id": "123456" } }, "message": "record added", "status": "success" } ] } and if using code to capture the ID: v_ResultingQuote ...; Created on 17 May 2021
6. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... ", "0"); v_HoursHHmm = v_TimeHour + ":" + v_TimeMinutes; // // build map m_CreateTimeLog = Map(); m_CreateTimeLog.put("date",v_StartTime.toDate().toString("MM-dd-yyyy")); m_CreateTimeLog.put("bill_status",v_Billable); m_CreateTimeLog.put("hours",v_HoursHHmm); m_CreateTimeLog.put("start_time",v_StartTime.toString("hh:m ...; Created on 30 April 2021
7. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... the requested dates as leave. [Warning: red herring ahead] For this process, we setup connections choosing to make use of the Zoho People API and we could update any of the fields EXCEPT for "ApprovalStatus" ...; Created on 10 December 2020
8. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... ms-settings:nfctransactions Proxy ms-settings:network-proxy Status ms-settings:network-status ms-settings:network VPN ms-settings:network-vpn Wi-Fi ms-settings:network-wifi Wi-Fi Calling ms-settings:network-wificalling ...; Created on 30 July 2020
9. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... s7, Verdana Gui, Add, StatusBar,, Ready. Gui, Show, w%Width% h%Height% x10 y10 Return ; -------------------------------------------------------------------------------------- ; Function: CountExistingInColumn2: ...; Created on 08 July 2020
10. Zoho Deluge: Duplicate/Clone a Record: / Zoho /; ... now override fields specific to the newly cloned/duplicated record m_Clone.put("Invoice_Status","Repeated Invoice"); m_Clone.put("Invoice_Date",zoho.currentdate.toString("yyyy-MM-dd")); m_Clone.put("Due_Date",zoho.currentdate.addMonth(1).toStartOfMonth().subDay(1).toString("yyyy-MM-dd")); // ...; Created on 17 March 2020
11. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... value is "2020-02-10T11:49:12+0100" // yields ,"message":"invalid data","status":"error"} Solution: The above ALMOST works for API and Deluge Shortcode, but we're missing the colon in the TimeZone value: ...; Created on 06 February 2020
12. Zoho Deluge - InvokeConnector and useful snippets: / Zoho /; ... Map(); m_UserType.put("type","ActiveUsers"); r_Response = zoho.crm.invokeConnector("crm.getusers",m_UserType); if(!isnull(r_Response.get("status_code"))) { if(r_Response.get("status_code")==200) { l_Users ...; Created on 23 January 2020
13. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... "Sort") ; sort the second column (profile names) Gui, Font, s8, Verdana Gui, Add, StatusBar,, Ready. Gui, Show, w%Width% h%Height% x10 y10 Return ; -------------------------------------------------------------------------------------- ; ...; Created on 07 January 2020
14. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... the above error, try setting the currentUserEmail to the email address of the super admin of your system just to check, then set a valid user preferably other than the super-admin. ,"message":"body","status":"error"}: ...; Created on 17 July 2019
15. Zoho Deluge - Get User Timezone, Country and Location: / Zoho /; ... = getUrl( v_Url ); // usage: v_TimeZone = v_Response.getJSON("timezone"); Returns something like: { "query": "147.188.254.175", "status": "success", "continent": "Europe", "continentCode": ...; Created on 03 June 2019
16. Zoho Deluge - Update Creator from CRM: / Zoho /; ... "criteria": "ID==1234567890123456789", "newvalues": [ { "FieldToUpdate": "ValueToUpdateWith" } ], "status": "Success" } Method #2: Using API v1 (using JSON not XML) Generate ...; Created on 18 February 2019
17. 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
18. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... Add, TreeView, x2 y25 w496 h310 vMyFolderTree ImageList%ImageListID% Gui, Add, StatusBar, v_StatusBar Gui, Show, w%Width% h%Height% xCenter yCenter SB_SetText("Ready.") Return ; -------------------------------------------------------------------------------------- ; ...; Created on 28 January 2019
19. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... both systems. Import new ones. Copy all users except the v25 admin to your v34 database (with status=blocked) Copy over user group mappings Update new system admin details with old (name, registration ...; Created on 12 September 2015
20. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... status v1.6.x [5 Nov 2014] - [1.6.2] Map: return zones within 15km radius (was 111km) - [1.6.2] Map: return up to 100 zones (was 20) - [1.6.2] Map: tooltip with categorized zones - [1.6.2] Map: ...; Created on 24 October 2014