Search - Joel Lipman .Com

1. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... / only create document events for the following l_CreateEventsFor = ; // // check notifications if(!isNull(m_Body.get("notifications"))) { m_UpdateDoc = Map(); m_Notificati ...; Created on 06 August 2024
2. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... ) != null) { // // my app is the only one using the orders/updated webhook topic/trigger if(m_ThisWebhook.get("topic").equalsIgnoreCase("orders/updated")) { b_RestoreOrderUpdateWebho ...; Created on 22 April 2024
3. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... We have no intention of creating a new record per file... Saying that, the file name will change every time it is updated as you will see. Also note, I have a form called "Document", a report called ...; Created on 25 March 2024
4. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... store this after the record is created/updated (was getting error if included in record creation - if in same row). // c_ImageRow.File_field = f_DownloadFile; // // let's get the local ...; Created on 26 January 2024
5. Zoho Books: System Values Maps: / Zoho /; ... that for the below, I recently updated this article (2024-05-21) due to the API domain name change from https://books.zoho.com to https://www.zohoapis.com/books and changed the Top Level Domain (or Zoho ...; Created on 07 November 2023
6. 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
7. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... GraphQL The key value to retrieve is "cursor"; we're also going to use "hasNextPage" to determine if we need to keep looping: { productVariants(first: 10, query: "updated_at:>'2023-02-20T00:00:00+0000'") ...; Created on 20 February 2023
8. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... if Deal ID is not zero, then it was found! if(v_DealID != 0) { r_DealDetails = zoho.crm.getRecordById("Deals",v_DealID,); // // do stuff here such as updating the deal if required m_UpdateDeal ...; Created on 17 October 2022
9. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... the function this worked as expected. Now put it on a workflow where the settings were: When an invoice is "Created or Edited" Execute the workflow when "When any field is updated" Filter the triggers ...; Created on 17 August 2022
10. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; What? A quick article on how to upload an image to the product/item listing in Zoho Inventory. Why? We're enhancing the out-of-the-box integration from eBay to Zoho Inventory bespoke for a customer. ...; Created on 21 June 2022
11. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; What? This is an article which is the updated version of my article Zoho Deluge: Push Item to Shopify API for 2022 using the new policy that Shopify have implemented when creating a custom app. Why? ...; Created on 14 February 2022
12. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... */ v_Found = 0; v_Updated = 0; v_Page = 1; v_PerPage = 10; m_Output = Map(); r_Api = API_Integration[Connection_Name == "eBay API (Production)"]; if(r_Api.count() > 0) { v_AccessToken ...; Created on 22 January 2022
13. 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
14. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; What? So this is an article expanding on my article Zoho Deluge - Connect to Xero API and explores how instead of a schedule, we can get Xero to tell ZohoCRM whenever an invoice or contact gets updated ...; Created on 10 January 2022
15. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... "image": { "position": 1, "width": 3024, "height": 3024, "alt": null, "id": 12345678901234, "product_id": 9876543210987, "created_at": "2021-10-17T21:45:56+01:00", "updated_at": ...; Created on 17 October 2021
16. ZohoCRM: Deluge: Map a custom field from user profile: / Zoho /; ... != "") { m_UpdateDeal = Map(); m_UpdateDeal.put("Division",v_DivisionID); r_UpdateDeal = zoho.crm.updateRecord("Deals",v_DealID,m_UpdateDeal); info r_UpdateDeal; } } break; } } ...; Created on 01 September 2021
17. 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
18. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... Shopify webhook payload is now in your Zoho Creator! Having used this for a while, we average about 5 seconds from when the Order is updated (with payment?) in Shopify to when it gets parsed and created ...; Created on 15 July 2021
19. Zoho CRM REST API: Stop Workflow from Triggering: / Zoho /; ... equivalent Creator record). There was also a workflow that ran when the Creator record was updated to update its changes to CRM. It was actually causing a loop which used up all the API calls. How? ...; Created on 16 June 2021
20. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; What? A quick article on how to debug some errors in Zoho. Why? I wanted a general note to list certain errors that we get when we do certain things in Zoho but didn't want to write a separate ...; Created on 06 February 2020