PowerBuilder

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.

PowerBuilder

integer li_rc
long li_Success
oleobject loo_Rest
long li_BTls
long li_Port
long li_BAutoReconnect
string ls_ResponseXml

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

//  ------------------------------------------------------------
//  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 
//  
li_BTls = 1
li_Port = 443
li_BAutoReconnect = 1
li_Success = loo_Rest.Connect("mws.amazonservices.com",li_Port,li_BTls,li_BAutoReconnect)

loo_Rest.Host = "mws.amazonservices.com"

//  Add query params
loo_Rest.AddQueryParam("Action","ListOrders")
loo_Rest.AddQueryParam("CreatedAfter","2016-12-31T23:00:00Z")
loo_Rest.AddQueryParam("MarketplaceId.Id.1","MWS_MARKETPLACE_ID")
loo_Rest.AddQueryParam("SellerId","MWS_SELLER_ID")
loo_Rest.AddQueryParam("AWSAccessKeyId","MWS_ACCESS_KEY_ID")
loo_Rest.AddQueryParam("SignatureVersion","2")
loo_Rest.AddQueryParam("SignatureMethod","HmacSHA256")
loo_Rest.AddQueryParam("Version","2013-09-01")

//  Add the MWS Signature param.  (Also adds the Timestamp parameter using the curent system date/time.)
loo_Rest.AddMwsSignature("POST","/Orders/2013-09-01","mws.amazonservices.com","MWS_SECRET_ACCESS_KEY_ID")

ls_ResponseXml = loo_Rest.FullRequestFormUrlEncoded("POST","/Orders/2013-09-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."


destroy loo_Rest