Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Coffee Break: Join us on Wednesday, April 5th at 10am PT to chat with Ben Gaines, Director of Product Management for Adobe Analytics. Ben will be online to answer your Analytics and Adobe Summit questions.
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

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