Lua Requires Chilkat v11.0.0+
Lua
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 Lua Downloads
local chilkat = require("chilkat")
-- This example requires the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
local http = chilkat.Http.new()
http.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))
http.login = "clientId"
http.password = "clientSecret"
http.basic_auth = true
http:set_request_header("Content-Type", "application/json")
http:set_request_header("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
http:set_request_header("WM_SEC.ACCESS_TOKEN", "eyJraWQiOiIzZjVhYTFmNS1hYWE5LTQzM.....")
http:set_request_header("WM_SVC.NAME", "Walmart Marketplace")
http:set_url_var("createdStartDate", "2020-01-16T10:30:15Z")
http:set_url_var("limit", "200")
-- Can also be 3PLFulfilled
http:set_url_var("shippingProgramType", "SellerFulfilled")
http:set_url_var("shipNodeType", "TWO_DAY")
local resp = chilkat.HttpResponse.new()
local success = http:http_no_body("GET", "/v3/orders/released?createdStartDate={$createdStartDate}&limit={$limit}&shippingProgramType={$shippingProgramType}&shipNodeType={$shipNodeType}", resp)
if not success then
print(http.last_error_text)
return
end
print("Response Status Code: " .. resp.status_code)
local jsonResponse = chilkat.JsonObject.new()
jsonResponse:load(resp.body_str)
jsonResponse.emit_compact = false
print(jsonResponse:emit())
if resp.status_code ~= 200 then
print("Failed.")
return
end
-- 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"
-- }
-- }
-- ]
-- }
-- }
-- }
--
local purchaseOrderId = ""
local customerOrderId = ""
local customerEmailId = ""
local orderDate = 0
local shippingInfoPhone = ""
local shippingInfoEstimatedDeliveryDate = 0
local shippingInfoEstimatedShipDate = 0
local shippingInfoMethodCode = ""
local shippingInfoPostalAddressName = ""
local shippingInfoPostalAddressAddress1 = ""
local shippingInfoPostalAddressAddress2 = ""
local shippingInfoPostalAddressCity = ""
local shippingInfoPostalAddressState = ""
local shippingInfoPostalAddressPostalCode = ""
local shippingInfoPostalAddressCountry = ""
local shippingInfoPostalAddressAddressType = ""
local shipNodeType = ""
local j = 0
local count_j = 0
local lineNumber = ""
local itemProductName = ""
local itemSku = ""
local orderLineQuantityUnitOfMeasurement = ""
local orderLineQuantityAmount = ""
local statusDate = 0
local refund = ""
local fulfillmentFulfillmentOption = ""
local fulfillmentShipMethod = ""
local fulfillmentStoreId = ""
local fulfillmentPickUpDateTime = 0
local fulfillmentPickUpBy = ""
local fulfillmentShippingProgramType = ""
local k = 0
local count_k = 0
local chargeType = ""
local chargeName = ""
local chargeAmountCurrency = ""
local chargeAmountAmount = 0
local taxTaxName = ""
local taxTaxAmountCurrency = ""
local taxTaxAmountAmount = ""
local status = ""
local statusQuantityUnitOfMeasurement = ""
local statusQuantityAmount = ""
local cancellationReason = ""
local trackingInfo = ""
local returnCenterAddress = ""
local listMetaTotalCount = jsonResponse:int_of("list.meta.totalCount")
local listMetaLimit = jsonResponse:int_of("list.meta.limit")
local listMetaNextCursor = jsonResponse:string_of("list.meta.nextCursor")
local i = 0
local count_i = jsonResponse:size_of_array("list.elements.order")
while i < count_i do
jsonResponse.i = i
purchaseOrderId = jsonResponse:string_of("list.elements.order[i].purchaseOrderId")
customerOrderId = jsonResponse:string_of("list.elements.order[i].customerOrderId")
customerEmailId = jsonResponse:string_of("list.elements.order[i].customerEmailId")
orderDate = jsonResponse:int_of("list.elements.order[i].orderDate")
shippingInfoPhone = jsonResponse:string_of("list.elements.order[i].shippingInfo.phone")
shippingInfoEstimatedDeliveryDate = jsonResponse:int_of("list.elements.order[i].shippingInfo.estimatedDeliveryDate")
shippingInfoEstimatedShipDate = jsonResponse:int_of("list.elements.order[i].shippingInfo.estimatedShipDate")
shippingInfoMethodCode = jsonResponse:string_of("list.elements.order[i].shippingInfo.methodCode")
shippingInfoPostalAddressName = jsonResponse:string_of("list.elements.order[i].shippingInfo.postalAddress.name")
shippingInfoPostalAddressAddress1 = jsonResponse:string_of("list.elements.order[i].shippingInfo.postalAddress.address1")
shippingInfoPostalAddressAddress2 = jsonResponse:string_of("list.elements.order[i].shippingInfo.postalAddress.address2")
shippingInfoPostalAddressCity = jsonResponse:string_of("list.elements.order[i].shippingInfo.postalAddress.city")
shippingInfoPostalAddressState = jsonResponse:string_of("list.elements.order[i].shippingInfo.postalAddress.state")
shippingInfoPostalAddressPostalCode = jsonResponse:string_of("list.elements.order[i].shippingInfo.postalAddress.postalCode")
shippingInfoPostalAddressCountry = jsonResponse:string_of("list.elements.order[i].shippingInfo.postalAddress.country")
shippingInfoPostalAddressAddressType = jsonResponse:string_of("list.elements.order[i].shippingInfo.postalAddress.addressType")
shipNodeType = jsonResponse:string_of("list.elements.order[i].shipNode.type")
j = 0
count_j = jsonResponse:size_of_array("list.elements.order[i].orderLines.orderLine")
while j < count_j do
jsonResponse.j = j
lineNumber = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].lineNumber")
itemProductName = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].item.productName")
itemSku = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].item.sku")
orderLineQuantityUnitOfMeasurement = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].orderLineQuantity.unitOfMeasurement")
orderLineQuantityAmount = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].orderLineQuantity.amount")
statusDate = jsonResponse:int_of("list.elements.order[i].orderLines.orderLine[j].statusDate")
refund = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].refund")
fulfillmentFulfillmentOption = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].fulfillment.fulfillmentOption")
fulfillmentShipMethod = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].fulfillment.shipMethod")
fulfillmentStoreId = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].fulfillment.storeId")
fulfillmentPickUpDateTime = jsonResponse:int_of("list.elements.order[i].orderLines.orderLine[j].fulfillment.pickUpDateTime")
fulfillmentPickUpBy = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].fulfillment.pickUpBy")
fulfillmentShippingProgramType = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].fulfillment.shippingProgramType")
k = 0
count_k = jsonResponse:size_of_array("list.elements.order[i].orderLines.orderLine[j].charges.charge")
while k < count_k do
jsonResponse.k = k
chargeType = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].chargeType")
chargeName = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].chargeName")
chargeAmountCurrency = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].chargeAmount.currency")
chargeAmountAmount = jsonResponse:int_of("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].chargeAmount.amount")
taxTaxName = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].tax.taxName")
taxTaxAmountCurrency = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].tax.taxAmount.currency")
taxTaxAmountAmount = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].tax.taxAmount.amount")
k = k + 1
end
k = 0
count_k = jsonResponse:size_of_array("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus")
while k < count_k do
jsonResponse.k = k
status = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus[k].status")
statusQuantityUnitOfMeasurement = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus[k].statusQuantity.unitOfMeasurement")
statusQuantityAmount = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus[k].statusQuantity.amount")
cancellationReason = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus[k].cancellationReason")
trackingInfo = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus[k].trackingInfo")
returnCenterAddress = jsonResponse:string_of("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus[k].returnCenterAddress")
k = k + 1
end
j = j + 1
end
i = i + 1
end