Search - Joel Lipman .Com

1. 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
2. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... = "replay-golf-export-active-page-" + zoho.currenttime.toString("yyyy-MM-dd-HH-mm-ss") + ".csv"; l_CsvFileRows.add("-----------------------------" + v_CSVFilename); v_CSVFile = l_CsvFileRows.toString("\n").toFile(v_CSVFilename); // ...; Created on 20 February 2023
3. 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
4. Zoho Creator / Shopify: 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 Shopify. Why? The use-case was that I wanted to search ...; Created on 12 October 2021
5. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... ct = Map(); if(v_FullName.contains(" ")) { v_Forenames = v_FullName.subString(0,v_FullName.lastIndexOf(" ")); v_LastName = v_FullName.subString(v_FullName.lastIndexOf(" ")); m_CreateContact.put("First_Name",v_Forenames); m_CreateContact.put("Last_Name",v_LastName); } else { m_CreateContact.put("First_Name",v_FullName); } m_CreateContact.put("Email",m_Notification.get("beneficiary_email")); m_CreateContact.put("Account_Name",v_ZCRM_DocRecordAccountID); m_CreateContact.put("Contact_Status","Active"); m_CreateContact.put("Lead_Source_Detail","Cre ...; Created on 06 August 2024
6. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... image URL to/from ZohoWriter. Loop through active users in ZohoCRM. Merge the HTML email signature with the fields evaluated. Function: fn_Workdrive_HostImage I add this function to the CRM ...; Created on 05 December 2023
7. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
8. 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
9. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... include fixed price items m_Pagination = Map(); m_Pagination.put("PageNumber",v_Page); m_Pagination.put("EntriesPerPage",v_PerPage); m_Params.put("Pagination",m_Pagination); //m_ActiveList.put("Sort","ItemID"); m_Params.put("ItemID",p_ItemID); // // ...; Created on 22 January 2022
10. 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
11. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... need to follow these steps to get the credentials: Login to your Twilio console On the dashboard, note the ACCOUNT SID and AUTH TOKEN In the side menu, expand Phone Numbers > Manage > Active numbers ...; Created on 16 December 2021
12. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... each r_User in r_Users.get("users") { // loop through active users if(r_User.get("status") == "active") { v_Email = ifnull(r_User.get("email"),""); v_LastName = ifnull(r_User.get("last_name"),""); // // ...; Created on 02 December 2021
13. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... "permalink": "https://docs.zoho.com/file/a1b2c3d4", "status": "active" }, { "created_time": "2019-08-28T16:30:33Z", "modified_time_ms": 1567009834477, "owner_id": "34567890", ...; Created on 21 October 2021
14. Zoho Deluge: Generate List of TimeZones: / Zoho /; What? A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing ...; Created on 19 October 2021
15. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; ... is written at a time when Javascript or interactive pages that change on the fly based on a mouse event in Zoho Creator automatically get removed on Save/Update of the page. The following uses the built-in ...; Created on 22 October 2020
16. Zoho Deluge - InvokeConnector and useful snippets: / Zoho /; What? So this is an article with some common snippets of code that use the InvokeConnector and do things we can't do in shortcode. List CRM Users (ActiveUsers) Note that this is somewhat superseded ...; Created on 23 January 2020
17. Zoho Deluge - Get Current User ID: / Zoho /; ... being deprecated (end of life at the end of this year). So I'm familiar with the methods in API v2 or just using newer functions. Method #1: API v1 userResp = getUrl(("https://crm.zoho.com/crm/private/xml/Users/getUsers?authtoken=xxxxxxxxxxx&scope=crmapi&type=ActiveUsers")); users ...; Created on 08 April 2019
18. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... Application.ActiveSheet.Range("A1").PasteSpecial Set xRow = xRow.Offset(SplitRow) Next Application.CutCopyMode = False Application.ScreenUpdating = True End Sub Press ...; Created on 11 February 2019
19. 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
20. Import Excel CSV file as JavaScript array: / Excel /; ... XMLHttpRequest to read file // (works at time of print (2015-10-05)) var xhr = !window.XMLHttpRequest ? new ActiveXObject('Microsoft.XMLHTTP') : new XMLHttpRequest(); // open ...; Created on 05 October 2015