Search - Joel Lipman .Com

1. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... at the moment, and the endpoint will depend on your datacenter (eg. COM or EU), and lastly the connection "joel_books" is my connection to ZohoBooks: // // declare ID of item in Zoho Inventory v_InventoryId ...; Created on 21 June 2022
2. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... the scope(s) ZohoInventory.items.READ (add some more if you're unsure...) Give it a connection name and note down the connection link name. I'm calling mine joel_zoho Authorize it, etc. Make a ...; Created on 31 March 2022
3. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... String crmAPIRequest Outputs: output message to user Date Created: 2022-02-11 (JoelLipman.com - Joel Lipman) - Initial release - Checks the user profile ...; Created on 11 February 2022
4. Zoho CRM: searchRecords with sorted results: / Zoho /; What? This is an article to document how to use the searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system ...; Created on 10 February 2022
5. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... int p_ItemID (eBay Item ID) Purpose: Fetches a line item transaction per item ID Date Created: 2022-01-22 (Joellipman - Joel Lipman) - Initial release More Info: ...; Created on 22 January 2022
6. 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
7. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... ******************************************************************************* // Generate your access token to connect to Xero and query Xero records // See my article: https://www.joellipman.com/articles/crm/zoho/zoho-deluge-sync-to-xero-api.html // v_TenantID ...; Created on 10 January 2022
8. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... :GET connection:"joels_connector" ]; if(!isnull(r_Response.get("fields"))) { // loop through every field to find the customer's timezone one for each r_Field in r_Response.get("fields") { if(r_Field.get("api_name") ...; Created on 15 December 2021
9. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; ... has not been tested extensively. Do not use if you are unsure it is calculating correctly. I use these to store the values in a table that can be double-checked at a later date. Source(s): Joel ...; Created on 07 December 2021
10. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... Source(s): Joel Lipman: Zoho Deluge: Generate List of TimeZones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file) Wikipedia: Daylight saving time by country Wikipedia: ...; Created on 07 December 2021
11. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... Friday at 08:00 in the morning and will create a task if time logged is too low and will remind via Popup at about 4pm (16:00). You will need a connector (I've called mine joel_timesheet) and I've given ...; Created on 02 December 2021
12. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... when locking it down for security: Login to ZohoCRM > Setup > Developer Space > Connections > Zoho OAuth Give your connection a name, I'm calling mine "Joels Connector" Select the Scopes: ZohoWriter.documentEditor.ALL ...; Created on 21 October 2021
13. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... Source(s): Zoho Deluge: Supported Time Zones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file) Wikipedia: Daylight saving time by country Wikipedia: List of tz database time ...; Created on 19 October 2021
14. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... Create a new Product Image Joellipman.com: Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments) Joellipman.com: Zoho Deluge: Get Image Uploaded in Creator Form Joellipman.com: ...; Created on 17 October 2021
15. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... Map datatype. How? I'm not going to go into detail on how I create an access token to query the eBay Trading API as you can read this in my article: Joellipman: Zoho Creator: Push to eBay Listings. ...; Created on 13 October 2021
16. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... = invokeUrl [ url :"https://www.zohoapis.eu/crm/v2/coql" type :POST parameters: m_Params.toString() connection: "joels_coql_connection" ]; // // output info r_Coql; But ...; Created on 08 October 2021
17. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; ... $ $ and in my Sales Order: BILLING ADDRESS SHIPPING ADDRESS ------------------- ------------------- Test Company Joels PO Box 1 Test Street 1 Different Street Test ...; Created on 07 October 2021
18. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; ... photo to CRM: // init v_AppOwner = "joel_the_awesomest"; v_AppName = "joels_app"; v_ReportName = "My_Report"; // specify your CRM record ID for this product v_CrmProductID = 1234567890123456789; // ...; Created on 27 September 2021
19. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... check the URL for whether it will be https://books.zoho.eu or https://books.zoho.com. You will also need your own CRM to Books connection name (joel_books) with scope to read settings: // our made ...; Created on 24 September 2021
20. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... url: v_Endpoint type: PUT parameters: m_ShippingAddress.toString() connection: "joels_connector" ]; info r_UpdateSO; } } Source(s): Zoho Community ...; Created on 22 September 2021