Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(Classic ASP) Walmart - Get List of OrdersDemonstrates how to get a list of all orders.
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> </head> <body> <% ' --------------------------------------------------------------------------------------------------------- ' Note: This example is deprecated. The Walmart API no longer uses the Signature method of authenticating. ' Walmart now uses OAuth2. ' --------------------------------------------------------------------------------------------------------- ' This example requires the Chilkat API to have been previously unlocked. ' See Global Unlock Sample for sample code. ' Demonstrates how to get a list of Walmart orders and parse the XML result. ' --- ' Note: The Walmart documentation indicates that the createdStartDate/createdEndDate query parameters are optional, ' however, this may not actually be the case. It may be that at least one is required for getting a list of orders. ' --- ' The general format to get orders is as follows: ' GET https://marketplace.walmartapis.com/v3/orders?sku={sku}&customerOrderId={customerOrderId}&purchaseOrderId={purchaseOrderId}&status={status}&createdStartDate={createdStartDate}&createdEndDate={createdEndDate}&fromExpectedShipDate={fromExpectedShipDate}&toExpectedShipDate={toExpectedShipDate}&limit={limit} ' Let's build a request to get all the orders in the last 7 days. ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder") set sbUrl = Server.CreateObject("Chilkat.StringBuilder") success = sbUrl.Append("https://marketplace.walmartapis.com/v3/orders?createdStartDate={createdStartDate}&limit={limit}") ' We'll just get 2 results so we can demonstrate iterating over the XML.. numReplaced = sbUrl.ReplaceI("{limit}",2) ' Get the current system date/time and add -7 days to get 1 week ago. ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.CkDateTime") set dtStartDate = Server.CreateObject("Chilkat.CkDateTime") success = dtStartDate.SetFromCurrentSystemTime() success = dtStartDate.AddDays(-7) Response.Write "<pre>" & Server.HTMLEncode( "One week ago (GMT): " & dtStartDate.GetAsTimestamp(0)) & "</pre>" numReplaced = sbUrl.Replace("{createdStartDate}",dtStartDate.GetAsTimestamp(0)) requestMethod = "GET" ' First we need to generate a signature for our request. ' The signature needs to be re-generated for each new Walmart HTTP request. ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.AuthUtil") set authUtil = Server.CreateObject("Chilkat.AuthUtil") wmConsumerId = "WALMART_CONSUMER_ID" wmPrivateKey = "WALMART_PRIVATE_KEY" jsonStr = authUtil.WalmartSignature(sbUrl.GetAsString(),wmConsumerId,wmPrivateKey,requestMethod) If (authUtil.LastMethodSuccess <> 1) Then Response.Write "<pre>" & Server.HTMLEncode( authUtil.LastErrorText) & "</pre>" Response.End End If ' The JSON returned by WalmartSignature contains the values to be used in the following ' header fields: WM_SEC.AUTH_SIGNATURE, WM_SEC.TIMESTAMP, and WM_QOS.CORRELATION_ID ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject") set json = Server.CreateObject("Chilkat.JsonObject") success = json.Load(jsonStr) ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http") set http = Server.CreateObject("Chilkat.Http") http.SetRequestHeader "WM_SVC.NAME","Walmart Marketplace" http.SetRequestHeader "WM_QOS.CORRELATION_ID",json.StringOf("correlation_id") http.SetRequestHeader "WM_SEC.TIMESTAMP",json.StringOf("timestamp") http.SetRequestHeader "WM_SEC.AUTH_SIGNATURE",json.StringOf("signature") http.SetRequestHeader "WM_CONSUMER.ID",wmConsumerId ' Note: check to see what keyword you should use for your situation. ' The keyword "WALMART_CHANNEL_TYPE" is one option. Another is "SWAGGER_CHANNEL_TYPE". http.SetRequestHeader "WM_CONSUMER.CHANNEL.TYPE","WALMART_CHANNEL_TYPE" http.Accept = "application/xml" ' Note: Do not explicitly set the "Host" header. Chilkat will set it automatically. xmlStr = http.QuickGetStr(sbUrl.GetAsString()) If (http.LastMethodSuccess <> 1) Then Response.Write "<pre>" & Server.HTMLEncode( http.LastErrorText) & "</pre>" Response.End End If ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Xml") set xml = Server.CreateObject("Chilkat.Xml") success = xml.LoadXml(xmlStr) ' A successful response should have a 200 response status If (http.LastStatus <> 200) Then Response.Write "<pre>" & Server.HTMLEncode( xml.GetXml()) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "Response Status Code: " & http.LastStatus) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "Failed.") & "</pre>" Response.End End If ' A sample XML response is shown below.. ' Let's grab some information, and iterate over the XML.. Response.Write "<pre>" & Server.HTMLEncode( "Total number of orders in last 7 days: " & xml.GetChildIntValue("ns3:meta|ns3:totalCount")) & "</pre>" ' The outermost loop loops over the orders. ' The next inner loop loops over the order lines. ' The innermost loop loops over the order line statuses. i = 0 numOrders = xml.NumChildrenAt("ns3:elements") Do While i < numOrders xml.I = i Response.Write "<pre>" & Server.HTMLEncode( "---- order " & i + 1 & " ----") & "</pre>" ' order is a Chilkat.Xml Set order = xml.GetChildWithTag("ns3:elements|ns3:order[i]") Response.Write "<pre>" & Server.HTMLEncode( "purchaseOrderId: " & order.GetChildContent("ns3:purchaseOrderId")) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "name: " & order.GetChildContent("ns3:shippingInfo|ns3:postalAddress|ns3:name")) & "</pre>" j = 0 numOrderLines = order.NumChildrenAt("ns3:orderLines") Do While j < numOrderLines order.J = j ' orderLine is a Chilkat.Xml Set orderLine = order.GetChildWithTag("ns3:orderLines|ns3:orderLine[j]") Response.Write "<pre>" & Server.HTMLEncode( " productName: " & orderLine.GetChildContent("ns3:item|ns3:productName")) & "</pre>" k = 0 numOrderLineStatuses = orderLine.NumChildrenAt("ns3:orderLineStatuses") Do While k < numOrderLineStatuses orderLine.K = k Response.Write "<pre>" & Server.HTMLEncode( " order line status: " & orderLine.GetChildContent("ns3:orderLineStatuses|ns3:orderLineStatus[k]|ns3:status")) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( " order line carrier: " & orderLine.GetChildContent("ns3:orderLineStatuses|ns3:orderLineStatus[k]|ns3:trackingInfo|ns3:carrierName|ns3:carrier")) & "</pre>" k = k + 1 Loop j = j + 1 Loop i = i + 1 Loop Response.Write "<pre>" & Server.HTMLEncode( "Success.") & "</pre>" ' --------------------------------------- ' Sample XML response ' (The confidential information has been redacted or modified with fake data. ' --------------------------------------- ' <?xml version="1.0" encoding="UTF-8" standalone="yes" ?> ' <ns3:list xmlns:ns2="http://walmart.com/mp/orders" xmlns:ns3="http://walmart.com/mp/v3/orders" xmlns:ns4="http://walmart.com/"> ' <ns3:meta> ' <ns3:totalCount>239</ns3:totalCount> ' <ns3:limit>2</ns3:limit> ' <ns3:nextCursor>?limit=2&hasMoreElements=true&soIndex=239&poIndex=1578652999055&partnerId=10000999999&sellerId=9999&createdStartDate=2017-04-21T19:08:55Z&createdEndDate=2017-04-28T19:08:58.464Z</ns3:nextCursor> ' </ns3:meta> ' <ns3:elements> ' <ns3:order> ' <ns3:purchaseOrderId>1111641944111</ns3:purchaseOrderId> ' <ns3:customerOrderId>1111777852111</ns3:customerOrderId> ' <ns3:customerEmailId>somebody@somewhere.com</ns3:customerEmailId> ' <ns3:orderDate>2017-04-21T01:25:52.000Z</ns3:orderDate> ' <ns3:shippingInfo> ' <ns3:phone>3175555555</ns3:phone> ' <ns3:estimatedDeliveryDate>2017-05-10T06:00:00.000Z</ns3:estimatedDeliveryDate> ' <ns3:estimatedShipDate>2017-04-29T06:00:00.000Z</ns3:estimatedShipDate> ' <ns3:methodCode>Value</ns3:methodCode> ' <ns3:postalAddress> ' <ns3:name>barry redacted</ns3:name> ' <ns3:address1>9999 redacted dr</ns3:address1> ' <ns3:city>Indianapolis</ns3:city> ' <ns3:state>IN</ns3:state> ' <ns3:postalCode>46227</ns3:postalCode> ' <ns3:country>USA</ns3:country> ' <ns3:addressType>RESIDENTIAL</ns3:addressType> ' </ns3:postalAddress> ' </ns3:shippingInfo> ' <ns3:orderLines> ' <ns3:orderLine> ' <ns3:lineNumber>1</ns3:lineNumber> ' <ns3:item> ' <ns3:productName>DPX DPx HEST 2.0 Mil-Spec Fixed Blade G10 Multi-Colored</ns3:productName> ' <ns3:sku>DPXG~DPHSX008~00317</ns3:sku> ' </ns3:item> ' <ns3:charges> ' <ns3:charge> ' <ns3:chargeType>PRODUCT</ns3:chargeType> ' <ns3:chargeName>ItemPrice</ns3:chargeName> ' <ns3:chargeAmount> ' <ns3:currency>USD</ns3:currency> ' <ns3:amount>125.00</ns3:amount> ' </ns3:chargeAmount> ' </ns3:charge> ' </ns3:charges> ' <ns3:orderLineQuantity> ' <ns3:unitOfMeasurement>EACH</ns3:unitOfMeasurement> ' <ns3:amount>1</ns3:amount> ' </ns3:orderLineQuantity> ' <ns3:statusDate>2017-04-28T18:09:26.000Z</ns3:statusDate> ' <ns3:orderLineStatuses> ' <ns3:orderLineStatus> ' <ns3:status>Shipped</ns3:status> ' <ns3:statusQuantity> ' <ns3:unitOfMeasurement>EACH</ns3:unitOfMeasurement> ' <ns3:amount>1</ns3:amount> ' </ns3:statusQuantity> ' <ns3:trackingInfo> ' <ns3:shipDateTime>2017-04-24T20:57:52.000Z</ns3:shipDateTime> ' <ns3:carrierName> ' <ns3:carrier>USPS</ns3:carrier> ' </ns3:carrierName> ' <ns3:methodCode>Value</ns3:methodCode> ' <ns3:trackingNumber>redacted</ns3:trackingNumber> ' <ns3:trackingURL>http://walmart.narvar.com/walmart/tracking/usps?redacted</ns3:trackingURL> ' </ns3:trackingInfo> ' </ns3:orderLineStatus> ' </ns3:orderLineStatuses> ' </ns3:orderLine> ' </ns3:orderLines> ' </ns3:order> ' <ns3:order> ' <ns3:purchaseOrderId>1111652066111</ns3:purchaseOrderId> ' <ns3:customerOrderId>1111778837111</ns3:customerOrderId> ' <ns3:customerEmailId>somebody2@somewhere.com</ns3:customerEmailId> ' <ns3:orderDate>2017-04-22T13:37:12.000Z</ns3:orderDate> ' <ns3:shippingInfo> ' <ns3:phone>8435555555</ns3:phone> ' <ns3:estimatedDeliveryDate>2017-05-11T06:00:00.000Z</ns3:estimatedDeliveryDate> ' <ns3:estimatedShipDate>2017-05-02T06:00:00.000Z</ns3:estimatedShipDate> ' <ns3:methodCode>Value</ns3:methodCode> ' <ns3:postalAddress> ' <ns3:name>Doug Redacted</ns3:name> ' <ns3:address1>1111 redacted dr</ns3:address1> ' <ns3:city>Columbia</ns3:city> ' <ns3:state>SC</ns3:state> ' <ns3:postalCode>29527</ns3:postalCode> ' <ns3:country>USA</ns3:country> ' <ns3:addressType>RESIDENTIAL</ns3:addressType> ' </ns3:postalAddress> ' </ns3:shippingInfo> ' <ns3:orderLines> ' <ns3:orderLine> ' <ns3:lineNumber>1</ns3:lineNumber> ' <ns3:item> ' <ns3:productName>Rayovac Specialty Battery 123A 2PK, RL123A-2D</ns3:productName> ' <ns3:sku>RAYO~RL123A-2A~46270</ns3:sku> ' </ns3:item> ' <ns3:charges> ' <ns3:charge> ' <ns3:chargeType>PRODUCT</ns3:chargeType> ' <ns3:chargeName>ItemPrice</ns3:chargeName> ' <ns3:chargeAmount> ' <ns3:currency>USD</ns3:currency> ' <ns3:amount>12.92</ns3:amount> ' </ns3:chargeAmount> ' </ns3:charge> ' </ns3:charges> ' <ns3:orderLineQuantity> ' <ns3:unitOfMeasurement>EACH</ns3:unitOfMeasurement> ' <ns3:amount>1</ns3:amount> ' </ns3:orderLineQuantity> ' <ns3:statusDate>2017-04-28T17:18:51.000Z</ns3:statusDate> ' <ns3:orderLineStatuses> ' <ns3:orderLineStatus> ' <ns3:status>Shipped</ns3:status> ' <ns3:statusQuantity> ' <ns3:unitOfMeasurement>EACH</ns3:unitOfMeasurement> ' <ns3:amount>1</ns3:amount> ' </ns3:statusQuantity> ' <ns3:trackingInfo> ' <ns3:shipDateTime>2017-04-28T16:50:53.000Z</ns3:shipDateTime> ' <ns3:carrierName> ' <ns3:carrier>USPS</ns3:carrier> ' </ns3:carrierName> ' <ns3:methodCode>Value</ns3:methodCode> ' <ns3:trackingNumber>redacted</ns3:trackingNumber> ' <ns3:trackingURL>http://walmart.narvar.com/walmart/tracking/usps?redacted</ns3:trackingURL> ' </ns3:trackingInfo> ' </ns3:orderLineStatus> ' </ns3:orderLineStatuses> ' </ns3:orderLine> ' <ns3:orderLine> ' <ns3:lineNumber>2</ns3:lineNumber> ' <ns3:item> ' <ns3:productName>Rayovac Specialty Battery 123A 2PK, RL123A-2D</ns3:productName> ' <ns3:sku>RAYO~RL123A-2A~46270</ns3:sku> ' </ns3:item> ' <ns3:charges> ' <ns3:charge> ' <ns3:chargeType>PRODUCT</ns3:chargeType> ' <ns3:chargeName>ItemPrice</ns3:chargeName> ' <ns3:chargeAmount> ' <ns3:currency>USD</ns3:currency> ' <ns3:amount>12.92</ns3:amount> ' </ns3:chargeAmount> ' </ns3:charge> ' </ns3:charges> ' <ns3:orderLineQuantity> ' <ns3:unitOfMeasurement>EACH</ns3:unitOfMeasurement> ' <ns3:amount>1</ns3:amount> ' </ns3:orderLineQuantity> ' <ns3:statusDate>2017-04-28T17:18:51.000Z</ns3:statusDate> ' <ns3:orderLineStatuses> ' <ns3:orderLineStatus> ' <ns3:status>Shipped</ns3:status> ' <ns3:statusQuantity> ' <ns3:unitOfMeasurement>EACH</ns3:unitOfMeasurement> ' <ns3:amount>1</ns3:amount> ' </ns3:statusQuantity> ' <ns3:trackingInfo> ' <ns3:shipDateTime>2017-04-28T16:50:53.000Z</ns3:shipDateTime> ' <ns3:carrierName> ' <ns3:carrier>USPS</ns3:carrier> ' </ns3:carrierName> ' <ns3:methodCode>Value</ns3:methodCode> ' <ns3:trackingNumber>redacted</ns3:trackingNumber> ' <ns3:trackingURL>http://walmart.narvar.com/walmart/tracking/usps?redacted</ns3:trackingURL> ' </ns3:trackingInfo> ' </ns3:orderLineStatus> ' </ns3:orderLineStatuses> ' </ns3:orderLine> ' </ns3:orderLines> ' </ns3:order> ' </ns3:elements> ' </ns3:list> %> </body> </html> |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.