(AutoIt) Amazon SP-API Get Order Items

See more Amazon SP-API Examples

Returns detailed order item information for the order that you specify.

For more information, see https://developer-docs.amazon.com/sp-api/docs/orders-api-v0-reference#get-ordersv0ordersorderidorderitems

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

; This example requires the Chilkat API to have been previously unlocked.
; See Global Unlock Sample for sample code.

; Gets detailed order item information for a specified order ID
; The order ID is something like "902-1845936-5435065" and it is the AmazonOrderId returned in the JSON when getting the list of orders.  For example:
; {
;   "payload": {
;     "CreatedBefore": "1.569521782042E9",
;     "Orders": [
;       {
;         "AmazonOrderId": "902-1845936-5435065",
;         "PurchaseDate": "1970-01-19T03:58:30Z",
; ...

; However, when using the sandbox, instead use the explicit keyword TEST_CASE_200
Local $sOrderId = "TEST_CASE_200"

$oAuthAws = ObjCreate("Chilkat.AuthAws")
$oAuthAws.AccessKey = "AWS_ACCESS_KEY"
$oAuthAws.SecretKey = "AWS_SECRET_KEY"
$oAuthAws.ServiceName = "execute-api"
; Use the region that is correct for your needs.
$oAuthAws.Region = "eu-west-1"

; First get a restricted data token for the given order ID.
; This requires an LWA access token which cannot be more than 1 hour old.
; See Fetch SP-API LWA Access Token
$oJsonLwaToken = ObjCreate("Chilkat.JsonObject")
Local $bSuccess = $oJsonLwaToken.LoadFile("qa_data/tokens/sp_api_lwa_token.json")
If ($bSuccess = False) Then
    ConsoleWrite("Failed to load LWA access token." & @CRLF)
    Exit
EndIf

; Must use the non-sandbox domain for getting the RDT.
$oRest = ObjCreate("Chilkat.Rest")
$bSuccess = $oRest.Connect("sellingpartnerapi-eu.amazon.com",443,True,True)
If ($bSuccess = False) Then
    ConsoleWrite($oRest.LastErrorText & @CRLF)
    Exit
EndIf

$bSuccess = $oRest.SetAuthAws($oAuthAws)

; Add the x-amz-access-token request header.
Local $sLwa_token = $oJsonLwaToken.StringOf("access_token")
$oRest.ClearAllHeaders()
$oRest.AddHeader("x-amz-access-token",$sLwa_token)

; We're going to send a POST with the following JSON body:

; {
;   "restrictedResources": [
;     {
;       "method": "GET",
;       "path": "/orders/v0/orders/{orderId}/orderItems",
;       "dataElements": ["buyerInfo"]
;     }
;   ]
; }

$oSbPath = ObjCreate("Chilkat.StringBuilder")
$oSbPath.Append("/orders/v0/orders/")
$oSbPath.Append($sOrderId)
$oSbPath.Append("/orderItems")

$oJsonRc = ObjCreate("Chilkat.JsonObject")
$oJsonRc.UpdateString("restrictedResources[0].method","GET")
$oJsonRc.UpdateString("restrictedResources[0].path",$oSbPath.GetAsString())
$oJsonRc.UpdateString("restrictedResources[0].dataElements[0]","buyerInfo")

$oSbRequest = ObjCreate("Chilkat.StringBuilder")
$oJsonRc.EmitSb($oSbRequest)

$oSbResponse = ObjCreate("Chilkat.StringBuilder")
Local $sUri = "/tokens/2021-03-01/restrictedDataToken"
$bSuccess = $oRest.FullRequestSb("POST",$sUri,$oSbRequest,$oSbResponse)
If ($bSuccess = False) Then
    ConsoleWrite($oRest.LastErrorText & @CRLF)
    Exit
EndIf

; Examine the response status.
Local $iStatusCode = $oRest.ResponseStatusCode
If ($iStatusCode <> 200) Then
    ConsoleWrite("Response status code: " & $iStatusCode & @CRLF)
    ConsoleWrite("Response status text: " & $oRest.ResponseStatusText & @CRLF)
    ConsoleWrite("Response body: " & @CRLF)
    ConsoleWrite($oSbResponse.GetAsString() & @CRLF)
    ConsoleWrite("Failed." & @CRLF)
    Exit
EndIf

; Get the restricted data token.
$oJsonResp = ObjCreate("Chilkat.JsonObject")
$oJsonResp.LoadSb($oSbResponse)
Local $sRestrictedDataToken = $oJsonResp.StringOf("restrictedDataToken")
ConsoleWrite("Restricted Data Token: " & $sRestrictedDataToken & @CRLF)

; ------------------------------------------------------------------------------------------------------------
; ------------------------------------------------------------------------------------------------------------
; Now that we have the RDT, we can use it to get information about the order.
; 
; Yes, the SP-API is horribly tedious and painful.  You must use an RDT specifically tailored to each request requiring an RDT,
; the RDT must not be over an hour old, and if you need to get a new RDT you must get it using an LWA token that itself is not
; more than an hour old.  If the LWA is more than an hour old, you must get a new one.  Ughhh!!!!!
; ------------------------------------------------------------------------------------------------------------

; Disconnect from the non-sandbox domain.  This example will use the sandbox.
; (The RDT was obtained using the non-sandbox domain.  For some reason, the sandbox domain does not work for getting the RDT.)
$oRest.Disconnect(100)

$bSuccess = $oRest.Connect("sandbox.sellingpartnerapi-eu.amazon.com",443,True,True)
If ($bSuccess = False) Then
    ConsoleWrite($oRest.LastErrorText & @CRLF)
    Exit
EndIf

$bSuccess = $oRest.SetAuthAws($oAuthAws)

$oRest.ClearAllHeaders()
$oRest.AddHeader("x-amz-access-token",$sRestrictedDataToken)

$oRest.ClearAllQueryParams()
$oRest.AddQueryParam("MarketplaceIds","ATVPDKIKX0DER")

$oRest.ClearAllPathParams()
$oRest.AddPathParam("{orderId}",$sOrderId)

$sUri = "/orders/v0/orders/{orderId}/orderItems"
$bSuccess = $oRest.FullRequestNoBodySb("GET",$sUri,$oSbResponse)
If ($bSuccess = False) Then
    ConsoleWrite($oRest.LastErrorText & @CRLF)
    Exit
EndIf

; Examine the response status.
$iStatusCode = $oRest.ResponseStatusCode
If ($iStatusCode <> 200) Then
    ConsoleWrite("Response status text: " & $oRest.ResponseStatusText & @CRLF)
    ConsoleWrite("Response body: " & @CRLF)
    ConsoleWrite($oSbResponse.GetAsString() & @CRLF)
    ConsoleWrite("Failed." & @CRLF)
    Exit
EndIf

; If successful, gets a JSON response such as the following:

; {
;   "payload": {
;     "AmazonOrderId": "902-1845936-5435065",
;     "OrderItems": [
;       {
;         "ASIN": "B00551Q3CS",
;         "OrderItemId": "05015851154158",
;         "SellerSKU": "NABetaASINB00551Q3CS",
;         "Title": "B00551Q3CS [Card Book]",
;         "QuantityOrdered": 1,
;         "QuantityShipped": 0,
;         "ProductInfo": {
;           "NumberOfItems": 1
;         },
;         "ItemPrice": {
;           "CurrencyCode": "USD",
;           "Amount": "10.00"
;         },
;         "ItemTax": {
;           "CurrencyCode": "USD",
;           "Amount": "1.01"
;         },
;         "PromotionDiscount": {
;           "CurrencyCode": "USD",
;           "Amount": "0.00"
;         },
;         "IsGift": false,
;         "ConditionId": "New",
;         "ConditionSubtypeId": "New",
;         "IsTransparency": false,
;         "SerialNumberRequired": false,
;         "IossNumber": "",
;         "DeemedResellerCategory": "IOSS",
;         "StoreChainStoreId": "ISPU_StoreId",
;         "BuyerRequestedCancel": {
;           "IsBuyerRequestedCancel": true,
;           "BuyerCancelReason": "Found cheaper somewhere else."
;         }
;       }
;     ]
;   }
; }

; Use this online tool to generate parsing code from sample JSON: 
; Generate Parsing Code from JSON

$oJson = ObjCreate("Chilkat.JsonObject")

$oJson.LoadSb($oSbResponse)
$oJson.EmitCompact = False
ConsoleWrite($oJson.Emit() & @CRLF)

Local $sASIN
Local $sOrderItemId
Local $sSellerSKU
Local $sTitle
Local $iQuantityOrdered
Local $iQuantityShipped
Local $iNumberOfItems
Local $sCurrencyCode
Local $sAmount
Local $sItemTaxCurrencyCode
Local $sItemTaxAmount
Local $sPromotionDiscountCurrencyCode
Local $sPromotionDiscountAmount
Local $bIsGift
Local $sConditionId
Local $sConditionSubtypeId
Local $bIsTransparency
Local $bSerialNumberRequired
Local $sIossNumber
Local $sDeemedResellerCategory
Local $sStoreChainStoreId
Local $bIsBuyerRequestedCancel
Local $sBuyerCancelReason

Local $sAmazonOrderId = $oJson.StringOf("payload.AmazonOrderId")
Local $i = 0
Local $iCount_i = $oJson.SizeOfArray("payload.OrderItems")
While $i < $iCount_i
    $oJson.I = $i
    $sASIN = $oJson.StringOf("payload.OrderItems[i].ASIN")
    $sOrderItemId = $oJson.StringOf("payload.OrderItems[i].OrderItemId")
    $sSellerSKU = $oJson.StringOf("payload.OrderItems[i].SellerSKU")
    $sTitle = $oJson.StringOf("payload.OrderItems[i].Title")
    $iQuantityOrdered = $oJson.IntOf("payload.OrderItems[i].QuantityOrdered")
    $iQuantityShipped = $oJson.IntOf("payload.OrderItems[i].QuantityShipped")
    $iNumberOfItems = $oJson.IntOf("payload.OrderItems[i].ProductInfo.NumberOfItems")
    $sCurrencyCode = $oJson.StringOf("payload.OrderItems[i].ItemPrice.CurrencyCode")
    $sAmount = $oJson.StringOf("payload.OrderItems[i].ItemPrice.Amount")
    $sItemTaxCurrencyCode = $oJson.StringOf("payload.OrderItems[i].ItemTax.CurrencyCode")
    $sItemTaxAmount = $oJson.StringOf("payload.OrderItems[i].ItemTax.Amount")
    $sPromotionDiscountCurrencyCode = $oJson.StringOf("payload.OrderItems[i].PromotionDiscount.CurrencyCode")
    $sPromotionDiscountAmount = $oJson.StringOf("payload.OrderItems[i].PromotionDiscount.Amount")
    $bIsGift = $oJson.BoolOf("payload.OrderItems[i].IsGift")
    $sConditionId = $oJson.StringOf("payload.OrderItems[i].ConditionId")
    $sConditionSubtypeId = $oJson.StringOf("payload.OrderItems[i].ConditionSubtypeId")
    $bIsTransparency = $oJson.BoolOf("payload.OrderItems[i].IsTransparency")
    $bSerialNumberRequired = $oJson.BoolOf("payload.OrderItems[i].SerialNumberRequired")
    $sIossNumber = $oJson.StringOf("payload.OrderItems[i].IossNumber")
    $sDeemedResellerCategory = $oJson.StringOf("payload.OrderItems[i].DeemedResellerCategory")
    $sStoreChainStoreId = $oJson.StringOf("payload.OrderItems[i].StoreChainStoreId")
    $bIsBuyerRequestedCancel = $oJson.BoolOf("payload.OrderItems[i].BuyerRequestedCancel.IsBuyerRequestedCancel")
    $sBuyerCancelReason = $oJson.StringOf("payload.OrderItems[i].BuyerRequestedCancel.BuyerCancelReason")
    $i = $i + 1
Wend

ConsoleWrite("Success!" & @CRLF)