#Mws scratchpad product conditions how to#

In below steps we will use ZappySys ODBC PowerPack so make sure it’s installed first.

#Mws scratchpad product conditions how to#

Now let’s look at step by step instructions on how to call Amazon MWS API and then import into Power BI.

How to get Amazon MWS developer keys and know your Merchant ID (i.e. Using these API you can read or write data from your Seller account and integrate it inside your own Systems (e.g. You can setup your entire online store / inventory using admin interface.Īmazon Marketplace Web Service (Amazon MWS) is an integrated web service API that helps Amazon sellers to programmatically exchange data on listings, orders, payments, reports, and more. If you want to sell something on Amazon you can use their e-commerce platform with some monthly fee. You will also need Power BI Desktop (FREE) installed.You are already registered as a Developer and you obtained AWS Access Key / Secret Key and Seller ID (i.e.Active Amazon Seller Account needed (Make sure you have Professional Plan or higher (around $39/month) to call Amazon MWS API).We will read data from Amazon MWS API using ZappySys XML Driver which is part of ODBC PowerPack. To learn more about how to consume Amazon MWS data in ETL using SSIS check this article.

Now let’s continue on that and learn how to import Amazon MWS data in Power BI using XML driver. In our previous blog we saw how to call REST API in Power BI to import data from JSON based REST API services. Please visit this page to see all Pre-Configured ready to use API connectors which you can use in SSIS API Source / SSIS API Destination OR API ODBC Driver (for non-SSIS Apps such as Excel, Power BI, Informatica). You can still use steps from this article but if you are new to API or want to avoid learning curve with API then use newer approach. UPDATE: ZappySys has released a brand new API Connector for Amazon MWS Online which makes it much simpler to Read/Write Amazon MWS Data in ODBC compared to the steps listed in this article.