|
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
(Visual FoxPro) Walmart - Get List of OrdersDemonstrates how to get a list of all orders.
LOCAL loSbUrl LOCAL lnSuccess LOCAL lnNumReplaced LOCAL loDtStartDate LOCAL lcRequestMethod LOCAL loAuthUtil LOCAL lcWmConsumerId LOCAL lcWmPrivateKey LOCAL lcJsonStr LOCAL loJson LOCAL loHttp LOCAL lcXmlStr LOCAL loXml LOCAL i LOCAL lnNumOrders LOCAL loOrder LOCAL j LOCAL lnNumOrderLines LOCAL loOrderLine LOCAL k LOCAL lnNumOrderLineStatuses * --------------------------------------------------------------------------------------------------------- * 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') loSbUrl = CreateObject('Chilkat.StringBuilder') lnSuccess = loSbUrl.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.. lnNumReplaced = loSbUrl.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') loDtStartDate = CreateObject('Chilkat.CkDateTime') loDtStartDate.SetFromCurrentSystemTime() loDtStartDate.AddDays(-7) ? "One week ago (GMT): " + loDtStartDate.GetAsTimestamp(0) lnNumReplaced = loSbUrl.Replace("{createdStartDate}",loDtStartDate.GetAsTimestamp(0)) lcRequestMethod = "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') loAuthUtil = CreateObject('Chilkat.AuthUtil') lcWmConsumerId = "WALMART_CONSUMER_ID" lcWmPrivateKey = "WALMART_PRIVATE_KEY" lcJsonStr = loAuthUtil.WalmartSignature(loSbUrl.GetAsString(),lcWmConsumerId,lcWmPrivateKey,lcRequestMethod) IF (loAuthUtil.LastMethodSuccess <> 1) THEN ? loAuthUtil.LastErrorText RELEASE loSbUrl RELEASE loDtStartDate RELEASE loAuthUtil CANCEL ENDIF * 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') loJson = CreateObject('Chilkat.JsonObject') loJson.Load(lcJsonStr) * For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Http') loHttp = CreateObject('Chilkat.Http') loHttp.SetRequestHeader("WM_SVC.NAME","Walmart Marketplace") loHttp.SetRequestHeader("WM_QOS.CORRELATION_ID",loJson.StringOf("correlation_id")) loHttp.SetRequestHeader("WM_SEC.TIMESTAMP",loJson.StringOf("timestamp")) loHttp.SetRequestHeader("WM_SEC.AUTH_SIGNATURE",loJson.StringOf("signature")) loHttp.SetRequestHeader("WM_CONSUMER.ID",lcWmConsumerId) * 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". loHttp.SetRequestHeader("WM_CONSUMER.CHANNEL.TYPE","WALMART_CHANNEL_TYPE") loHttp.Accept = "application/xml" * Note: Do not explicitly set the "Host" header. Chilkat will set it automatically. lcXmlStr = loHttp.QuickGetStr(loSbUrl.GetAsString()) IF (loHttp.LastMethodSuccess <> 1) THEN ? loHttp.LastErrorText RELEASE loSbUrl RELEASE loDtStartDate RELEASE loAuthUtil RELEASE loJson RELEASE loHttp CANCEL ENDIF * For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Xml') loXml = CreateObject('Chilkat.Xml') loXml.LoadXml(lcXmlStr) * A successful response should have a 200 response status IF (loHttp.LastStatus <> 200) THEN ? loXml.GetXml() ? "Response Status Code: " + STR(loHttp.LastStatus) ? "Failed." RELEASE loSbUrl RELEASE loDtStartDate RELEASE loAuthUtil RELEASE loJson RELEASE loHttp RELEASE loXml CANCEL ENDIF * A sample XML response is shown below.. * Let's grab some information, and iterate over the XML.. ? "Total number of orders in last 7 days: " + STR(loXml.GetChildIntValue("ns3:meta|ns3:totalCount")) * 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 lnNumOrders = loXml.NumChildrenAt("ns3:elements") DO WHILE i < lnNumOrders loXml.I = i ? "---- order " + STR(i + 1) + " ----" loOrder = loXml.GetChildWithTag("ns3:elements|ns3:order[i]") ? "purchaseOrderId: " + loOrder.GetChildContent("ns3:purchaseOrderId") ? "name: " + loOrder.GetChildContent("ns3:shippingInfo|ns3:postalAddress|ns3:name") j = 0 lnNumOrderLines = loOrder.NumChildrenAt("ns3:orderLines") DO WHILE j < lnNumOrderLines loOrder.J = j loOrderLine = loOrder.GetChildWithTag("ns3:orderLines|ns3:orderLine[j]") ? " productName: " + loOrderLine.GetChildContent("ns3:item|ns3:productName") k = 0 lnNumOrderLineStatuses = loOrderLine.NumChildrenAt("ns3:orderLineStatuses") DO WHILE k < lnNumOrderLineStatuses loOrderLine.K = k ? " order line status: " + loOrderLine.GetChildContent("ns3:orderLineStatuses|ns3:orderLineStatus[k]|ns3:status") ? " order line carrier: " + loOrderLine.GetChildContent("ns3:orderLineStatuses|ns3:orderLineStatus[k]|ns3:trackingInfo|ns3:carrierName|ns3:carrier") k = k + 1 ENDDO RELEASE loOrderLine j = j + 1 ENDDO RELEASE loOrder i = i + 1 ENDDO ? "Success." * --------------------------------------- * 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> RELEASE loSbUrl RELEASE loDtStartDate RELEASE loAuthUtil RELEASE loJson RELEASE loHttp RELEASE loXml |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.