Search - Joel Lipman .Com

1. Zoho Deluge - Compare time and currenttime with timezone: / Zoho /; ... time format - DO NOT USE v_CurrentTime = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss", "Europe/London"); v_ExpiryTime = "2020-03-25T21:41:07+00:00"; v_ExpiryDatePart = v_ExpiryTime.subString(0,10); v_ExpiryTimePart ...; Created on 13 January 2020
2. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... " + zoho.currenttime.toString("yyyy-MM-dd-HH-mm") + ".csv"; f_UploadCsvFile = l_Csv_File.toString(v_NewLineChar).toFile(v_UploadFilename); // // upload the file r_UploadResponse = zoho.workdrive.uploadFile(f_UploadCsvFile,v_WorkdriveFolderID,v_UploadFilename,FALSE,"my_workdrive_connection"); if(!isNull(r_UploadResponse.get("data"))) { // ...; Created on 11 September 2024
3. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... e + "CRM Attachment: " + r_AttachFile.get("message") + " "; } } } } } } } v_DebugMessage = v_DebugMessage + "Date/Time: " + zoho.currenttime; // return "Webhook received"; ...; Created on 06 August 2024
4. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... + zoho.currenttime.toString("yyyy-MM-dd HH:mm","Europe/London")); m_WebhookLog.put("Body",m_Payload.get("body")); m_WebhookLog.put("Event_Type","Inventory Update"); m_WebhookLog.put("Source","Shopify"); m_WebhookLog.put("Data_Format","JSON"); r_WebhookL ...; Created on 22 April 2024
5. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; ... checking if daylight savings is in effect in the UK, we should be able to take Greenwich Mean Time and compare to UTC. b_IsDSTInEffect = if(zoho.currenttime.toString("HH:mm", "UTC") != zoho.currenttime.toString("HH:mm", ...; Created on 03 July 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: 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
8. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... = zoho.currenttime.toString("yyyy-MM-dd ") + m_ShiftBuildUp.get(v_WorkDay).get("open").leftpad(5).replaceAll(" ", "0") + ":00"; v_FinishTime = zoho.currenttime.toString("yyyy-MM-dd ") + m_ShiftBuildUp.get(v_WorkDay).get("close").leftpad(5).replaceAll(" ...; Created on 28 March 2023
9. 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
10. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... evaluate (specify here your dates [time set to midnight]) v_timeFrom = zoho.currenttime.subDay(0).toString("yyyy-MM-dd'T'00:00:00.000'Z'"); v_timeTill = zoho.currenttime.addDay(1).toString("yyyy-MM-dd'T'00:00:00.000'Z'"); // // ...; Created on 28 February 2023
11. 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
12. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... = message.trim(); l_Messages = List(); v_ChatID = ifnull(chat.getJSON("id"),0); // // get conversations from last 10 minutes v_MinutesAgo = 10; v_FromTime = zoho.currenttime.subMinutes(v_MinutesAgo).toLong(); v_TillTime ...; Created on 13 February 2023
13. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... " + zoho.currenttime.toString("HH:mm:ss"); // // loop through our list for this page for each r_Candidate in l_Candidates { v_CountTotal = v_CountTotal + 1; v_CandidateZohoID = ifnull(r_Candidate.get("CANDIDATEID"),0); r_Associate ...; Created on 08 February 2023
14. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; What? This is an article documenting the process of publishing a Zoho Inventory image to eBay's Picture Hosting Services (EPS). Why? Because I couldn't find any other article in the whole world ...; Created on 31 March 2022
15. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; ... e Meeting"); // // the start time m_ScheduleMeeting.put("Start_DateTime",zoho.currenttime.addBusinessDay(1).toString("yyyy-MM-dd'T'HH:mm:ss","America/New_York")); // // the end time m_ScheduleMeeting.put("End_DateTime",zoho.currenttime.addBusinessDay(1).addMinutes(30).toString("yyyy-MM-dd'T'HH:mm:ss","America/New_York")); // ...; Created on 02 March 2022
16. 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
17. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; ... Deluge. How? We're going to make use of the .toLong() function applied to a datetime datatype variable which will return the Unix seconds. // the now time v_NowTime = zoho.currenttime; // // ...; Created on 21 September 2021
18. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... "Access Token Expires at: " + r_Api.Access_Token_Expiry; v_Output = r_Api.Access_Token; // // zoho.currentttime can be server time as this function will check expiry against the server time anyway if(zoho.currenttime ...; Created on 20 September 2021
19. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... like: input.Audit_Change = "Title: " + input.Title; Method #1: (do not use) Previously I have tried adding a field called "DateTime form was loaded" which would have the currenttime when the form ...; Created on 19 September 2021
20. Zoho Deluge: Push a value to a datetime field in CRM: / Zoho /; ... some formatting examples: Creator to CRM: v_CreatorTime = zoho.currenttime.toTime(); v_CrmTime = v_CreatorTime.toString("yyyy-MM-dd'T'HH:mm:ss") + v_CreatorTime.toString("Z").subString(0,3) + ":" ...; Created on 10 September 2021