|
Chilkat • HOME • Android™ • AutoIt • C • C# • C++ • Chilkat2-Python • CkPython • Classic ASP • DataFlex • Delphi DLL • Go • Java • Node.js • Objective-C • PHP Extension • Perl • PowerBuilder • PowerShell • PureBasic • Ruby • SQL Server • Swift • Tcl • Unicode C • Unicode C++ • VB.NET • VBScript • Visual Basic 6.0 • Visual FoxPro • Xojo Plugin
(PowerBuilder) Walmart - Get List of OrdersDemonstrates how to get a list of all orders.
integer li_rc oleobject loo_SbUrl integer li_Success integer li_NumReplaced oleobject loo_DtStartDate string ls_RequestMethod oleobject loo_AuthUtil string ls_WmConsumerId string ls_WmPrivateKey string ls_JsonStr oleobject loo_Json oleobject loo_Http string ls_XmlStr oleobject loo_Xml integer i integer li_NumOrders oleobject loo_Order integer j integer li_NumOrderLines oleobject loo_OrderLine integer k integer li_NumOrderLineStatuses // --------------------------------------------------------------------------------------------------------- // 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. loo_SbUrl = create oleobject // Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0 li_rc = loo_SbUrl.ConnectToNewObject("Chilkat.StringBuilder") if li_rc < 0 then destroy loo_SbUrl MessageBox("Error","Connecting to COM object failed") return end if li_Success = loo_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.. li_NumReplaced = loo_SbUrl.ReplaceI("{limit}",2) // Get the current system date/time and add -7 days to get 1 week ago. loo_DtStartDate = create oleobject // Use "Chilkat_9_5_0.CkDateTime" for versions of Chilkat < 10.0.0 li_rc = loo_DtStartDate.ConnectToNewObject("Chilkat.CkDateTime") loo_DtStartDate.SetFromCurrentSystemTime() loo_DtStartDate.AddDays(-7) Write-Debug "One week ago (GMT): " + loo_DtStartDate.GetAsTimestamp(0) li_NumReplaced = loo_SbUrl.Replace("{createdStartDate}",loo_DtStartDate.GetAsTimestamp(0)) ls_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. loo_AuthUtil = create oleobject // Use "Chilkat_9_5_0.AuthUtil" for versions of Chilkat < 10.0.0 li_rc = loo_AuthUtil.ConnectToNewObject("Chilkat.AuthUtil") ls_WmConsumerId = "WALMART_CONSUMER_ID" ls_WmPrivateKey = "WALMART_PRIVATE_KEY" ls_JsonStr = loo_AuthUtil.WalmartSignature(loo_SbUrl.GetAsString(),ls_WmConsumerId,ls_WmPrivateKey,ls_RequestMethod) if loo_AuthUtil.LastMethodSuccess <> 1 then Write-Debug loo_AuthUtil.LastErrorText destroy loo_SbUrl destroy loo_DtStartDate destroy loo_AuthUtil return 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 loo_Json = create oleobject // Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0 li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject") loo_Json.Load(ls_JsonStr) loo_Http = create oleobject // Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0 li_rc = loo_Http.ConnectToNewObject("Chilkat.Http") loo_Http.SetRequestHeader("WM_SVC.NAME","Walmart Marketplace") loo_Http.SetRequestHeader("WM_QOS.CORRELATION_ID",loo_Json.StringOf("correlation_id")) loo_Http.SetRequestHeader("WM_SEC.TIMESTAMP",loo_Json.StringOf("timestamp")) loo_Http.SetRequestHeader("WM_SEC.AUTH_SIGNATURE",loo_Json.StringOf("signature")) loo_Http.SetRequestHeader("WM_CONSUMER.ID",ls_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". loo_Http.SetRequestHeader("WM_CONSUMER.CHANNEL.TYPE","WALMART_CHANNEL_TYPE") loo_Http.Accept = "application/xml" // Note: Do not explicitly set the "Host" header. Chilkat will set it automatically. ls_XmlStr = loo_Http.QuickGetStr(loo_SbUrl.GetAsString()) if loo_Http.LastMethodSuccess <> 1 then Write-Debug loo_Http.LastErrorText destroy loo_SbUrl destroy loo_DtStartDate destroy loo_AuthUtil destroy loo_Json destroy loo_Http return end if loo_Xml = create oleobject // Use "Chilkat_9_5_0.Xml" for versions of Chilkat < 10.0.0 li_rc = loo_Xml.ConnectToNewObject("Chilkat.Xml") loo_Xml.LoadXml(ls_XmlStr) // A successful response should have a 200 response status if loo_Http.LastStatus <> 200 then Write-Debug loo_Xml.GetXml() Write-Debug "Response Status Code: " + string(loo_Http.LastStatus) Write-Debug "Failed." destroy loo_SbUrl destroy loo_DtStartDate destroy loo_AuthUtil destroy loo_Json destroy loo_Http destroy loo_Xml return end if // A sample XML response is shown below.. // Let's grab some information, and iterate over the XML.. Write-Debug "Total number of orders in last 7 days: " + string(loo_Xml.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 li_NumOrders = loo_Xml.NumChildrenAt("ns3:elements") do while i < li_NumOrders loo_Xml.I = i Write-Debug "---- order " + string(i + 1) + " ----" loo_Order = loo_Xml.GetChildWithTag("ns3:elements|ns3:order[i]") Write-Debug "purchaseOrderId: " + loo_Order.GetChildContent("ns3:purchaseOrderId") Write-Debug "name: " + loo_Order.GetChildContent("ns3:shippingInfo|ns3:postalAddress|ns3:name") j = 0 li_NumOrderLines = loo_Order.NumChildrenAt("ns3:orderLines") do while j < li_NumOrderLines loo_Order.J = j loo_OrderLine = loo_Order.GetChildWithTag("ns3:orderLines|ns3:orderLine[j]") Write-Debug " productName: " + loo_OrderLine.GetChildContent("ns3:item|ns3:productName") k = 0 li_NumOrderLineStatuses = loo_OrderLine.NumChildrenAt("ns3:orderLineStatuses") do while k < li_NumOrderLineStatuses loo_OrderLine.K = k Write-Debug " order line status: " + loo_OrderLine.GetChildContent("ns3:orderLineStatuses|ns3:orderLineStatus[k]|ns3:status") Write-Debug " order line carrier: " + loo_OrderLine.GetChildContent("ns3:orderLineStatuses|ns3:orderLineStatus[k]|ns3:trackingInfo|ns3:carrierName|ns3:carrier") k = k + 1 loop destroy loo_OrderLine j = j + 1 loop destroy loo_Order i = i + 1 loop Write-Debug "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> destroy loo_SbUrl destroy loo_DtStartDate destroy loo_AuthUtil destroy loo_Json destroy loo_Http destroy loo_Xml |
||||
© 2000-2025 Chilkat Software, Inc. All Rights Reserved.