Farshid/Ashouri

jq

10 posts tagged “jq”.

  1. 2025

  2. Flattening nested JSON objects with jq

    I wanted to take a nested set of JSON objects and import them into a SQLite database using - but I wanted to "flatten" some of the nested rows.

    jq json data-transformation cli sqlite-utils
    1 min read

  3. axe-core and shot-scraper for accessibility audits

    I just watched a talk by Pamela Fox at North Bay Python on Automated accessibility audits. The video should be up within 24 hours.

    accessibility web-development testing javascript cli
    1 min read

  4. Convert git log output to JSON using jq

    I just spent way too long messing around with ChatGPT (transcript here) trying to figure this out. After much iteration, here's a recipe that works (mostly written by me at this point): The output…

    git jq cli json bash
    1 min read

  5. Combined release notes from GitHub with jq and paginate-json

    Matt Holt asked: Is there a tool that uses the GitHub API to generate a doc with all release notes from a repo?

    github api release-notes jq cli
    2 min read
  6. 2024

  7. Loading radio.garden into SQLite using jq

    http://radio.garden/ is an amazing website which displays a 3D globe covered in radio stations and lets you listen to any of them. I wanted to have a play around with their data.

    TIL jq
    1 min read

  8. Turning an array of arrays into objects with jq

    Input: I want an array of objects. Here's what I came up with, using jqplay.org: This outputs: If you remove the outer and and use the "Compact output" option you get back this instead:

    TIL jq
    1 min read
  9. 2023

  10. Accessing 1Password items from the terminal

    I save things like API keys in 1Password. Today I figured out how to access those from macOS terminal scripts.

    1password cli security macos bash
    1 min read

  11. Extracting objects recursively with jq

    The Algolia-powered Hacker News API returns nested comment threads that look like this: https://hn.algolia.com/api/v1/items/27941108 (For this story: https://news.ycombinator.com/item?id=27941108) I…

    jq json data-transformation cli recursion
    1 min read

  12. Converting Airtable JSON for use with sqlite-utils using jq

    The Airtable API outputs JSON that looks like this: The items in the array each have an , a nested dictionary and a .

    airtable json jq sqlite-utils cli
    1 min read

  13. Converting no-decimal-point latitudes and longitudes using jq

    I had some data with weird co-ordinates in it: Note the and in there. I know that this data refers to somewhere in Houston, and a few people on Twitter pointed out that it's actually really simple…

    jq json data-transformation cli geospatial
    1 min read