¿Is there an endpoint to get the data from the transaction view??

[felduque557]

I currently have a public developer profile and I need to manage transactions for each store, service fee, Refund, etc. But I can't find any endpoint to provide me with this information, could someone help me?

[rugved1991]

Hi @felduque557,

Currently it is not possible to create a custom date range transaction report through the API. But, you can create a report on the UI and then access it through the getReports operation of Reports API.
You can also take a look at the Finance API to get settlement information through the API.

Best,
Rugved
Solutions Architect, SP-API

[yohairosen]

Thank you @felduque557 , can you share the specific report type you are using?

[felduque557]

This type of report is the closest I have found to delivering amazon fees, removals, refunds and orders. I hope you find it useful, I had a hard time finding it.

https://sellingpartnerapi-na.amazon.com/reports/2021-06-30/reports?reportTypes=GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2&marketplaceIds=ATVPDKIKX0DER&createdSince=2024-02-01T00:00:00

Reportype: GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2

Note: This type of report cannot be created, nor can schemas be created, it is generated automatically by amazon with a 90 day history, divided into 14 day reports.

[np-data]

Hi @felduque557
I believe you are right here. GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2 is the closest to manual transaction report under payments reports repository.

But I would like to highlight that the report generated using API does not:

1. separate standard order and invoice order data (I believe invoiced orders have a null transaction type).
2. For any given week, I'm seeing very less data in the API report than manual.

Would appreciate your response if you're observing the same differences.

[felduque557]

Hi @felduque557 I believe you are right here. GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2 is the closest to manual transaction report under payments reports repository.

But I would like to highlight that the report generated using API does not:

1. separate standard order and invoice order data (I believe invoiced orders have a null transaction type).
2. For any given week, I'm seeing very less data in the API report than manual.

Would appreciate your response if you're observing the same differences.

Hi @np-data
On the first point I really agree, standard and invoiced transactions go together. It is really complicated to manage the invoiced ones, so it is actually money that the store has not yet received in some cases. Even more limiting is that we can only access a 90 day history.

Regarding the second point for now I have not encountered that problem since I only store the transactions and then make use of it.

It would be nice if at some point the amazon team would allow us to generate the report by date range so we could have the information up to date and not wait 14 days to update it. As well as the report of refunds and returns.

[np-data]

That makes sense. Thanks!