(Excel) Amazon MWS Upload Invoice

Demonstrates how to upload an invoice using _UPLOAD_VAT_INVOICE_FeedType to submit an invoice for an order.

For more information, see https://m.media-amazon.com/images/G/03/B2B/invoice-uploader-developer-documentation.pdf

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

' 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.
' 
' See Amazon MWS endpoints and MarketplaceId values


bTls = True

port = 443

bAutoReconnect = True
success = rest.Connect("mws.amazonservices.com",port,bTls,bAutoReconnect)

rest.Host = "mws.amazonservices.com"

' MarketplaceList.Id parameter This should be the marketplace in which the order was placed. Only one marketplace must be used per order.T
' Here are the marketplace ID's
' Spain: A1RKKUPIHCS9HS
' UK: A1F83G8C2ARO7P
' France: A13V1IB3VIYZZH
' Germany: A1PA6795UKMFR9
' Italy: APJ6JRA9NG5V4
' ...
' (See https://docs.developer.amazonservices.com/en_US/dev_guide/DG_Endpoints.html)

' FeedOptions parameter  Seller can input key value pairs to give important metadata along with the PDF invoice.
Dim success As Boolean
success = rest.AddQueryParam("FeedOptions","metadata:orderid=206-2341234-3455465;metadata:invoicenumber=INT-3431-XJE3;metadata:documenttype=Invoice")

' Load the PDF invoice file that is to be the body of the HTTP POST request.
Dim pdfData As Chilkat.BinData
Set pdfData = Chilkat.NewBinData
success = pdfData.LoadFile("qa_data/pdf/sample.pdf")

' Get the MD5 hash of the PDF data.
Dim crypt As Chilkat.Crypt2
Set crypt = Chilkat.NewCrypt2
crypt.HashAlgorithm = "md5"
crypt.EncodingMode = "base64"

md5Hash = crypt.HashBdENC(pdfData)

success = rest.AddQueryParam("AWSAccessKeyId","0PB842ExampleN4ZTR2")
success = rest.AddQueryParam("Action","SubmitFeed")
success = rest.AddQueryParam("FeedType","_UPLOAD_VAT_INVOICE_")
success = rest.AddQueryParam("MWSAuthToken","EXAMPLE-amzn.mws.4ea38b7b-f563-7709-4bae-87aea-EXAMPLE")

success = rest.AddQueryParam("MarketplaceIdList.Id.1","ATVExampleDER")
success = rest.AddQueryParam("SellerId","A1XExample5E6")
success = rest.AddQueryParam("ContentMD5Value",md5Hash)
success = rest.AddQueryParam("SignatureMethod","HmacSHA256")
success = rest.AddQueryParam("SignatureVersion","2")
success = rest.AddQueryParam("Version","2009-01-01")

' Add the MWS Signature param.  (Also adds the Timestamp parameter using the curent system date/time.)
success = rest.AddMwsSignature("POST","/Feeds/2009-01-01","mws.amazonservices.com","YOUR_MWS_SECRET_ACCESS_KEY_ID")

success = rest.AddHeader("Content-Type","application/octet-stream")
Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = rest.FullRequestBd("POST","/Feeds/2009-01-01",pdfData,sbResponseBody)
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

If (rest.ResponseStatusCode <> 200) Then
    ' Examine the request/response to see what happened.
    Debug.Print "response status code = "; rest.ResponseStatusCode
    Debug.Print "response status text = "; rest.ResponseStatusText
    Debug.Print "response header: "; rest.ResponseHeader
    Debug.Print "response body: "; sbResponseBody.GetAsString()
    Debug.Print "---"
    Debug.Print "LastRequestStartLine: "; rest.LastRequestStartLine
    Debug.Print "LastRequestHeader: "; rest.LastRequestHeader
End If

' Examine the XML returned in the response body.
Debug.Print sbResponseBody.GetAsString()
Debug.Print "----"
Debug.Print "Success."