Search - Joel Lipman .Com

1. List last modified files using FTP Command-line: / File Transfer Protocol /; Why? So let's say my FTP client is not the most expensive (was FREE), nor the most advanced client out there, and I want to know what were the most recent files I modified and uploaded to a site, how ...; Created on 20 November 2012
2. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... order/package slip/invoice (if not exist) Date Created: 2022-05-05 (Joel Lipman) - Initial release Date Modified: 2023-01-23 (Joel Lipman) - Revamp of code - ...; Created on 27 April 2023
3. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... Date Created: 2023-03-29 (Joel Lipman) - Initial release Date Modified: 2023-03-29 (Joel Lipman) - Added in ability to list errors and query order line item IDs (ErrCode: ...; Created on 29 March 2023
4. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... Modified: 2023-03-21 (Joel Lipman) - ??? More Info: - DHL Developer Portal: https://developer.dhl.com/ - DHL Developer Portal Signup: https://developer.dhl.com/user/register - DHL ...; Created on 21 March 2023
5. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... ChatGPT Date Modified: 2023-03-11 (Joel Lipman) - Stores conversation messages / thread in CRM records - Retrieves and builds up conversation trail to send to OpenAI ...; Created on 06 March 2023
6. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... Created: 2023-03-01 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading ...; Created on 01 March 2023
7. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... Queries eBay for all orders given a from and till date Date Created: 2023-02-28 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: ...; Created on 28 February 2023
8. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... recently modified products at the end of each day and run some Deluge code against it to ensure that the data in Shopify is the same as in Zoho. In this case, Shopify is considered the source of truth ...; Created on 20 February 2023
9. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... p_CandidateID) Workflow: AB001: Associate Job Openings with Candidate Trigger: Workflow run whenever a candidate record is modified Purpose: Associates Job Openings with a Candidate when ...; Created on 08 February 2023
10. ZohoCRM: Import Attachments: / Zoho /; ... This is a "zcrm_" prefixed ID of the user who owns the attachment. Modified By Id: This is a "zcrm_" prefixed ID of the user who modified the attachment. Created By Id: This is a "zcrm_" prefixed ID of ...; Created on 16 January 2023
11. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... he record: SELECT DISTINCT c."Customer ID" AS "Customer ID", c."Customer Name" AS "Customer Name", c."Last Modified Time" AS "Customer Last Modified", c."Customer Sub Type" AS "Customer Type", ...; Created on 03 November 2022
12. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; What? This is a quick article to note down some code used in Zoho Recruit. This particular bit of code will run on a workflow when a Candidate is modified, and it tallies all the candidates belonging ...; Created on 19 October 2022
13. Zoho CRM: searchRecords with sorted results: / Zoho /; ... = "Lead:equals:" + v_RecordID + ""; // // set results parameters m_SearchParam = Map(); m_SearchParam.put("sort_by", "Modified_Time"); m_SearchParam.put("sort_order", "asc"); // // loop through each ...; Created on 10 February 2022
14. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
15. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... "modified_time_ms": 1567009834477, "owner_id": "12345678", "last_opened_time": "2019-08-28T16:30:33Z", "open_url": "https://writer.zoho.com/writer/template/a1b2c3d4", "last_opened_time_ms": ...; Created on 21 October 2021
16. ZohoCRM: Process all records of a module: / Zoho /; ... through each record and do what it has to do. The workaround here is that we order this by modified time. When the checkbox gets updated, this modifies the record and puts it at the bottom of the list. ...; Created on 24 August 2021
17. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... = ifnull(r_Result.get("Quote_Stage"),"-"); v_QuoteCurr = ifnull(r_Result.get("Quote_Currency"),"GBP"); v_QuoteTotal = ifnull(r_Result.get("Total_Amount"),0.0).toDecimal(); v_ExchangeRate = ifnull(r_Result.get("Exchange_Rate"),1); v_ModifiedTime ...; Created on 30 July 2021
18. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... ] }, "trigger": [] } Reading a Response The response on success would be something like: { "data": [ { "code": "SUCCESS", "details": { "Modified_Time": "2021-05-17T11:02:59+01:00" ...; Created on 17 May 2021
19. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... modified with content/text and the popup size will automatically resize based on content. I tend to use the first solution combined with a form/table of standard messages allowing the client to enter ...; Created on 06 November 2020
20. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... fex["_FileTimeM"] := A_LoopFileTimeModified } Break } If Not ( _FileExt ) ; Filepath not resolved { Return ...; Created on 07 August 2020