(Excel) MWS List Orders by Next Token (Amazon Marketplace Web Service)

Returns the next page of orders using the NextToken parameter.

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.

' See MWS List Orders By Next Token for additional details 

' We need to send a GET request like this:

' https://mws.amazonservices.jp/Orders/2013-09-01
'   ?AWSAccessKeyId=0PB842EXAMPLE7N4ZTR2
'   &Action=ListOrdersByNextToken
'   &MWSAuthToken=amzn.mws.4ea38b7b-f563-7709-4bae-87aeaEXAMPLE
'   &SellerId=A2986ZQ066CH2F
'   &Signature=ZQLpf8vEXAMPLE0iC265pf18n0%3D
'   &SignatureVersion=2
'   &SignatureMethod=HmacSHA256
'   &NextToken=2YgYW55IGNhcm5hbCBwbGVhc3VyZS4%3D
'   &Timestamp=2017-02-05T18%3A12%3A21.687Z
'   &Version=2013-09-01

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("NextToken","THE_NEXT_TOKEN_FROM_THE_PREVIOUS_REPLY")
success = rest.AddQueryParam("Action","ListOrdersByNextToken")
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."