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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Data Warehouse API doesn't return report file to FTP

damirm48879896
Level 1
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
damirm48879896
Correct answer by
Level 1
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
Khurshid_Alam
Employee
Employee

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.

damirm48879896
Correct answer by
Level 1
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