LOG PARSERLIZARD
Tutorials · curl and APIs

Query JSON saved from curl

When an API response is too large to read comfortably, save it to disk and use SQL to isolate records and patterns.

Save the response

curl -o api-response.json https://example/api/items

Inspect a small sample

Confirm field names, null handling and nested objects before writing the final query.

Filter incomplete records

SELECT id, name, status, updated
FROM 'C:\Data\api-response.json'
WHERE status <> 'Completed'
ORDER BY updated DESC;