CloudWatch Logs Insights query for API Gateway

APIGateway.md

Req id:

parse @message '(*) *' as reqId, message
| filter reqId like "c19dd3fc-5f27-11e9-a823-930d231e2ab8"
| sort @timestamp asc
| limit 50

Status code:

parse @message '(*) *' as reqId, message
| filter message like /Method completed with status: \d\d\d/
| parse message 'Method completed with status: *' as status
| filter status != 200
| sort @timestamp asc
| limit 50

GW Response:

parse @message '(*) *' as reqId, message
| filter message like /^Gateway response type/
| parse message 'Gateway response type: * with status code: *' as resType, status
| filter status != 200
| sort @timestamp asc
| limit 50