Query Workbench
Write a JSONPath or JMESPath query, pick the language you meant, and see exactly what it computes.
ইনপুট
সিনট্যাক্স রং বন্ধ।
Result
সিনট্যাক্স রং বন্ধ।
ফলাফল এখানে দেখা যায়।
সম্পূর্ণরূপে আপনার ব্রাউজারে চলে।
এই সরঞ্জাম সম্পর্কে
JSONPath and JMESPath answer different questions, so this tool never guesses which one a query is written in, the switch above the query box picks the language. JSONPath finds locations inside a document: every match keeps the shape it already had. JMESPath computes a new value instead: a pipe, a multi-select or a function call can reshape the data into something the document never literally contained, a list of just the fields you asked for, a single number, a document sorted by a field that only appears buried three levels down. This page implements the whole JMESPath 1.0 language, including every function in its standard library, listed below. It does not implement JSONata or jq-style expressions, both of which are their own considerably larger languages, and says so rather than quietly falling back to something else. The JSONPath mode reuses the same engine as the dedicated JSONPath Tester on this site; reach for that tool instead when you want to click a match and see it highlighted inside your document, since this page always prints a computed result rather than a browsable list of locations.
কিভাবে ব্যবহার করবেন
- Paste your JSON into the editor, or load the sample.
- Choose JSONPath or JMESPath, then write a query or press one of the examples.
- Read the result on the right. A JMESPath query computes a new value; a JSONPath query lists every match.
JMESPath functions
The whole standard library, the same 25 functions the specification defines.
| abs(number) | Absolute value. |
| avg(array) | Average of the numbers, null if empty. |
| ceil(number) | Rounds up. |
| contains(subject, value) | True if the string or array contains it. |
| ends_with(string, suffix) | True if the string ends with it. |
| floor(number) | Rounds down. |
| join(glue, array) | Joins strings with a separator. |
| keys(object) | The object's own keys. |
| length(value) | Character, element or key count. |
| map(&expr, array) | Applies an expression to every element. |
| max(array) | The largest value, null if empty. |
| max_by(array, &expr) | The element with the largest computed value. |
| merge(object, ...) | Shallow merges objects, left to right. |
| min(array) | The smallest value, null if empty. |
| min_by(array, &expr) | The element with the smallest computed value. |
| not_null(value, ...) | The first argument that is not null. |
| reverse(value) | Reverses a string or an array. |
| sort(array) | Sorts numbers or strings, ascending. |
| sort_by(array, &expr) | Sorts by a computed value, stably. |
| starts_with(string, prefix) | True if the string starts with it. |
| sum(array) | Adds up the numbers. |
| to_array(value) | একটি অ্যারে নন এমনকে অ্যারেতে জড়ো করে, একটি অ্যারেকে যেমন আছে তেমন রাখে। |
| to_string(value) | The value as a string. |
| to_number(value) | মানটি একটি সংখ্যা হিসেবে, এটি সংখ্যা হিসেবে পড়া না গেলে null। |
| type(value) | The JMESPath type name. |
| values(object) | The object's own values. |
Need the full JSONPath syntax table, or want to click a match to see it highlighted in your document? Use the dedicated JSONPath Tester instead.