Five Number tools
Five Number tools › Parse JSON Schema Generator

Power Automate Parse JSON Schema Generator

Paste a sample JSON payload, an HTTP response, a webhook body or a SharePoint item, and get a clean schema for the Parse JSON action. It marks fields that can be null as null-safe and only lists a property as required when every record has it, so your flow does not break on the next run.

The JSON you paste is never sent anywhere. The schema is built in your browser.
Try an example (click to load it into the box)
Schema

Paste this into the Schema box of a Parse JSON action, or the Response Body JSON Schema box of a Response action. Power Automate uses the same Draft 4 JSON Schema for both, so the output is identical.

How this schema differs from "Generate from sample"

  • Null-safe by default: Power Automate's built-in generator types a field by the sample value only, so a field that is null on a later run fails validation. This tool allows null wherever your sample shows it.
  • Smarter required list: it reads every object in an array, not just the first, and marks a property required only when all of them have it. Fields that appear in some records stay optional.
  • Whole numbers use integer, decimals use number, matching how Power Automate types values. A field seen as both is widened to number.
  • Everything runs in your browser. No payload is uploaded, which matters when the sample is a real response with data in it.

Disclaimer

These tools are provided free and as-is, with no warranty of any kind. Results are best-effort and can be incomplete or out of date, so always verify them against official Microsoft documentation before you act on them.

fivenumber tools is an independent project and is not affiliated with, sponsored by, or endorsed by Microsoft. Microsoft, Microsoft 365, SharePoint, Entra, OneDrive, Power Automate and Copilot are trademarks of the Microsoft group of companies.

Send feedback

Found this useful, or hit a snag? Tell me what worked and what would make it better. Your note comes straight to me.

Thanks, your feedback was sent.

I read every note. If you left your email, I may follow up.