Getting Parsing error while querying Analytics

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" ] } }

1 2 116
2 REPLIES 2

@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