使用jq扁平化JSON数据

json{
  "user": {
    "name": "张三",
    "address": {
      "city": "北京",
      "zip": "100000"
    },
    "emails": ["zhangsan@example.com", "zs@example.cn"]
  },
  "active": true
}

json{
  "user.name": "张三",
  "user.address.city": "北京",
  "user.address.zip": "100000",
  "user.emails": ["zhangsan@example.com", "zs@example.cn"],
  "active": true
}

bashjq -r 'paths(scalars) as $path | { ($path | map(tostring) | join(".")): getpath($path) }' input.json

json{
  "users": [
    {
      "name": "张三",
      "emails": ["zhangsan@example.com", "zs@example.cn"]
    },
    {
      "name": "李四",
      "emails": ["lisi@example.com"]
    }
  ]
}

json[
  { "user.name": "张三", "user.emails[0]": "zhangsan@example.com", "user.emails[1]": "zs@example.cn" },
  { "user.name": "李四", "user.emails[0]": "lisi@example.com" }
]

bashjq '.users[] | with_entries(.key |= "user." + .) | flatten' input.json

bashjq '
  def flatten:
    reduce paths(scalars) as $path ({}; . + { ($path | map(tostring) | join(".")): getpath($path) });

  .users[] | flatten
' input.json

bashjq '
  def flatten:
    if type == "object" then
      map_values(flatten) | with_entries(.key |= "user." + .)
    elif type == "array" then
      map(flatten) | .[]
    else
      .
    end;

  .users[] | flatten
' input.json

bashjq '.users[] | {user: {name: .name, emails: .emails}}' input.json

bashjq '
  def flatten:
    if type == "object" then
      reduce keys[] as $k ({}; . + { ($k): (getpath([$k]) | flatten) })
    elif type == "array" then
      map(flatten) | flatten
    else
      .
    end;

  flatten
' input.json

json{
  "a": 1,
  "b": {
    "c": 2,
    "d": [3, 4, {"e": 5}]
  },
  "f": [6, {"g": 7}]
}

json{
  "a": 1,
  "b.c": 2,
  "b.d[0]": 3,
  "b.d[1]": 4,
  "b.d[2].e": 5,
  "f[0]": 6,
  "f[1].g": 7
}

json{
  "id": 1,
  "details": {
    "name": "张三",
    "contact": {
      "phone": "1234567890",
      "email": "zhangsan@example.com"
    }
  },
  "roles": ["admin", "user"]
}

json{
  "id": 1,
  "details.name": "张三",
  "details.contact.phone": "1234567890",
  "details.contact.email": "zhangsan@example.com",
  "roles[0]": "admin",
  "roles[1]": "user"
}

bashjq '
  def flatten:
    if type == "object" then
      reduce keys[] as $k ({}; . + { ($k): (getpath([$k]) | flatten) })
    elif type == "array" then
      map(flatten) | flatten
    else
      .
    end;

  flatten
' input.json

json{
  "id": 1,
  "details.name": "张三",
  "details.contact.phone": "1234567890",
  "details.contact.email": "zhangsan@example.com",
  "roles[0]": "admin",
  "roles[1]": "user"
}