setup logger for most frequent queryparam use by consumer

[atulranjansit]

I have setup logger which is capturing the queryparam but now the requirement is to setup logger for most frequent queryparam use by consumer.

is there anyway by which we can achieve and identify the most frequent queryparam use by consumer in Apigee.

Any help would be highly apricated.

[dchiesa1]

The most frequently used VALUE of a known query param? Or the most frequently used queryparam, by name?

If I were solving this problem, I would use custom analytics. Log the query param, either the value or the name, in a custom ax field. Then Apigee will collect the information, and you can get charts on that dimension.

This page provides a good overview of how it works.

[atulranjansit]

Hi Dino

Thanks for your reply,

It's most frequently used queryparam by name I have used message logging policy to capture all queryparam now I have to make a report out of that and that report will contain maximum times used queryparam.

Kindly suggest if u have any solution link.

Regards

Atul

[#4]

I would suggest to use statistics collector policy for storing the query params to analytics and then do postgres query or management api call to get the one which is used mmaximum times.

[atulranjansit]

Thanks,do u have any document regarding that

[#6]

Statistics collector : https://docs.apigee.com/api-platform/reference/policies/statistics-collector-policy#:~:text=using%20....

Api calls : https://docs.apigee.com/api-platform/analytics/use-analytics-api-measure-api-program-performance

Postgres query is simple SQL query you can do in postgres server.