Search - Joel Lipman .Com

1. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... " + v_AccessToken); // v_TradingAPIVersion = 967; v_Endpoint = "https://api.ebay.com/ws/api.dll"; // // build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); v_ApiCal ...; Created on 27 April 2023
2. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... get access token v_AccessToken = standalone.fn_eBay_GetAccessToken(); // v_TradingAPIVersion = 967; v_Endpoint = "https://api.ebay.com/ws/api.dll"; // // build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); v_ApiCall ...; Created on 29 March 2023
3. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); v_ApiCall = "GetMyeBaySelling"; m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // ...; Created on 01 March 2023
4. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); v_ApiCall = "GetOrders"; m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // ...; Created on 28 February 2023
5. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... n = r_Response.toMap().get("details").get("output"); } } info v_AccessToken; // // build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // ...; Created on 31 March 2022
6. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... = thisapp.API.fn_eBayConnect_AccessToken(); v_TradingAPIVersion = r_Api.API_Version; v_Endpoint = "https://api.ebay.com/ws/api.dll"; // // build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); v_ApiCall ...; Created on 22 January 2022
7. 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
8. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... = thisapp.API.fn_eBayConnect_AccessToken(); v_TradingAPIVersion = r_Api.API_Version; v_Endpoint = "https://api.ebay.com/ws/api.dll"; // // build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); v_ApiCall ...; Created on 13 October 2021
9. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... build header m_Headers = Map(); // siteID 3=UK, 0=US, check API Explorer Test Tool for others m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); m_Headers.put("X-EBAY-API-CALL-NAME",v_APICallName); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // ...; Created on 20 September 2021
10. T-SQL Record Separator: / Transact-SQL /; ... > 0 THEN REPLACE(REPLACE(c.[Phone], ' or ', CHAR(10)), ' ', '') WHEN LEN(c.[Phone]) > 20 THEN REPLACE(REPLACE(c.[Phone], '01202 ', '01202'), ' ', CHAR(10)) ELSE c.[Phone] END AS 'Phone', tt.[SiteId] ...; Created on 11 October 2011
11. SSRS Hide results table if empty: / SQL Server Reporting Services /; ... expression as the one we use to get the equipment information: SELECT DISTINCT re.[RoomId] ,re.[SiteId] ,re.[EquipId] ,eq.[Description] FROM [ROOMEQUIPMENT] re INNER ...; Created on 29 March 2011
12. Room Availability Calendar in Business Intelligence Development Studio: / SQL Server Reporting Services /; ... sd.[SetId] = @setId AND dateadd(d, tt.[WeekDay] - 1, @baseDate) = @GivenDate AND wm.[WeekNumber] = @weekNumber AND tt.[SiteId] = @siteId AND upper(sd.[Descrip]) not like 'ADDITIONAL TIMETABLE%' ...; Created on 23 March 2011
13. Parameters not being used in report processing: / SQL Server Reporting Services /; ... varchar(10), @weekNumber int, @siteId nvarchar(5), @baseDate datetime, @specifiedDate datetime, @specifiedCampus varchar(25) SET DATEFORMAT dmy --SET @GivenDate = '1/7/2011' --SET ...; Created on 07 January 2011