Hi team,
I am using the Apigee management API to get metrics from gateway. However, I found the aoi call does not return a full set of data. There are some timestamp missing data.
See below curl query for example, I am trying to get 60 minutes of sum(message_count) from each API Proxies, split by minute. In theory, I should have 60 values of each API Proxies. However, I only get 40.
See below curl request:
curl -H "Content-Type:application/json" "https://api.enterprise.apigee.com/v1/organizations/<my-organization>/environments/test/stats/apiproxy?select=sum(message_count)&timeUnit=minute&timeRange=07/19/2019%2010:00~07/19/2019%2011:00&tzo=780&_optimized=js" -n ~/.netrc
See below response:
{ "Response" : { "TimeUnit" : [ 1563487140000, 1563487080000, 1563487020000, 1563486960000, 1563486900000, 1563486840000, 1563486780000, 1563486720000, 1563486660000, 1563486600000, 1563486540000, 1563486480000, 1563486420000, 1563486360000, 1563486300000, 1563486240000, 1563486180000, 1563486120000, 1563486060000, 1563486000000, 1563485940000, 1563485880000, 1563485820000, 1563485760000, 1563485700000, 1563485640000, 1563485580000, 1563485520000, 1563485460000, 1563485400000, 1563485340000, 1563485280000, 1563485220000, 1563485160000, 1563485100000, 1563484800000, 1563484740000, 1563484440000, 1563483840000, 1563483780000 ], "metaData" : { "errors" : [ ], "notices" : [ "Source:Postgres", "Table used: edge.api.faxgroupusenondn014.agg_api", "PG Host:ruappg0ro.apigeeks.net", "query served by:ca7fb067-456c-42d4-834e-a34eb4e1fb3c" ] }, "resultTruncated" : false, "stats" : { "data" : [ { "identifier" : { "names" : [ "apiproxy" ], "values" : [ "google" ] }, "metric" : [ { "env" : "test", "name" : "sum(message_count)", "values" : [ 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 0.0, 9.0, 3.0 ] } ] }, { "identifier" : { "names" : [ "apiproxy" ], "values" : [ "helloworld" ] }, "metric" : [ { "env" : "test", "name" : "sum(message_count)", "values" : [ 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 2.0, 0.0, 1.0, 0.0, 6.0 ] } ] } ] } } }
Take part of the timeunit response for example:
1563484740000, 1563484440000, 1563483840000, 1563483780000
We can see a large gap between 1563484440000 and 1563483840000
Any idea how to fix this?
Many thanks in advance.
Cheers,
Vincent
you should raise a request to APIGEE support to get this investigated.
User | Count |
---|---|
5 | |
2 | |
1 | |
1 | |
1 |