Skip to main content
Version: 1.0.0

Pick the fields you need

JSON files often contain more data than you need. JQL can create a clean result with just the useful fields.

Source JSON

customers.json:

[
{"id": 1, "name": "Amina", "email": "amina@example.com", "city": "Berlin"},
{"id": 2, "name": "Jon", "email": "jon@example.com", "city": "London"}
]

Query

jql "select {name, email} from 'customers.json'"

Result

[
{"name": "Amina", "email": "amina@example.com"},
{"name": "Jon", "email": "jon@example.com"}
]

The result keeps every customer but includes only name and email. This is useful when preparing a smaller API payload or sharing data without unrelated fields.