Index

JSON Path Evaluator

Free tool to validate and extract the matching piece of the JSON data against the input expression. JSON Path syntax should be given in the format $.< parameter name > and the result object that matches the given parameter name will be displayed in the output result box. Refer the JSONPath example for usage.

Input JSON
Output
Input Path Expression

JSON Path Examples

Following are few example jsonpath expressions and results for the above sample json data

JSONPath Expression Description Result
$ Select the root element
$.address.city Select the value of 'city' element which is the direct children of 'address' element
$..type Select the value of all the 'type' elements in the input json
$.address.length() Select the length of the 'address' element
$..number.max() Select the maximum value of 'number' element
$..* Select all the elements and its value
$.phoneNumbers[1] Select the 2nd value from 'phoneNumbers' array
$.phoneNumbers[?(@.number)] Select the 'phoneNumbers' element if it have 'number' element within it

Related System Administrator and Network Tools



Thread dump analyzer
Analyze a JVM thread dump and identify deadlocks.
Regex Parser
Validates and parses the input string as per the given regular expression.
Timestamp converter
Converts Unix / Epoch timestamp into GMT and other readable format.
JSON Formatter
The JSON Formatter and Validator helps in formatting JSON data.
JSON Path Evaluator
Validates JSON data against given expression.
JSON Generator
Generates JSON code based on given JSON template.
JSON Minifier
Minify your JSON code, for reduced size and less data transfer.
JSON Beautifier
Convert minified JSON code into human understandable format.
JSON to Protobuf creator
Converts JSON data to Protocol Buffer (Protobuf) data format.
JSON to JAVA
Converts JSON schema to java object.
JSON to XML
Converts JSON data to XML data.
JSON to YAML
Converts JSON data to YAML data.
JSON to PHP
Convert JSON data to PHP data.
JSON to C#
Convert JSON data to C# data format.
Xpath Evaluator
Validates XML data against the given expression.
XML Formatter
The XML Formatter helps in formatting XML data.
XML to XSD
Convert XML data to XSD equivalent.
XML to YAML
Convert your XML data to its equivalent YAML format.
XML to JSON
Converts XML data to JSON data.
SQL Formatter
The SQL Formatter helps in formatting SQL statements.
SQL to MongoDB
Convert SQL query to NoSQL (MongoDB) query.
INI to JSON
Converts Microsoft Windows .ini data to JSON data.
INI to XML
Convert INI files to its equivalent XML format.
INI to YAML
Transform your INI file contents to its equal YAML format.
CSV to JSON
Convert your CSV data into its respective JSON format.
CSV to XML
Convert your CSV data into its respective XML format.
CSV to YAML
Convert your CSV data into its respective YAML format.
CSV to SQL
Convert CSV data to SQL query.