Converting JSON object to Array using JQ

Question

I am trying to convert map of objects to an array with jq

My Input is

{
  "fish-chips": {
    "likeDislikeRatio": ["80%", "20%"],
    "country": ["BRIT_FOOD","USA_FOOD"]
  },
  "sausage": {
    "likeDislikeRatio": ["75%", "25%"],
    "country": ["EU_FOOD"]
  },
  "cheese-burger": {
    "likeDislikeRatio": ["25%", "75%"],
    "country": [
      "BRIT_FOOD",
      "USA_FOOD",
      "EU_FOOD",
      "DEFAULT"
    ]
  }
}

And my expected output is

[
  {
"name" : "fish-chips",    
"likeDislikeRatio": [
      "80%",
      "20%"
    ],
    "country": [
      "BRIT_FOOD",
      "USA_FOOD"
    ]
  }
]
[
  {
"name" : "sausage",
    "likeDislikeRatio": [
      "75%",
      "25%"
    ],
    "country": [
      "EU_FOOD"
    ]
  }
]
[
  {
"name" : "cheese-burger",
    "likeDislikeRatio": [
      "25%",
      "75%"
    ],
    "country": [
      "BRIT_FOOD",
      "USA_FOOD",
      "EU_FOOD",
      "DEFAULT"
    ]
  }
]

what I tried The closest filter I could find was to_entries[] | [.key, .value]

but the output is not as what I expected and I feel that there should be one more filter with this to get the desired out put

Current Output

[
  "fish-chips",
  {
    "likeDislikeRatio": [
      "80%",
      "20%"
    ],
    "country": [
      "BRIT_FOOD",
      "USA_FOOD"
    ]
  }
]
[
  "sausage",
  {
    "likeDislikeRatio": [
      "75%",
      "25%"
    ],
    "country": [
      "EU_FOOD"
    ]
  }
]
[
  "cheese-burger",
  {
    "likeDislikeRatio": [
      "25%",
      "75%"
    ],
    "country": [
      "BRIT_FOOD",
      "USA_FOOD",
      "EU_FOOD",
      "DEFAULT"
    ]
  }
]

I saw many posts on doing the opposite that is converting array to map using either reduce or INDEX but not what I expected.

oguz ismail · Accepted Answer · 2021-07-19 07:59:15Z

3

You were close.

to_entries[] | [{name: .key} + .value]

^{Online demo}

answered Jul 19, 2021 at 7:59

oguz ismail

51.8k16 gold badges64 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Sandeep Nair Over a year ago

I am not sure if the followup question can be asked. Is it possible to further have a filter and output has added text and filters like this

Sandeep Nair Over a year ago

split_clients "${remote_addr}${http_user_agent}" $fish_chips_default { 80% "fish-chips=0"; 20% "fish-chips=1"; } split_clients "${remote_addr}${http_user_agent}" $sausage_default { 25% "sausage=0"; 75% "sausage=1"; }

Sandeep Nair Over a year ago

map $foodExpPage $foodexperiments { default $cheese_burger; "brit" '$cheese_burger,$fish_chips'; "usa" $cheese_burger; "eu" '$sausage'; }

Sandeep Nair Over a year ago

As you can see it has lots of character addition and replacement. Is this possible with further filters?

oguz ismail Over a year ago

@SandeepNair I think you should post another question for that.

|

Collectives™ on Stack Overflow

Converting JSON object to Array using JQ

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related