I recently had a call with a customer where we were troubleshooting a Power Automate flow. The flow was processing output from an HTTP action where we were getting some JSON data from a remote API. There was a ‘Parse JSON’ action that was designed to give a shape to the data coming out of the HTTP response, but unfortunately we were getting a generic “ValidationFailed”.
That error would probably be OK if we had just a handful of properties on a handful of records, but this was a massive array of 20+ properties. Sifting through the response to find the validation failure was going to be a challenge. So, I asked Claude to build me a tool and this is the result:
It can identify which property is not matching up against the schema allowing you to either adjust the schema or fix the data. This saves tons of time looking property by property over loads of records.
Get the tool here: