Management API - get metrics - not returning all data

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

0 1 250
1 REPLY 1

you should raise a request to APIGEE support to get this investigated.