JSON queries

Runs expressions over your own JSON: field paths, array indexes and filters, a wildcard for all values, object and array construction, variables, ranges, string concatenation and dozens of functions from count, sum, keys and sort to substring, replace and merge. The result can be downloaded as JSON.

Fill in the fields, run the tool and review the result. Your input is not added to a public page. Use the learning mode for calculation details.