MWS Products API to Excel


#1

Good Morning,

I am trying to determine how to pull the estimated FBA fees into excel via the MWS API. I do have working code via the Scratchpad but haven’t been able to figure out how to correctly do this in excel.

Is there a guide on how to do this? Based on the information I’ve seen online the main issue seems to be signing the request as well as writing the VBS code to post the request correctly.

Thanks,


#2

Is this something that is possible to do?


#3

Creating custom code via VBS might pose to be an issue if Amazon decides to implement any changes to the API. I would recommend using one of their client libraries here https://developer.amazonservices.com/tools. I know that both Java and PHP have some type of support for creating excel files or inserting information into excel files. I have no personal experience with C# by I suspect it would also have support to do this.