Perfect answer Denied5! This really saved my day.
To add a small note fore everyone running into the same issue:
- The mapping template should be for application/json, as AWS defaults to this template.
- If any custom query mappings were set in the Integration Request; these should be removed. Otherwise, the parameters will be mapped to both the URL and the body. This will cause an error.