(Excel) MWS List Orders (Amazon Marketplace Web Service)

Send an MWS ListOrders request to return a list of orders created or updated during a time frame.

Important: The Chilkat v9.5.0.75 release accidentally breaks Amazon MWS (not AWS) authentication. If you need MWS with 9.5.0.75, send email to support@chilkatsoft.com for a hotfix, or revert back to v9.5.0.73, or update to a version after 9.5.0.75.

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

' Connect to the Amazon MWS REST server.
' 
' Make sure to connect to the correct Amazon MWS Endpoint, otherwise
' you'll get an HTTP 401 response code.
' 
' The possible servers are:
' 
' North America (NA) 	https://mws.amazonservices.com
' Europe (EU) 	https://mws-eu.amazonservices.com
' India (IN) 	https://mws.amazonservices.in
' China (CN) 	https://mws.amazonservices.com.cn
' Japan (JP) 	https://mws.amazonservices.jp 
' 

bTls = True

port = 443

bAutoReconnect = True

success = rest.Connect("mws.amazonservices.com",port,bTls,bAutoReconnect)

rest.Host = "mws.amazonservices.com"

' Add query params
success = rest.AddQueryParam("Action","ListOrders")
success = rest.AddQueryParam("CreatedAfter","2016-12-31T23:00:00Z")
success = rest.AddQueryParam("MarketplaceId.Id.1","MWS_MARKETPLACE_ID")
success = rest.AddQueryParam("SellerId","MWS_SELLER_ID")
success = rest.AddQueryParam("AWSAccessKeyId","MWS_ACCESS_KEY_ID")
success = rest.AddQueryParam("SignatureVersion","2")
success = rest.AddQueryParam("SignatureMethod","HmacSHA256")
success = rest.AddQueryParam("Version","2013-09-01")

' Add the MWS Signature param.  (Also adds the Timestamp parameter using the curent system date/time.)
success = rest.AddMwsSignature("POST","/Orders/2013-09-01","mws.amazonservices.com","MWS_SECRET_ACCESS_KEY_ID")


responseXml = rest.FullRequestFormUrlEncoded("POST","/Orders/2013-09-01")
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

If (rest.ResponseStatusCode <> 200) Then
    ' Examine the request/response to see what happened.
    Debug.Print "response status code = "; rest.ResponseStatusCode
    Debug.Print "response status text = "; rest.ResponseStatusText
    Debug.Print "response header: "; rest.ResponseHeader
    Debug.Print "response body: "; responseXml
    Debug.Print "---"
    Debug.Print "LastRequestStartLine: "; rest.LastRequestStartLine
    Debug.Print "LastRequestHeader: "; rest.LastRequestHeader
End If

' Examine the XML returned in the response body.
Debug.Print responseXml
Debug.Print "----"
Debug.Print "Success."