Expand my Community achievements bar.

SOLVED

Data Warehouse API doesn't return report file to FTP

Avatar

Level 1

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

 

 

 

1 Accepted Solution

Avatar

Correct answer by
Level 1

Hi Khurshid_Alam

 

Thanks for looking here. The problem has been resolved by the dev team within Github issue https://github.com/AdobeDocs/analytics-1.4-apis/issues/94

View solution in original post

2 Replies

Avatar

Employee Advisor

The API request you pasted, does not show correctly at my end. Perhaps, I have the font missing. Also, the request IDs can be checked by the Customer Care team as well as the debug logs. I would advise reaching to Customer Care team for help.

Avatar

Correct answer by
Level 1

Hi Khurshid_Alam

 

Thanks for looking here. The problem has been resolved by the dev team within Github issue https://github.com/AdobeDocs/analytics-1.4-apis/issues/94