Solved
Data Warehouse API doesn't return report file to FTP
Hi team,
Starting from 7 Sep we stopped receive report files on FTP via DataWarehouse API. The Report.Queue method return report id and status 200, and checking report status show is everything okay but we didn't gen file to FTP. It's reproducing across multiple report suite within different Adobe organizations. However manual upload to FTP via Experience Cloud works fine. Also, I've tried re-send API call from the UI Request Manager but didn't get success. Below you find all the required information about API requests. Please advise asap.
Below my API request
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer 'xxxxxxxx' \
--data-raw '{
"reportDescription": {
"reportSuiteID": "xchmprovtemplcommerce",
"dateFrom": "2020-09-01",
"dateTo": "2020-09-10",
"dateGranularity": "day",
"metrics": [
{
"id": "event1"
},
{
"id": "event2"
}
],
"elements": [
{
"id": "evar1"
},
{
"id":"geocountry"
}
],
"source": "warehouse",
"ftp": {
"host": "xxxxxxxxxxx",
"port": "21",
"directory": "adobe_analytics_test",
"username": "xxxxxxxxx",
"password": "xxxxxxxxxxxxxx",
"filename": "Report_arvato_0915.csv"
}
}
}'
Also bellow info about API request from Datawarhouse -> Manager Request page
Request Description
- Request Name: API Report
- Report Suite ID: xchmprovtemplcommerce
- Report Suite Numeric ID: 300114024
- Segment: None
- Requested By (login): 70ee38a3-a33e-487a-b6cd-9ef0a485c645@techacct.adobe.com
- Contact Name: Analytics API Team
- Contact E-Mail:
- Date Type: range
- Time Granularity: day
- Data Breakdowns:Internal Promotions (eVar1)
- Data Metrics:Registrations
Request HistoryRequest IDDate ScheduledDate StartedDate CompletedStatusStatus DescriptionCurrent TaskFromToDelivery
| 105014906 | Sep 16, 2020 8:00:00 PM GMT+00:00 | Sep 17, 2020, 4:35:32 AM Greenwich Mean Time | Sep 17, 2020, 4:35:33 AM Greenwich Mean Time | Waiting to Send | Sep 1, 2020, 12:00:00 AM Greenwich Mean Time | Sep 7, 2020, 12:00:00 AM Greenwich Mean Time |