financial report not finding data

I try to execute fiancial report with app-connect api using :

--- "method": "get", --- "url":

"https://api.appstoreconnect.apple.com/v1/financeReports?filter%5BregionCode%5D=US&filter%5BreportDate%5D=2022-03&filter%5BreportType%5D=FINANCIAL&filter%5BvendorNumber%5D=XXXXX"

I tried several variations : in reportType I tried FINANCIAL and FINANCE_DETAIL in reportDate I also tried only year 2022 and also 03-2022

whenever I try invalid value - I get error on invalid value, for a specific parameter like this :

--- status: '400', --- code: 'PARAMETER_ERROR.INVALID', --- title: 'A parameter has an invalid value', --- detail: 'Invalid vendor number specified. Try again.', --- source: { parameter: 'filter[vendorNumber]' }

So I know my parameters are valid

But when I execute this I get :

"app connect - exec API - failed on url execution"

--- "id": XXXXXX, --- "status: "404", --- "code: "NOT_FOUND", --- "title":"The request expected results but none were found", --- "detail": "There were no sales for the date specified."

when I look at same date on reports in apple site I do get a report with sales data for same region and dates :

"... 02/27/2022 03/26/2022 gXXXXXe 3 8.49 25.47 USD S 15XXXX8701 geXXXXhs IAY US 9.99 USD 02/27/2022 03/26/2022 gXXXXh 14 8.49 118.86 USD S 15XXXX26 "

is there any idea why the download from site is working , while the api does not ? what am I doing wrong ???

financial report not finding data
 
 
Q