Azure Log Queries

API APIM Azure

a. Find the requests based on the url, Get the request body

requests
| where timestamp >= ago(2d) and timestamp < startofday(now())
| where url contains "<<url_search>>"
| project timestamp, id, name, url, resultCode, 
    customDimensions["Request-Body"], 
    customDimensions["Response-Body"]
| order by timestamp desc


b. Find the requests and body based on the url pattern and Request Body contents

requests
| where timestamp > ago(7d)
| where url contains "<<url_search>>"
| extend ReqBody = tostring(customDimensions["Request-Body"])
| extend ResBody = tostring(customDimensions["Response-Body"])
| where ReqBody contains "<<request body search string>>"
| project timestamp, id, name, url, resultCode, ReqBody, ResBody
| order by timestamp desc