(PowerShell) 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 .NET Downloads Chilkat .NET Assemblies

Add-Type -Path "C:\chilkat\ChilkatDotNet47-9.5.0-x64\ChilkatDotNet47.dll"

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

$rest = New-Object 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 = $true
$port = 443
$bAutoReconnect = $true
$success = $rest.Connect("mws.amazonservices.com",$port,$bTls,$bAutoReconnect)
if ($success -ne $true) {
    $("ConnectFailReason: " + $rest.ConnectFailReason)
    $($rest.LastErrorText)
    exit
}

$rest.Host = "mws.amazonservices.com"

$rest.AddQueryParam("AWSAccessKeyId","0PB842EXAMPLE7N4ZTR2")
$rest.AddQueryParam("Action","RequestReport")
$rest.AddQueryParam("EndDate","2008-06-26T18:12:21")
$rest.AddQueryParam("MWSAuthToken","amzn.mws.4ea38b7b-f563-7709-4bae-87aeaEXAMPLE")
$rest.AddQueryParam("Marketplace","ATVPDKIKX0DER")
$rest.AddQueryParam("ReportType","_GET_MERCHANT_LISTINGS_DATA_")
$rest.AddQueryParam("SellerId","A1XEXAMPLE5E6")
$rest.AddQueryParam("SignatureMethod","HmacSHA256")
$rest.AddQueryParam("SignatureVersion","2")
$rest.AddQueryParam("StartDate","2009-01-03T18:12:21")
$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.
$rest.AddMwsSignature("POST","/Reports/2009-01-01","mws.amazonservices.com","MWS_SECRET_KEY")

$responseXml = $rest.FullRequestFormUrlEncoded("POST","/Reports/2009-01-01")
if ($rest.LastMethodSuccess -ne $true) {
    $($rest.LastErrorText)
    exit
}

if ($rest.ResponseStatusCode -ne 200) {
    # Examine the request/response to see what happened.
    $("response status code = " + $rest.ResponseStatusCode)
    $("response status text = " + $rest.ResponseStatusText)
    $("response header: " + $rest.ResponseHeader)
    $("response body: " + $responseXml)
    $("---")
    $("LastRequestStartLine: " + $rest.LastRequestStartLine)
    $("LastRequestHeader: " + $rest.LastRequestHeader)
}

# Examine the XML returned in the response body.
$($responseXml)
$("----")
$("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>

$xml = New-Object Chilkat.Xml
$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")