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

See more Amazon MWS Examples

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.

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

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

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

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Rest")
set rest = CreateObject("Chilkat.Rest")

' ------------------------------------------------------------
' About using Chilkat with Amazon Marketplace SP-API
' ------------------------------------------------------------

' 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 = 1
port = 443
bAutoReconnect = 1
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 <> 1) Then
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
End If

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

' Examine the XML returned in the response body.
outFile.WriteLine(responseXml)
outFile.WriteLine("----")
outFile.WriteLine("Success.")

outFile.Close