Search - Joel Lipman .Com

1. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... when Status is "Paid" Just once or every time is "Everytime" Actions is a custom function called "fn_invoice_updatepaymentmethod" But this wouldn't work despite being as per the documentation (see ...; Created on 17 August 2022
2. Zoho Inventory: Mark a package slip as delivered and shipped: / Zoho /; ... + v_ShipmentID + "/status/delivered?organization_id=" + v_BooksOrgID; r_Delivered = invokeurl [ url :v_Url type :POST connection:"jl_inventory" ]; info "Marked as Delivered:"; info ...; Created on 14 July 2022
3. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; ... Mins"); // // the meeting status m_ScheduleMeeting.put("Status","Not Started"); // // send request and create record r_CreateMeeting = zoho.crm.createRecord("Events",m_ScheduleMeeting); // // outpu ...; Created on 02 March 2022
4. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... : 5, "actualQueryCost": 5, "throttleStatus": { "maximumAvailable": 1000, "currentlyAvailable": 995, "restoreRate": 50 } } } } Additional Note th ...; Created on 14 February 2022
5. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... Why? There were several alternatives we considered beforehand which still didn't fit the requirement: A client's first-line agents would have a lead record with the status "New Lead". The client ...; Created on 11 February 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 /; ... Xero webhook. You're going to need to respond to Xero with valid and invalid HTTP statuses as their webhook validation process is a little stricter than Zoho's. Setup a Zoho CRM Function: Login ...; Created on 10 January 2022
8. 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
9. Zoho CRM: Schedule a Call using Deluge: / Zoho /; ... Call with " + v_CustomerName); m_ScheduleCall.put("Call_Start_Time",v_SystemAppointmentDateTimeStart); m_ScheduleCall.put("Call_Status","Scheduled"); m_ScheduleCall.put("Call_Type","Outbound"); // // optiona ...; Created on 18 November 2021
10. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field: / Zoho /; ... "expected_data_type": "datetime", "api_name": "Check_Date_Time" }, "message": "invalid data", "status": "error" } How? We're going to parse the created date and time parts as well as the ...; Created on 11 November 2021
11. 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
12. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... listings / channels m_Product.put("published_scope","global"); m_Product.put("published",true); // set to true when comfortable with it publishing correctly m_Product.put("status",ifnull(input.Publish_Status.toLowerCase(),"draft")); // / ...; Created on 17 October 2021
13. 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
14. 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
15. 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
16. 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
17. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... = zoho.encryption.hmacsha256(v_Webhook_Key,m_Payload.get("body")); } // // compare signatures if(v_WebhookBodyHMACSHA256 == v_ShopifySignature) { v_ResponseCode = 200; } m_Response.put("status_code",v_ResponseCode); // // ...; Created on 15 July 2021
18. 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
19. 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
20. 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