how to output all the keys and values from json using jq?

Question

I am trying to out all the data from my json file that matches the value "data10=true" it does that but only grabs the names, how can i make it so it will output everything in my json file with anything that matches the "data10=true"?

this is what ive got data=$(jq -c 'to_entries[] | select (.value.data10 == "true")| [.key, .value.name]' data.json )

This is in my YAML template btw, running it as a pipeline in devops.

Can you provide some input and required output samples?

amsh
– amsh

2020-10-06 18:12:25 +00:00
Commented Oct 6, 2020 at 18:12 — amsh
– amsh, Commented Oct 6, 2020 at 18:12

peak · Accepted Answer · 2020-10-08 05:00:10Z

0

The detailed requirements are unclear, but hopefully you'll be able to use the following jq program as a guide:

..
| objects
| select( .data10 == "true" )
| to_entries[]
| select(.key != "data10")
| [.key, .value]

This will recursively (thanks to the initial ..) examine all the JSON objects in the input.

p.s.

If you want to make the selection based on whether .data10 is "true" or true, you could change the criterion to .data10 | . == true or . == "true".

edited Oct 8, 2020 at 5:00

answered Oct 6, 2020 at 21:08

peak

119k21 gold badges185 silver badges218 bronze badges

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

4 Comments

rayaurelius Over a year ago

I have a file called data.json in github and I am calling this file from my YAML template --- trigger: - none pool: name: Hosted Ubuntu 1604 steps: - script: | displayName: 'Update the build number in readme.txt' name: JQ sudo apt-get install jq echo 'installing jq' curl raw.githubusercontent.com/test/… data=$(jq .. objects | select( .data10 == true ) | to_entries[] | select(.key != "data10") | [.key, .value]' data.json) running this i am getting an error: syntax error: unexpected end of file.

peak Over a year ago

You seem to be missing the first pipe symbol and the necessary single-quotes. If you're going to include the jq program on the command line, the invocation should look like: jq '.. | objects .......' data.json

rayaurelius Over a year ago

Thanks peak seems it passed but i am not getting any values back..this is my data.json file:{ "FOO": { "data10":"true", "name": "Donald", "location": "Stockholm" }, "BAR": { "data10":"true", "name": "Walt", "location": "Stockholm" }, "BAZ": { "data10":"true", "name": "Jack", "location": "Whereever" } }

peak Over a year ago

My mistake. I wrote true instead of "true". Changed.

Fábio Almeida · Accepted Answer · 2020-10-07 09:40:59Z

0

jq 'to_entries | map(select(.value.data10=="true")) | from_entries' data.json

input data.json, with false value:

{
  "FOO": {
    "data10": "false",
    "name": "Donald",
    "location": "Stockholm"
  },
  "BAR": {
    "data10": "true",
    "name": "Walt",
    "location": "Stockholm"
  },
  "BAZ": {
    "data10": "true",
    "name": "Jack",
    "location": "Whereever"
  }
}

output:

{
  "BAR": {
    "data10": "true",
    "name": "Walt",
    "location": "Stockholm"
  },
  "BAZ": {
    "data10": "true",
    "name": "Jack",
    "location": "Whereever"
  }
}

based on: https://stackoverflow.com/a/37843822/983325

edited Oct 7, 2020 at 9:40

answered Oct 7, 2020 at 9:13

Fábio Almeida

3053 silver badges9 bronze badges

1 Comment

peak Over a year ago

@rayaurelius - If it’s perfect, it would be appropriate to upvote it.

Collectives™ on Stack Overflow

how to output all the keys and values from json using jq?

2 Answers 2

p.s.

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

p.s.

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related