amzn / selling-partner-api-models

This repository contains OpenAPI models for developers to use when developing software to call Selling Partner APIs.
Apache License 2.0
612 stars 739 forks source link

Please add postedAfter-postedBefore params to /finances/v0/financialEventGroups/{eventGroupId}/financialEvents #2317

Closed nafberger closed 9 months ago

nafberger commented 2 years ago

a lot of people poll the finance API by eventGroupId which corresponds to an amazon settlement report.

those reports stay open for 2 weeks and new transactions get posted to them, if someone wants to get the bew stuff he has to be able to filter by postedAfter-postedBefore justlike it is is the listFinecialEvents call. this is very important

github-actions[bot] commented 2 years ago

This is a very old issue that is probably not getting as much attention as it deserves. We encourage you to check if this is still an issue after the latest release and if you find that this is still a problem, please feel free to open a new issue and make a reference to this one.

theunixbeard commented 1 year ago

We have this issue too at Empire Flippers.

It's the same issue as the following other open issues:

Everyone's goal is to recreate the "Date Range" reports as seen in Seller Central, going back 2 years as was possible with MWS.

In the Date Range reports there are 2 dimensions by which we split up the finance data, by month and by marketplace.

As explained in this issue: https://github.com/amzn/selling-partner-api-models/issues/412

There are fees like Adjustments, Service Fees, etc which have no identifying information when returned by the Finances API.

In MWS you could implicitly assign a given fee to a specific month / marketplace by querying with BOTH FinancialEventGroupID (e.g. the Marketplace, Spain vs France vs Netherlands) AND postedAfter-postedBefore (set to the start/end of a given calendar month).

Then, if a fee was returned by the API, you knew what month/marketplace to assign it to, even though the XML/JSON itself didn't contain this info.

However, with SP API we can no longer query the API by BOTH FinancialEventGroupID AND postedAfter-postedBefore, but ONLY one of the two.

The other approach, querying for this data via the Reports API rather than the Finances API, is also deprecated in SP-API: https://github.com/amzn/selling-partner-api-models/issues/1555

Counting this issue, that's 5 open issues regarding the same problem...

Obviously we brought this issue up with Amazon Support many times, but in each ticket they simply say they'll pass the info along and nothing gets done. Example case IDs include: 9776857691, 9776768131, 9562103261

I guarantee if Amazon doesn't fix this issue or delay the December 31st deadline for turning off MWS for the Financial Events API that many, many companies reporting use-cases will be broken.

@nafberger I assume that you still have this problem as well?

CC @chapmanjw @sungolivia @jevoniuk can any of you please give us some insight into this important issue?

tspicer commented 1 year ago

@theunixbeard We have also observed the refund information is always NULL. It is not clear if this is an API issue, a documentation issue, or something we are doing incorrectly on our end (maybe it is all three).

ynaft commented 1 year ago

@theunixbeard We still face the same issue, and raised a ticket with Amazon Support.

histonedev commented 1 year ago

@theunixbeard We still face the issue. They just pass along the info to their team and nothing gets done after many support tickets over last 18 months.

Now, they are not even replying to deadline extension requests. Few of our most important features are at stake here.

Yvan8 commented 1 year ago

Is there a new solution, big shots

napter commented 1 year ago

Does anyone from Amazon read /respond to these issues?

github-actions[bot] commented 9 months ago

This is a very old issue that is probably not getting as much attention as it deserves. We encourage you to check if this is still an issue after the latest release and if you find that this is still a problem, please feel free to open a new issue and make a reference to this one.

github-actions[bot] commented 9 months ago

closed for inactivity