How to get (aggregate) analytics on traffic to a request path that contains a variable

[sharped]

Hi,

I'm looking at improving the analytics that we generate about usage of our APIs. One thing that I want to be able to do is to see the profile of usage of out endpoints for a customer. I have set up of the Custom Report to do that but I have a question about how I improve the results. A number of our requests have a structure which includes a variable, eg:

https://api.rsc.org/compounds/v1/records/{recordId}/details

Where recordId is a variable and might be one of 70M+ ids.

In the results from my custom report, traffic for each different instance of the details endpoint is recorded separately. However, I don't care about the individual instances of these calls but I would like to know the cumulative number of requests to the details endpoint.

eg. rather than having:

Request Path	Sum of Traffic
https://api.rsc.org/compounds/v1/records/1/details	2
https://api.rsc.org/compounds/v1/records/5/details	4
https://api.rsc.org/compounds/v1/records/265/details	1
https://api.rsc.org/compounds/v1/records/500000/details	11
https://api.rsc.org/compounds/v1/records/2700000/details	1

I get:

https://api.rsc.org/compounds/v1/records/*/details sum of traffic = 19

Is there a way to specify this in the Custom Reports interface or do I have to export all of the data and then perform aggregation in external data processing?

Thanks,

Dave

[rohithapigee]

Hi Dave,

Have you tried using the Filter condition and use a request path as a dimension set condition "eq 'https://api.rsc.org/compounds/v1/records'"