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

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

Note: This example requires Chilkat v9.5.0.66 or greater.

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 assumes the Chilkat HTTP API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' Note: This example requires Chilkat v9.5.0.66 or greater.
Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Make sure to connect to the correct Amazon MWS Endpoing, 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 
' 

' Build the HTTP request.
Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest

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

' Set the HTTP verb and path.
req.Path = "/Orders/2013-09-01"
req.HttpVerb = "POST"

' Add the MWS Signature after the verb, path, and all params have been set.
Dim success As Boolean
success = req.AddMwsSignature("mws.amazonservices.com","MWS_SECRET_ACCESS_KEY_ID")


Set resp = http.PostUrlEncoded("https://mws.amazonservices.com/Orders/2013-09-01",req)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

If (resp.StatusCode <> 200) Then
    Debug.Print "Non-success status code: "; resp.StatusCode
    Debug.Print resp.BodyStr

    Exit Sub
End If

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