Analytics queries

[API-Evangelist]

Looking for some basic analytics management api or some other way to fetch below data.

Developer Name, API used, Developer Contact, When they were enrolled
Developer Name, API Used, # of transactions in last 30 days, Request Source Ips
Transaction volume per client per api for every hour. We want to see if there is any anomaly.

How can we schedule daily reports(we see its not available)? We are using on-prem 4.16.09.

Is there a work around for scheduling daily reports?

Thanks.

[spadmanabhan]

@vinay you can use Apigee Management or Analytics APIs using "cron" like job as desired to pull data appropriately.

Your first request is a management API call to get the developer information.

Your second request is an analytics API call with aggregation on sum(traffic).

Your dimensions will be Developer Name, API Used, client_ips, time=month

Your third request is an analytics call (run every hour)

sum(traffic) with dimensions client_ip, time=hour, apiproxy

[API-Evangelist]

Do you have a sample analytics api call to share? (mostly looking for 2nd and 3rd requests)

[spadmanabhan]

@vinay, here is the document reference

http://docs.apigee.com/analytics-services/reference/analytics-command-reference

An example API call will be for timeRange from 09/01/ to 10/01 (one month)

"https:<mgmt-url>/v1/organizations/<org>/environments/<env>/stats/developer,apiproxy,client_ip?select=sum(message_count)&timeRange=09%2F01%2F2017+0:0:00~10%2F01%2F2017+0:0:00&timeUnit=month"

More examples are present in other community articles. Pls. take a look.