How to track API Usage by the Requestor?

[Community Alums]

Hello,

There is a nice dashboard located here:  System Web Services > Rest & Soap API Analytics > Usage by Requestor

It takes us to a dashboard with a drop-down to filter by the requestor, such as MID Server, or any other user account that uses the API.  It reports using the table API Transaction Stats (sys_api_stats).  I wanted to make my own report that shows multiple requestors side-by-side, but when I look at that table, I don't see the Requestor, and all records are created/updated by either Admin, or Guest.  Is there a way I can find the field that the drop down is using to filter that table by the requestor, such as MID Server?

Here is the dropdown on the Dashboard

Here are the available columns on the API Transactions Stats table

[Harshad Wagh · Accepted solution]

Hi Dustin,

The fact table behind this dashboard is sys_api_stats_requestor, this will help you to build your custom one.

hope this helps!

Thanks

Harshad