(VBScript) MWS RequestReport (Amazon Marketplace Web Service)

Creates a report request and submits the request to Amazon MWS.

See Amazon MWS RequestReport for more information.

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")

' 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)
If (success <> 1) Then
    outFile.WriteLine("ConnectFailReason: " & rest.ConnectFailReason)
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
End If

rest.Host = "mws.amazonservices.com"

success = rest.AddQueryParam("AWSAccessKeyId","0PB842EXAMPLE7N4ZTR2")
success = rest.AddQueryParam("Action","RequestReport")
success = rest.AddQueryParam("EndDate","2008-06-26T18:12:21")
success = rest.AddQueryParam("MWSAuthToken","amzn.mws.4ea38b7b-f563-7709-4bae-87aeaEXAMPLE")
success = rest.AddQueryParam("Marketplace","ATVPDKIKX0DER")
success = rest.AddQueryParam("ReportType","_GET_MERCHANT_LISTINGS_DATA_")
success = rest.AddQueryParam("SellerId","A1XEXAMPLE5E6")
success = rest.AddQueryParam("SignatureMethod","HmacSHA256")
success = rest.AddQueryParam("SignatureVersion","2")
success = rest.AddQueryParam("StartDate","2009-01-03T18:12:21")
success = rest.AddQueryParam("Version","2009-01-01")

' Add the MWS Signature param.  (Also adds the Timestamp parameter using the curent system date/time.)
' The AddMwsSignature method adds the Timestamp and Signature query params.
success = rest.AddMwsSignature("POST","/Reports/2009-01-01","mws.amazonservices.com","MWS_SECRET_KEY")

responseXml = rest.FullRequestFormUrlEncoded("POST","/Reports/2009-01-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.")

' Sample Response

' Use this online tool to generate parsing code from sample XML: 
' Generate Parsing Code from XML

' <?xml version="1.0"?>
' <RequestReportResponse
'     xmlns="http://mws.amazonaws.com/doc/2009-01-01/">
'     <RequestReportResult>
'         <ReportRequestInfo>
'             <ReportRequestId>2291326454</ReportRequestId>
'             <ReportType>_GET_MERCHANT_LISTINGS_DATA_</ReportType>
'             <StartDate>2009-01-21T02:10:39+00:00</StartDate>
'             <EndDate>2009-02-13T02:10:39+00:00</EndDate>
'             <Scheduled>false</Scheduled>
'             <SubmittedDate>2009-02-20T02:10:39+00:00</SubmittedDate>
'             <ReportProcessingStatus>_SUBMITTED_</ReportProcessingStatus>
'         </ReportRequestInfo>
'     </RequestReportResult>
'     <ResponseMetadata>
'         <RequestId>88faca76-b600-46d2-b53c-0c8c4533e43a</RequestId>
'     </ResponseMetadata>
' </RequestReportResponse>

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Xml")
set xml = CreateObject("Chilkat.Xml")
success = xml.LoadXml(responseXml)

RequestReportResponse_xmlns = xml.GetAttrValue("xmlns")
ReportRequestId = xml.GetChildContent("RequestReportResult|ReportRequestInfo|ReportRequestId")
ReportType = xml.GetChildContent("RequestReportResult|ReportRequestInfo|ReportType")
StartDate = xml.GetChildContent("RequestReportResult|ReportRequestInfo|StartDate")
EndDate = xml.GetChildContent("RequestReportResult|ReportRequestInfo|EndDate")
Scheduled = xml.GetChildContent("RequestReportResult|ReportRequestInfo|Scheduled")
SubmittedDate = xml.GetChildContent("RequestReportResult|ReportRequestInfo|SubmittedDate")
ReportProcessingStatus = xml.GetChildContent("RequestReportResult|ReportRequestInfo|ReportProcessingStatus")
RequestId = xml.GetChildContent("ResponseMetadata|RequestId")

outFile.Close