Hi there,
when I am trying to query dev's analytics data I am getting the follwing error :
{
"message": "Error in query parsing, metric has to have a aggregate function",
"contexts": []
}
But with the same query in prod getting the following response:
{
"environments": [
{
"metrics": [],
"name": "production"
}
],
"metaData": {
"errors": [],
"notices": [
"query served by:07e9f65b-ab66-4da5-96c5-9ad665a05412",
"source dw:rse2redshift001.ap-sy.4.apigee.com",
"Table used: orgname.production.fact"
]
}
}
@aagrawal , What's the API call you are making ?
Hi @Anil Sagar
https://api.enterprise.apigee.com/v1/o/{my_org}/environments/dev/stats/sno,instiName,card,rateplan?select=sum(message_count),caic&timeRange=06/23/2016%2021:00~06/27/2016%2020:54&billto=CSP&filter=(card%20notin%20'VISA','MASTER'%20and%20response_status_code%20in%20'201'%20and%20request_verb%20in%20'POST'%20and%20apiproxy%20in%20'API1','API2')&sort=ASC&sortby=sno&limit=5000