I need a web app that allows us download amazon Selling Partner and Amazon Ads API Reports on a daily basis (we haver over 100 clients so we need to connect to multiple accounts).
We expect to achieve this by directly connecting us through the Selling Partner API and Amazon Ads API.
Once the data is collected on a daily basis, it should be saved in a database so that we can connect our Power Bi and Excel reports to feed and update them.
The process should work like this:
1. We get a new customer and we ask him/her to authorize us as a developer so that we can get the order and ads data.
2. The data is downloaded and then saved in our database
3. We consume this in Power Bi and Excel
After the project is delivered, we expect to grow and maintain this with developers in house. This requires that the project runs within our amazon developer credentials and that we keep all the code. We need independecy after the project is delivered.