Learning objectives
- Separate syntax validation from visual formatting
- Convert without losing the underlying data model
- Query a JSON document with a reproducible expression
- Turn noisy prose into clean lists
- Identify delimiter assumptions before bulk conversion
Station 1: readable JSON
Install Beautify and sort JSON. Change one comma or quote to make the input invalid, then restore it. Formatting is also a lightweight syntax check.
Station 2: format conversion
Run both of these recipes:
For CSV, change the line endings or add a comma inside an unquoted value. Record how delimiter choices alter the result.
Station 3: query instead of scrolling
Install Query JSON with Jsonata. The supplied query selects products whose price is greater than ten.
Modify the expression to return the full matching order objects. Then change the threshold and predict the result before running it.
Station 4: extract lists from prose
Use:
Explain the difference between sorting case-insensitively and deduplicating exact values.
Assignment
Create a compact incident-summary JSON object with a case ID, two domains, and an array of timestamps. Beautify it, query only the domains, and transform the result into a newline list. Save the final recipe without real case data.