Data Warehouse API doesn't return report file to FTP

damirm48879896

16-09-2020

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
105014906Sep 16, 2020 8:00:00 PM GMT+00:00Sep 17, 2020, 4:35:32 AM Greenwich Mean TimeSep 17, 2020, 4:35:33 AM Greenwich Mean TimeWaiting to Send  Sep 1, 2020, 12:00:00 AM Greenwich Mean TimeSep 7, 2020, 12:00:00 AM Greenwich Mean TimeEmail

 

 

 

Accepted Solutions (0)

Answers (0)