Visual FoxPro
Visual FoxPro
Walmart V3 API - Get All Released Orders
See more Walmart v3 Examples
Retrieves 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.Chilkat Visual FoxPro Downloads
LOCAL lnSuccess
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
lnSuccess = 0
* This example requires the Chilkat API to have been previously unlocked.
* See Global Unlock Sample for sample code.
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 = CreateObject('Chilkat.HttpResponse')
lnSuccess = loHttp.HttpNoBody("GET","/v3/orders/released?createdStartDate={$createdStartDate}&limit={$limit}&shippingProgramType={$shippingProgramType}&shipNodeType={$shipNodeType}",loResp)
IF (lnSuccess = 0) THEN
? loHttp.LastErrorText
RELEASE loHttp
RELEASE loResp
CANCEL
ENDIF
? "Response Status Code: " + STR(loResp.StatusCode)
loJsonResponse = CreateObject('Chilkat.JsonObject')
loJsonResponse.Load(loResp.BodyStr)
loJsonResponse.EmitCompact = 0
? loJsonResponse.Emit()
IF (loResp.StatusCode <> 200) THEN
? "Failed."
RELEASE loHttp
RELEASE loResp
RELEASE loJsonResponse
CANCEL
ENDIF
* 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 loResp
RELEASE loJsonResponse