Search - Joel Lipman .Com

1. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // // send the request XML as a string r_ResponseXMLOrder ...; Created on 27 April 2023
2. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // //info "Request Sent ...; Created on 29 March 2023
3. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // info "Request Sent t ...; Created on 01 March 2023
4. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // // send the request XM ...; Created on 28 February 2023
5. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... ":}]} I only resolved this by not using "endCursor" in my GraphQL and instead looped through the nodes to get the last cursor. Not sure if this meant any data was missing. Perhaps by forcing the sort cr ...; Created on 20 February 2023
6. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); info x_Params; // // s ...; Created on 31 March 2022
7. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // // send the ...; Created on 22 January 2022
8. 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
9. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // // send the ...; Created on 13 October 2021
10. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... / convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // // send t ...; Created on 20 September 2021
11. T-SQL: Parse an XML value: / Transact-SQL /; ... brackets and append a [1] as per the above example. Retrieving nodes -- to get all below nodes from root node - STAFF SELECT Event_XML.query('/STAFF') FROM [dbo].[XML_EVENTS] -- to get ...; Created on 27 March 2014
12. Stored Procedure to List Distinct Values and Counts: / Transact-SQL /; ... @myXml = CONVERT(xml,'' + REPLACE(@p_SearchColumns,',','') + ''); DECLARE Cursor1 CURSOR FOR SELECT [Value] = T.c.value('.','varchar(max)') FROM @myXml.nodes('/root/s') T(c); ...; Created on 26 October 2012
13. Convert a delimited string to table: / Databases /; What? This is a quick note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- ...; Created on 26 October 2012