AutoIt
AutoIt
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 AutoIt Downloads
Local $bSuccess = False
; This example requires the Chilkat API to have been previously unlocked.
; See Global Unlock Sample for sample code.
$oHttp = ObjCreate("Chilkat.Http")
$oHttp.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))
$oHttp.Login = "clientId"
$oHttp.Password = "clientSecret"
$oHttp.BasicAuth = True
$oHttp.SetRequestHeader "Content-Type","application/json"
$oHttp.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
$oHttp.SetRequestHeader "WM_SEC.ACCESS_TOKEN","eyJraWQiOiIzZjVhYTFmNS1hYWE5LTQzM....."
$oHttp.SetRequestHeader "WM_SVC.NAME","Walmart Marketplace"
$oHttp.SetUrlVar("createdStartDate","2020-01-16T10:30:15Z")
$oHttp.SetUrlVar("limit","200")
; Can also be 3PLFulfilled
$oHttp.SetUrlVar("shippingProgramType","SellerFulfilled")
$oHttp.SetUrlVar("shipNodeType","TWO_DAY")
$oResp = ObjCreate("Chilkat.HttpResponse")
$bSuccess = $oHttp.HttpNoBody("GET","/v3/orders/released?createdStartDate={$createdStartDate}&limit={$limit}&shippingProgramType={$shippingProgramType}&shipNodeType={$shipNodeType}",$oResp)
If ($bSuccess = False) Then
ConsoleWrite($oHttp.LastErrorText & @CRLF)
Exit
EndIf
ConsoleWrite("Response Status Code: " & $oResp.StatusCode & @CRLF)
$oJsonResponse = ObjCreate("Chilkat.JsonObject")
$oJsonResponse.Load($oResp.BodyStr)
$oJsonResponse.EmitCompact = False
ConsoleWrite($oJsonResponse.Emit() & @CRLF)
If ($oResp.StatusCode <> 200) Then
ConsoleWrite("Failed." & @CRLF)
Exit
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"
; }
; }
; ]
; }
; }
; }
;
Local $sPurchaseOrderId
Local $sCustomerOrderId
Local $sCustomerEmailId
Local $iOrderDate
Local $shippingInfoPhone
Local $iShippingInfoEstimatedDeliveryDate
Local $iShippingInfoEstimatedShipDate
Local $shippingInfoMethodCode
Local $shippingInfoPostalAddressName
Local $shippingInfoPostalAddressAddress1
Local $shippingInfoPostalAddressAddress2
Local $shippingInfoPostalAddressCity
Local $shippingInfoPostalAddressState
Local $shippingInfoPostalAddressPostalCode
Local $shippingInfoPostalAddressCountry
Local $shippingInfoPostalAddressAddressType
Local $shipNodeType
Local $iJ
Local $iCount_j
Local $sLineNumber
Local $sItemProductName
Local $sItemSku
Local $sOrderLineQuantityUnitOfMeasurement
Local $sOrderLineQuantityAmount
Local $iStatusDate
Local $sRefund
Local $sFulfillmentFulfillmentOption
Local $sFulfillmentShipMethod
Local $sFulfillmentStoreId
Local $iFulfillmentPickUpDateTime
Local $sFulfillmentPickUpBy
Local $sFulfillmentShippingProgramType
Local $iK
Local $iCount_k
Local $sChargeType
Local $sChargeName
Local $sChargeAmountCurrency
Local $iChargeAmountAmount
Local $sTaxTaxName
Local $sTaxTaxAmountCurrency
Local $sTaxTaxAmountAmount
Local $status
Local $statusQuantityUnitOfMeasurement
Local $statusQuantityAmount
Local $sCancellationReason
Local $sTrackingInfo
Local $sReturnCenterAddress
Local $iListMetaTotalCount = $oJsonResponse.IntOf("list.meta.totalCount")
Local $iListMetaLimit = $oJsonResponse.IntOf("list.meta.limit")
Local $sListMetaNextCursor = $oJsonResponse.StringOf("list.meta.nextCursor")
Local $i = 0
Local $iCount_i = $oJsonResponse.SizeOfArray("list.elements.order")
While $i < $iCount_i
$oJsonResponse.I = $i
$sPurchaseOrderId = $oJsonResponse.StringOf("list.elements.order[i].purchaseOrderId")
$sCustomerOrderId = $oJsonResponse.StringOf("list.elements.order[i].customerOrderId")
$sCustomerEmailId = $oJsonResponse.StringOf("list.elements.order[i].customerEmailId")
$iOrderDate = $oJsonResponse.IntOf("list.elements.order[i].orderDate")
$shippingInfoPhone = $oJsonResponse.StringOf("list.elements.order[i].shippingInfo.phone")
$iShippingInfoEstimatedDeliveryDate = $oJsonResponse.IntOf("list.elements.order[i].shippingInfo.estimatedDeliveryDate")
$iShippingInfoEstimatedShipDate = $oJsonResponse.IntOf("list.elements.order[i].shippingInfo.estimatedShipDate")
$shippingInfoMethodCode = $oJsonResponse.StringOf("list.elements.order[i].shippingInfo.methodCode")
$shippingInfoPostalAddressName = $oJsonResponse.StringOf("list.elements.order[i].shippingInfo.postalAddress.name")
$shippingInfoPostalAddressAddress1 = $oJsonResponse.StringOf("list.elements.order[i].shippingInfo.postalAddress.address1")
$shippingInfoPostalAddressAddress2 = $oJsonResponse.StringOf("list.elements.order[i].shippingInfo.postalAddress.address2")
$shippingInfoPostalAddressCity = $oJsonResponse.StringOf("list.elements.order[i].shippingInfo.postalAddress.city")
$shippingInfoPostalAddressState = $oJsonResponse.StringOf("list.elements.order[i].shippingInfo.postalAddress.state")
$shippingInfoPostalAddressPostalCode = $oJsonResponse.StringOf("list.elements.order[i].shippingInfo.postalAddress.postalCode")
$shippingInfoPostalAddressCountry = $oJsonResponse.StringOf("list.elements.order[i].shippingInfo.postalAddress.country")
$shippingInfoPostalAddressAddressType = $oJsonResponse.StringOf("list.elements.order[i].shippingInfo.postalAddress.addressType")
$shipNodeType = $oJsonResponse.StringOf("list.elements.order[i].shipNode.type")
$iJ = 0
$iCount_j = $oJsonResponse.SizeOfArray("list.elements.order[i].orderLines.orderLine")
While $iJ < $iCount_j
$oJsonResponse.J = $iJ
$sLineNumber = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].lineNumber")
$sItemProductName = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].item.productName")
$sItemSku = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].item.sku")
$sOrderLineQuantityUnitOfMeasurement = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].orderLineQuantity.unitOfMeasurement")
$sOrderLineQuantityAmount = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].orderLineQuantity.amount")
$iStatusDate = $oJsonResponse.IntOf("list.elements.order[i].orderLines.orderLine[j].statusDate")
$sRefund = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].refund")
$sFulfillmentFulfillmentOption = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].fulfillment.fulfillmentOption")
$sFulfillmentShipMethod = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].fulfillment.shipMethod")
$sFulfillmentStoreId = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].fulfillment.storeId")
$iFulfillmentPickUpDateTime = $oJsonResponse.IntOf("list.elements.order[i].orderLines.orderLine[j].fulfillment.pickUpDateTime")
$sFulfillmentPickUpBy = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].fulfillment.pickUpBy")
$sFulfillmentShippingProgramType = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].fulfillment.shippingProgramType")
$iK = 0
$iCount_k = $oJsonResponse.SizeOfArray("list.elements.order[i].orderLines.orderLine[j].charges.charge")
While $iK < $iCount_k
$oJsonResponse.K = $iK
$sChargeType = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].chargeType")
$sChargeName = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].chargeName")
$sChargeAmountCurrency = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].chargeAmount.currency")
$iChargeAmountAmount = $oJsonResponse.IntOf("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].chargeAmount.amount")
$sTaxTaxName = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].tax.taxName")
$sTaxTaxAmountCurrency = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].tax.taxAmount.currency")
$sTaxTaxAmountAmount = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].charges.charge[k].tax.taxAmount.amount")
$iK = $iK + 1
Wend
$iK = 0
$iCount_k = $oJsonResponse.SizeOfArray("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus")
While $iK < $iCount_k
$oJsonResponse.K = $iK
$status = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus[k].status")
$statusQuantityUnitOfMeasurement = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus[k].statusQuantity.unitOfMeasurement")
$statusQuantityAmount = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus[k].statusQuantity.amount")
$sCancellationReason = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus[k].cancellationReason")
$sTrackingInfo = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus[k].trackingInfo")
$sReturnCenterAddress = $oJsonResponse.StringOf("list.elements.order[i].orderLines.orderLine[j].orderLineStatuses.orderLineStatus[k].returnCenterAddress")
$iK = $iK + 1
Wend
$iJ = $iJ + 1
Wend
$i = $i + 1
Wend