Search - Joel Lipman .Com

1. CharIndex Reverse - find occurrence starting from end of string in TSQL: / Transact-SQL /; ... CHARINDEX(@Delimiter, REVERSE( @Haystack )) -- yields "8" SELECT SUBSTRING(@Haystack, CHARINDEX(@Delimiter, REVERSE(@Haystack)), LEN(@Haystack)) -- yields ".String2.String3.String4" Not quite ...; Created on 28 January 2013
2. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... that shipment is not created. More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading - GetMyeBaySelling ...; Created on 27 April 2023
3. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... 21917182) - Modified to check that there are some orders. More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading ...; Created on 29 March 2023
4. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... a list based on the number of days ago (list of dates to check) l_GeneratedList = leftpad(" ",v_DaysAgo).replaceAll(" ",",").toList(); // // loop through for each index v_Index in l_GeneratedList { // ...; Created on 21 March 2023
5. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... Created: 2023-03-01 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading ...; Created on 01 March 2023
6. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading - GetMyeBaySelling Documentation: https://developer.ebay.com/devzone/xml/docs/reference/ebay/getmyebayselling.html - ...; Created on 28 February 2023
7. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... list of pages to loop through (note: issues with multiple pages, do 1 at a time) l_Pages = ; v_PerPage = 200; for each v_Page in l_Pages { v_CountTotal = 0; v_CountProcessed = 0; v_FromIndex ...; Created on 08 February 2023
8. ZohoCRM: Import Attachments: / Zoho /; ... := v_FilesTotal + 1 RowNumber := A_Index ;get first selected row RowChecked := LV_GetNext(RowNumber - 1 , "Checked" ) If ( RowNumber = RowChecked ) { v_FilesCopied := v_FilesCopied ...; Created on 16 January 2023
9. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... // other fields to fill in for this subform row v_RateCardDisp = v_RateCard.indexOf(" (")>0 ? v_RateCard.substring(0, v_RateCard.indexOf(" (")) : v_RateCard; json_Arg.Rate_Change_Notes = v_RateCardDisp; ...; Created on 09 December 2022
10. Zoho Deluge: Generate a loop or list of any size: / Zoho /; ... my list to populate l_CheckDates = List(); // // loop through generated list and add dates for each index v_Index in l_GeneratedList { if(v_Index>0) { l_CheckDates.add(zoho.currentdate.addDay(v_Index).toString("yyyy-MM-dd")); } } ...; Created on 21 October 2022
11. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... = v_FileDetected.indexOf("_"); v_FilenameDetected = v_FileDetected.subString(v_SubstringStart + 1); v_FilenameFormatted = v_FilenameDetected.replaceAll("_"," "); row.Document_Name=v_FilenameFormatted; } } ...; Created on 11 March 2022
12. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... field clear Calendar_Day_Select; input.Calendar_Day_Select:ui.add("<"); for each index v_DateIndex in { input.Calendar_Day_Select:ui.add(zoho.currentdate.addDay(v_DateIndex).toString("EEEE") + ...; Created on 09 March 2022
13. Zoho Deluge: a HTML Entity Decoder: / Zoho /; ... build a map m_HtmlEntity = Map(); for each index v_EntityIndex in l_HtmlEntityNames { m_HtmlEntity.put("&" + l_HtmlEntityNames.get(v_EntityIndex) + ";", l_HtmlEntityChars.get(v_EntityIndex)); } // // ...; Created on 27 January 2022
14. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading - GetItemTransactions Documentation: https://developer.ebay.com/devzone/xml/docs/Reference/eBay/GetItemTransactions.html ...; Created on 22 January 2022
15. 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
16. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; ... and end dates for each v_DayIndex in { v_CheckDateStart = v_FirstMonthDate.addDay(v_DayIndex); if(v_CheckDateStart.toString("E")=="Sun") { v_DST_StartTime = v_CheckDateStart; ...; Created on 07 December 2021
17. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... add (check if it is a working day) v_NextWorkingDay = v_GivenDate; // // loop through each day to set an appointment for for each index v_Loop in l_NumberOfDays { // skip if Sunday (add 1 day) if(v_NextWorkingDay.getDayOfWeek()==1) { v_NextWorkingDay ...; Created on 02 November 2021
18. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... 1,000.00): l_TemplateQuotedItems = List(); v_Index = 1; if(!isnull(r_LineItems.get("data"))) { l_LineItems = r_LineItems.get("data").get(0).get("Quoted_Items"); for each r_LineItem in l_LineItems ...; Created on 21 October 2021
19. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... != 0) { // do photos if(input.Photos_Changed) { v_PositionIndex = 1; for each v_ShopifyImageSrc in l_ShopifyPictures { if(v_ShopifyImageSrc!="") { thisapp.API.fn_ShopifyQuery_UploadPhoto(v_ShopifyProductID, ...; Created on 17 October 2021
20. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading - GetMyeBaySelling Documentation: https://developer.ebay.com/devzone/xml/docs/reference/ebay/getmyebayselling.html ...; Created on 13 October 2021