Extracting amo prefixed elements and metric from the Analytics API gives API Error [500]: Warehouse request failed
The body (payload) of the request is as follows:
Note that the ReportSuite is obfuscated.
{
"reportDescription": {
"metrics": [
{
"id": "amo_impressions"
},
{
"id": "amo_clicks"
},
{
"id": "amo_cost"
},
{
"id": "amo_conversions"
}
],
"source": "warehouse",
"elements": [
{
"id": "amo_cid"
}
],
"reportSuiteID": "txxxxxx-xxxxxx-xxxxxxl",
"dateGranularity": "day",
"dateTo": "2016-12-08",
"dateFrom": "2016-12-07"
}
}
Logged = True 2016-12-08_211010: Request Successful Logged = True 2016-12-08_211010: Polling for reportId 1720189127
Logged = True 2016-12-08_211010: Getting Page 1 of Report Adobe_Analytics_Metrics
Logged = True 2016-12-08_211016: Response [400]: Report not ready waiting for 2.7339381395 second
Logged = True 2016-12-08_211023: Response [400]: Report not ready waiting for 4.51874212309 seconds
Logged = True 2016-12-08_211032: Response [400]: Report not ready waiting for 6.27918222899 seconds
Logged = True 2016-12-08_211043: Response [400]: Report not ready waiting for 8.34212240084 seconds
Logged = True 2016-12-08_211056: Response [400]: Report not ready waiting for 10.4209678434 seconds
Logged = True 2016-12-08_211114: Response [400]: Report not ready waiting for 12.7341329903 seconds
Logged = True 2016-12-08_211131: Response [400]: Report not ready waiting for 14.7739198844 seconds
Logged = True 2016-12-08_211150: Response [400]: Report not ready waiting for 16.6802017544 seconds
Logged = True 2016-12-08_211211: Response [400]: Report not ready waiting for 18.8112416824 seconds
Logged = True 2016-12-08_211234: Response [400]: Report not ready waiting for 20.4669947937 seconds
Logged = True 2016-12-08_211257: Response [400]: Report not ready waiting for 22.358385427 seconds
Logged = True 2016-12-08_211324: Response [400]: Report not ready waiting for 24.9906917413 seconds
Logged = True 2016-12-08_211353: Response [400]: Report not ready waiting for 26.5505271272 seconds
Logged = True 2016-12-08_211423: Response [400]: Report not ready waiting for 28.1055871645 seconds
Logged = True 2016-12-08_211456: Response [400]: Report not ready waiting for 30.8292791309 seconds
Logged = True 2016-12-08_211532: API Error [500]: Warehouse request failed