Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

It would be great to see the use cases expanded for Amazon Selling Partner API. It's not possible to get any info about sessions or conversion rates which are two important metrics for our business. I might have to explore another solution to get this data out.

<@U0397RTLTFA> fyi maybe it’s possible to create a quick start?

Screen Shot 2024-04-04 at 10.52.13 AM.png

<https://docs.airbyte.com/integrations/sources/amazon-seller-partner?__hstc=260470301.1f549eb4df93c051af4816f33425a6f2.1712235730499.1712235730499.1712235730499.1&amp;__hssc=260470301.3.1712235730499&amp;__hsfp=1745393781&amp;_gl=1*t6x5au*_gcl_au*ODk1Mzk2NzI4LjE3MTIyMzU3Mjk.#:~:text=Sales%20and%20Traffic%20Business%20Report%20(incremental)|In this documentation> I see it references Sales and Traffic Business Report but I don't see it in the cloud UI. Am I missing something?

This looks like exactly what I need :pray:

The reports are active in the connector <https://github.com/airbytehq/airbyte/blob/37884415bd37f8c87a7b05b38224f8cefd6688e3/airbyte-integrations/connectors/source-amazon-seller-partner/source_amazon_seller_partner/streams.py#L877-L891|https://github.com/airbytehq/airbyte/blob/37884415bd37f8c87a7b05b38224f8cefd6688e3[…]e-amazon-seller-partner/source_amazon_seller_partner/streams.py>
Most likely your account doesn’t have the right permission to retrieve these reports :disappointed:

Hmmm, I had one of our founders connect his Amazon account. I'm pretty certain he has the right permissions but I'll sync up and see. Thanks!

<@U01MMSDJGC9> I confirmed his account is the owner account so there shouldn't be any issues with permissions on our end. Is there anything else you recommend looking into that will allow me to access the reports?

I had an issue a few months ago using Amazon Seller Partner, doing the request manually helped a lot (there some improvements we must do in the error messages)

When you say do the request manually, do you mean using the builder?

Can you provide more context? Is there documentation or anything you can send me? I'm not super technical in this space yet and just starting to use ELT programs. Trying to automate this data out of Amazon as easily as I can

The idea is to make a manual request: <https://developer-docs.amazon.com/sp-api/docs/reports-api-v2021-06-30-tutorial-request-a-report>

Probably Amazon will return you the error why you can’t generate that report, if you’re able to generate it than… we need to investigate what is happening

Okay, I will look into Postman!

I did set up that report in Fivetran using the same account without any issues, if that helps.

<@U01MMSDJGC9> Is there any way you folks can further investigate what's happening with Amazon? I'm having troubles connecting with Postman and we're confused how this will get to the bottom of the issues. We connect to Airbyte using the seller central login while with Postman we need to create an app, users, etc. which could end up having differences than the user we're logging in with for Airbyte.

We've confirmed we have the right permissions and the account we're using is the owner account. I have also confirmed this report ran without any issues from Fivetran so it doesn't seem like a permissions thing. We'd like to use Airbyte but need this report from Amazon.

<@U01MMSDJGC9> FYI I was told this by the support team:

"The GET_SALES_AND_TRAFFIC_REPORT stream has been disabled in Cloud per this PR. 
 
It looks like it was removed to solve an ongoing issue and the engineering team is working on a solution."