PowerBuilder

MWS RequestReport (Amazon Marketplace Web Service)

See more Amazon MWS Examples

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

See Amazon MWS RequestReport for more information.

PowerBuilder

integer li_rc
integer li_Success
oleobject loo_Rest
integer li_BTls
integer li_Port
integer li_BAutoReconnect
string ls_ResponseXml
oleobject loo_Xml
string ls_RequestReportResponse_xmlns
string ls_ReportRequestId
string ls_ReportType
string ls_StartDate
string ls_EndDate
string ls_Scheduled
string ls_SubmittedDate
string ls_ReportProcessingStatus
string ls_RequestId

li_Success = 0

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

loo_Rest = create oleobject
li_rc = loo_Rest.ConnectToNewObject("Chilkat.Rest")
if li_rc < 0 then
    destroy loo_Rest
    MessageBox("Error","Connecting to COM object failed")
    return
end if

// 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 
// 
li_BTls = 1
li_Port = 443
li_BAutoReconnect = 1
li_Success = loo_Rest.Connect("mws.amazonservices.com",li_Port,li_BTls,li_BAutoReconnect)
if li_Success <> 1 then
    Write-Debug "ConnectFailReason: " + string(loo_Rest.ConnectFailReason)
    Write-Debug loo_Rest.LastErrorText
    destroy loo_Rest
    return
end if

loo_Rest.Host = "mws.amazonservices.com"

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

ls_ResponseXml = loo_Rest.FullRequestFormUrlEncoded("POST","/Reports/2009-01-01")
if loo_Rest.LastMethodSuccess <> 1 then
    Write-Debug loo_Rest.LastErrorText
    destroy loo_Rest
    return
end if

if loo_Rest.ResponseStatusCode <> 200 then
    // Examine the request/response to see what happened.
    Write-Debug "response status code = " + string(loo_Rest.ResponseStatusCode)
    Write-Debug "response status text = " + loo_Rest.ResponseStatusText
    Write-Debug "response header: " + loo_Rest.ResponseHeader
    Write-Debug "response body: " + ls_ResponseXml
    Write-Debug "---"
    Write-Debug "LastRequestStartLine: " + loo_Rest.LastRequestStartLine
    Write-Debug "LastRequestHeader: " + loo_Rest.LastRequestHeader
end if

// Examine the XML returned in the response body.
Write-Debug ls_ResponseXml
Write-Debug "----"
Write-Debug "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>

loo_Xml = create oleobject
li_rc = loo_Xml.ConnectToNewObject("Chilkat.Xml")

loo_Xml.LoadXml(ls_ResponseXml)

ls_RequestReportResponse_xmlns = loo_Xml.GetAttrValue("xmlns")
ls_ReportRequestId = loo_Xml.GetChildContent("RequestReportResult|ReportRequestInfo|ReportRequestId")
ls_ReportType = loo_Xml.GetChildContent("RequestReportResult|ReportRequestInfo|ReportType")
ls_StartDate = loo_Xml.GetChildContent("RequestReportResult|ReportRequestInfo|StartDate")
ls_EndDate = loo_Xml.GetChildContent("RequestReportResult|ReportRequestInfo|EndDate")
ls_Scheduled = loo_Xml.GetChildContent("RequestReportResult|ReportRequestInfo|Scheduled")
ls_SubmittedDate = loo_Xml.GetChildContent("RequestReportResult|ReportRequestInfo|SubmittedDate")
ls_ReportProcessingStatus = loo_Xml.GetChildContent("RequestReportResult|ReportRequestInfo|ReportProcessingStatus")
ls_RequestId = loo_Xml.GetChildContent("ResponseMetadata|RequestId")


destroy loo_Rest
destroy loo_Xml