Mashhad LUG 268

data.json

{
    "users": [
        {
            "id": 1,
            "name": "Alice",
            "age": 28,
            "status": "active",
            "books": [
                "Test",
                "Good",
                "Bad"
            ]
        },
        {
            "id": 2,
            "name": "Charlie",
            "age": 35,
            "status": "inactive"
        },
        {
            "id": 3,
            "name": "Bob",
            "age": 22,
            "status": "active"
        }
    ],
    "settings": {
        "theme": "light",
        "notifications": true
    },
    "metadata": [
        {
            "version": "1.0",
            "last_updated": "2023-01-01"
        },
        {
            "version": "2.0",
            "last_updated": "2024-02-01"
        }
    ]
}

jq.sh

#!/usr/bin/env bash
# Download this two files and then: chmod +x jq.sh

### Define the path to the JSON file
json_file="data.json"

### Read normally
cat $json_file

### Read json data
cat $json_file | jq
jq '' $json_file

# Read a specific part of json data
jq '.metadata' $json_file
jq '.metadata[]' $json_file
jq '.users[2].name' $json_file
jq '.users[0].books[1]' $json_file
jq '.users[0].books' $json_file
jq '.users[0].books[]' $json_file

# Sort data
jq '.users | sort_by(.name)' $json_file
jq '.users | sort_by(.age)' $json_file
jq '.users | sort_by(.age) | reverse' $json_file

# Filter json data
jq '.users[] | select(.age > 30)' $json_file
jq '.users | map(select(.age > 25)) | sort_by(.age)' $json_file
jq '.metadata[] | select(.version == "2.0")' $json_file

# Map on json data
jq '.users | map(.age *= 2) | sort_by(.age) | reverse' $json_file
jq '.users | map(.age * 2)' $json_file

# Update data
jq '.users[0].age = 30 | .users[1].age = 22' $json_file > clean_data.json