Analytics API for Realtime Query

Not applicable

Hi folks - Private Cloud OPDK 1504 installation here.

Do you have an AX api to query real time analytical data? I tried the following but it seems even that does not provide real time data.

{{mgmt-server}}/v1/o/{{org}}/environments/{{env}}/stats/apis/{{apiname}}?select=sum(message_count)&timeRange=9/17/2015%2014:00~09/17/2015%2014:01&timeUnit=minute

0 5 452
5 REPLIES 5

@Deepak Bhardwaj can you explain your requirement? The analytics data is flowing in as soon as possible into the databases so that you can query them. The apis allow you to pick a time range and you can customize that time range to include the most recent data.

The queries do need to be submitted to get the results. They are not standing queries acting on the data coming in.

I am trying to query the data in real time (minute) for some tests. Does it take more than a minute for data to aggregate in QPID and persist to PostGres?

The data flows to postgres within a minute unless there is a backup somewhere. This particular query may use one of the two aggregate tables that are configured on OPDK in which case there will be a delay for the aggregate table to have the updated results. The delay is usually within 5 minutes.

Is there an api to query the data before it gets into aggregate tables?

your API is correct, you could get analytics data upto last minute - just try for last 5 minute [for eg, 9/17/2015%2014:00~09/17/2015%2014:05]interval to make sure you have some data available,