|
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 V3 API - Get All Released OrdersRetrieves all the orders with line items that are in the "created" status, that is, these orders have been released from the Walmart Order Management System to the seller for processing. The released orders are the orders that are ready for a seller to fulfill. For more information, see https://developer.walmart.com/#/apicenter/marketPlace/latest#getAllReleasedOrders
LOCAL loHttp LOCAL loResp LOCAL loJsonResponse LOCAL lcPurchaseOrderId LOCAL lcCustomerOrderId LOCAL lcCustomerEmailId LOCAL lnOrderDate LOCAL lcShippingInfoPhone LOCAL lnShippingInfoEstimatedDeliveryDate LOCAL lnShippingInfoEstimatedShipDate LOCAL lcShippingInfoMethodCode LOCAL lcShippingInfoPostalAddressName LOCAL lcShippingInfoPostalAddressAddress1 LOCAL lcShippingInfoPostalAddressAddress2 LOCAL lcShippingInfoPostalAddressCity LOCAL lcShippingInfoPostalAddressState LOCAL lcShippingInfoPostalAddressPostalCode LOCAL lcShippingInfoPostalAddressCountry LOCAL lcShippingInfoPostalAddressAddressType LOCAL lcShipNodeType LOCAL j LOCAL lnCount_j LOCAL lcLineNumber LOCAL lcItemProductName LOCAL lcItemSku LOCAL lcOrderLineQuantityUnitOfMeasurement LOCAL lcOrderLineQuantityAmount LOCAL lnStatusDate LOCAL lcRefund LOCAL lcFulfillmentFulfillmentOption LOCAL lcFulfillmentShipMethod LOCAL lcFulfillmentStoreId LOCAL lnFulfillmentPickUpDateTime LOCAL lcFulfillmentPickUpBy LOCAL lcFulfillmentShippingProgramType LOCAL k LOCAL lnCount_k LOCAL lcChargeType LOCAL lcChargeName LOCAL lcChargeAmountCurrency LOCAL lnChargeAmountAmount LOCAL lcTaxTaxName LOCAL lcTaxTaxAmountCurrency LOCAL lcTaxTaxAmountAmount LOCAL lcStatus LOCAL lcStatusQuantityUnitOfMeasurement LOCAL lcStatusQuantityAmount LOCAL lcCancellationReason LOCAL lcTrackingInfo LOCAL lcReturnCenterAddress LOCAL lnListMetaTotalCount LOCAL lnListMetaLimit LOCAL lcListMetaNextCursor LOCAL i LOCAL lnCount_i * This example requires the Chilkat API to have been previously unlocked. * See Global Unlock Sample for sample code. * For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Http') loHttp = CreateObject('Chilkat.Http') loHttp.Accept = "application/json" * Setting the Login and Password properties to the clientId and clientSecret * will cause the Basic Auth header to be added (i.e. BaseEncode64(clientId:clientSecret)) loHttp.Login = "clientId" loHttp.Password = "clientSecret" loHttp.BasicAuth = 1 loHttp.SetRequestHeader("Content-Type","application/json") loHttp.SetRequestHeader("WM_QOS.CORRELATION_ID","b3261d2d-028a-4ef7-8602-633c23200af6") * Use the access token obtained from this example: Walmart v3 API Get OAuth2 Access Token using Client Credentials loHttp.SetRequestHeader("WM_SEC.ACCESS_TOKEN","eyJraWQiOiIzZjVhYTFmNS1hYWE5LTQzM.....") loHttp.SetRequestHeader("WM_SVC.NAME","Walmart Marketplace") loHttp.SetUrlVar("createdStartDate","2020-01-16T10:30:15Z") loHttp.SetUrlVar("limit","200") * Can also be 3PLFulfilled loHttp.SetUrlVar("shippingProgramType","SellerFulfilled") loHttp.SetUrlVar("shipNodeType","TWO_DAY") loResp = loHttp.QuickRequest("GET","/v3/orders/released?createdStartDate={$createdStartDate}&limit={$limit}&shippingProgramType={$shippingProgramType}&shipNodeType={$shipNodeType}") IF (loHttp.LastMethodSuccess <> 1) THEN ? loHttp.LastErrorText RELEASE loHttp CANCEL ENDIF ? "Response Status Code: " + STR(loResp.StatusCode) * For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject') loJsonResponse = CreateObject('Chilkat.JsonObject') loJsonResponse.Load(loResp.BodyStr) loJsonResponse.EmitCompact = 0 ? loJsonResponse.Emit() IF (loResp.StatusCode <> 200) THEN ? "Failed." RELEASE loResp RELEASE loHttp RELEASE loJsonResponse CANCEL ENDIF RELEASE loResp * Sample output... * (See the parsing code below..) * * Use the this online tool to generate parsing code from sample JSON: * Generate Parsing Code from JSON * { * "list": { * "meta": { * "totalCount": 25228, * "limit": 10, * "nextCursor": "?limit=10&hasMoreElements=true&soIndex=25228&poIndex=10&sellerId=152&createdStartDate=2019-04-02T00:00:00.000Z&createdEndDate=2019-09-26T16:05:49.648Z" * }, * "elements": { * "order": [ * { * "purchaseOrderId": "4792701510371", * "customerOrderId": "5401973367419", * "customerEmailId": "47B81ACD2C62434DBE64F47B9E1F7630@relay.walmart.com", * "orderDate": 1569513584000, * "shippingInfo": { * "phone": "2134488377", * "estimatedDeliveryDate": 1569870000000, * "estimatedShipDate": 1569553200000, * "methodCode": "Express", * "postalAddress": { * "name": "Julio Hernandez", * "address1": "9713 pleasant view dr", * "address2": null, * "city": "Rancho Cucamonga", * "state": "CA", * "postalCode": "91701", * "country": "USA", * "addressType": "RESIDENTIAL" * } * }, * "orderLines": { * "orderLine": [ * { * "lineNumber": "1", * "item": { * "productName": "Refurbished Lenovo YB1-X90F Grey Yoga Book with WiFi 10.1\" Touchscreen Tablet Android 6.0.1", * "sku": "VO190403007727R" * }, * "charges": { * "charge": [ * { * "chargeType": "PRODUCT", * "chargeName": "ItemPrice", * "chargeAmount": { * "currency": "USD", * "amount": 259 * }, * "tax": { * "taxName": "Tax1", * "taxAmount": { * "currency": "USD", * "amount": 20.07 * } * } * }, * { * "chargeType": "FEE", * "chargeName": "Fee", * "chargeAmount": { * "currency": "USD", * "amount": 0 * }, * "tax": { * "taxName": "Electronic Waste Recycling Fee", * "taxAmount": { * "currency": "USD", * "amount": 5 * } * } * } * ] * }, * "orderLineQuantity": { * "unitOfMeasurement": "EACH", * "amount": "1" * }, * "statusDate": 1569513724000, * "orderLineStatuses": { * "orderLineStatus": [ * { * "status": "Acknowledged", * "statusQuantity": { * "unitOfMeasurement": "EACH", * "amount": "1" * }, * "cancellationReason": null, * "trackingInfo": null, * "returnCenterAddress": null * } * ] * }, * "refund": null, * "fulfillment": { * "fulfillmentOption": "S2H", * "shipMethod": "EXPEDITED", * "storeId": null, * "pickUpDateTime": 1569870000000, * "pickUpBy": null, * "shippingProgramType": "TWO_DAY" * } * } * ] * }, * "shipNode": { * "type": "3PLFulfilled" * } * } * ] * } * } * } * lnListMetaTotalCount = loJsonResponse.IntOf("list.meta.totalCount") lnListMetaLimit = loJsonResponse.IntOf("list.meta.limit") lcListMetaNextCursor = loJsonResponse.StringOf("list.meta.nextCursor") i = 0 lnCount_i = loJsonResponse.SizeOfArray("list.elements.order") DO WHILE i < lnCount_i loJsonResponse.I = i lcPurchaseOrderId = loJsonResponse.StringOf("list.elements.order[i].purchaseOrderId") lcCustomerOrderId = loJsonResponse.StringOf("list.elements.order[i].customerOrderId") lcCustomerEmailId = loJsonResponse.StringOf("list.elements.order[i].customerEmailId") lnOrderDate = loJsonResponse.IntOf("list.elements.order[i].orderDate") lcShippingInfoPhone = loJsonResponse.StringOf("list.elements.order[i].shippingInfo.phone") lnShippingInfoEstimatedDeliveryDate = loJsonResponse.IntOf("list.elements.order[i].shippingInfo.estimatedDeliveryDate") lnShippingInfoEstimatedShipDate = loJsonResponse.IntOf("list.elements.order[i].shippingInfo.estimatedShipDate") lcShippingInfoMethodCode = loJsonResponse.StringOf("list.elements.order[i].shippingInfo.methodCode") lcShippingInfoPostalAddressName = loJsonResponse.StringOf("list.elements.order[i].shippingInfo.postalAddress.name") lcShippingInfoPostalAddressAddress1 = loJsonResponse.StringOf("list.elements.order[i].shippingInfo.postalAddress.address1") lcShippingInfoPostalAddressAddress2 = loJsonResponse.StringOf("list.elements.order[i].shippingInfo.postalAddress.address2") lcShippingInfoPostalAddressCity = loJsonResponse.StringOf("list.elements.order[i].shippingInfo.postalAddress.city") lcShippingInfoPostalAddressState = loJsonResponse.StringOf("list.elements.order[i].shippingInfo.postalAddress.state") lcShippingInfoPostalAddressPostalCode = loJsonResponse.StringOf("list.elements.order[i].shippingInfo.postalAddress.postalCode") lcShippingInfoPostalAddressCountry = loJsonResponse.StringOf("list.elements.order[i].shippingInfo.postalAddress.country") lcShippingInfoPostalAddressAddressType = loJsonResponse.StringOf("list.elements.order[i].shippingInfo.postalAddress.addressType") lcShipNodeType = loJsonResponse.StringOf("list.elements.order[i].shipNode.type") j = 0 lnCount_j = loJsonResponse.SizeOfArray("list.elements.order[i].orderLines.orderLine") DO WHILE j < lnCount_j loJsonResponse.J = j lcLineNumber = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].lineNumber") lcItemProductName = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].item.productName") lcItemSku = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].item.sku") lcOrderLineQuantityUnitOfMeasurement = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].orderLineQuantity.unitOfMeasurement") lcOrderLineQuantityAmount = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].orderLineQuantity.amount") lnStatusDate = loJsonResponse.IntOf("list.elements.order[i].orderLines.orderLine[j].statusDate") lcRefund = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].refund") lcFulfillmentFulfillmentOption = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].fulfillment.fulfillmentOption") lcFulfillmentShipMethod = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].fulfillment.shipMethod") lcFulfillmentStoreId = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].fulfillment.storeId") lnFulfillmentPickUpDateTime = loJsonResponse.IntOf("list.elements.order[i].orderLines.orderLine[j].fulfillment.pickUpDateTime") lcFulfillmentPickUpBy = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].fulfillment.pickUpBy") lcFulfillmentShippingProgramType = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].fulfillment.shippingProgramType") k = 0 lnCount_k = loJsonResponse.SizeOfArray("list.elements.order[i].orderLines.orderLine[j].charges.charge") DO WHILE k < lnCount_k loJsonResponse.K = k lcChargeType = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].chargeType") lcChargeName = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].chargeName") lcChargeAmountCurrency = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].chargeAmount.currency") lnChargeAmountAmount = loJsonResponse.IntOf("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].chargeAmount.amount") lcTaxTaxName = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].tax.taxName") lcTaxTaxAmountCurrency = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].tax.taxAmount.currency") lcTaxTaxAmountAmount = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].tax.taxAmount.amount") k = k + 1 ENDDO k = 0 lnCount_k = loJsonResponse.SizeOfArray("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus") DO WHILE k < lnCount_k loJsonResponse.K = k lcStatus = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus[k].status") lcStatusQuantityUnitOfMeasurement = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus[k].statusQuantity.unitOfMeasurement") lcStatusQuantityAmount = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus[k].statusQuantity.amount") lcCancellationReason = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus[k].cancellationReason") lcTrackingInfo = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus[k].trackingInfo") lcReturnCenterAddress = loJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus[k].returnCenterAddress") k = k + 1 ENDDO j = j + 1 ENDDO i = i + 1 ENDDO RELEASE loHttp RELEASE loJsonResponse |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.