Kusto Queries

Get API Request Logs for 3rd Party Applications Calling a Specific Endpoint

union traces
| where timestamp > datetime("2022-12-13T18:41:48.796Z") and timestamp < datetime("2023-03-14T17:41:48.796Z")
| where customDimensions["LogType"] == "API Request"
| where customDimensions["ApplicationID"] !in ("1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16")
| where customDimensions["RequestPath"] == "/api/AccountUsage"
| order by timestamp desc
| take 100