How to check CSV column rules in Obsidian
Check parsed CSV fields against rules you choose, then record errors by row and column.
How to query JSON files in Obsidian
Use JMESPath to select fields or filter records in a JSON file. As of October 2026, Obsidian code blocks display code; Local JSON Queries evaluates expressions against vault files.
Background
Start with the input structure before writing a filter. A rows array needs a different expression from JSONL records that become an array at the root.
2 ways to do it
Learn expressions in the JMESPath tutorial
Use the official tutorial’s interactive examples to practice field selection, projections and filters with its sample JSON. For a rows array,
rows[*].nameselects names.- limits
- The tutorial is a browser exercise rather than a vault file picker. Keep private exports out of an online example.
- source
- JMESPath tutorial
Local JSON Queries from this site
Put the JSON or JSONL file in your vault, enter its path and run
@to inspect its shape. For JSONL records with a name field, try[*].name.For an object with a rows array, use
rows[*].name, then save the file and expression as a named pair. Copy JSON keeps the complete result.- limits
- This version accepts JMESPath only, with a 5 MiB input limit. Display caps do not shorten copied or reported results.
Open larger MIT · no telemetry · core features free
Review the result with Local JSON Queries
Put a JSON or JSONL file in your vault.
Run Open JSON query view from the command palette.
Enter the file path and a JMESPath expression, then select Run query.
Save the pair with a name or select Copy JSON to copy the result.
Common questions
Which expression should I try before filtering?
Use @ to show the input value. Check its field names and array structure before writing a projection.
What does a null result tell me?
A missing field can return null without a parse error. Check the path, field case and input structure before changing the query.
Sources
- JMESPath tutorialjmespath.org
- Obsidian code block syntaxhelp.obsidian.md
You can now query JSON files in Obsidian.
You're officially a regular.
Obsidian rewards people who share. NoteMods is just me and a lot of coffee. If this guide saved you a fight with the syntax, buy me a cup.
That's visit . Regulars are the reason I keep NoteMods running. If it's part of your routine now, a coffee says thanks better than anything.
The plugin in this guide
Local JSON Queries
Run and save JMESPath queries on vault JSON or JSONL files.