Using jq to fetch key value from json output

Question

I have a file that looks as below:

{
  "repositories": [
   {
    "id": "156c48fc-f208-43e8-a631-4d12deb89fa4",
    "namespace": "rhel12",
    "namespaceType": "organization",
    "name": "rhel6.6",
    "shortDescription": "",
    "visibility": "public"
   },
   {
    "id": "f359b5d2-cb3a-4bb3-8aff-d879d51f1a04",
    "namespace": "rhel12",
    "namespaceType": "organization",
    "name": "rhel7",
    "shortDescription": "",
    "visibility": "public"
   }
  ]
 }

I want to get only name values with each of them in a new line so that I can use while read -r line. I need only

rhel6.6 
rhel7

I am using jq as follows which doesn't seem to work:

jq -r '.[].name'

Please suggest correct use of jq here

Benjamin Loison · Accepted Answer · 2022-12-05 03:49:04Z

124

You need to combine filters by means of | operator:

$ jq -r '.[] | .[] | .name' test.json 
rhel6.6
rhel7

The first .[] fetches repositories array. The next .[] fetches all the items of the repositories array. Finally, .name extracts properties from the array items(objects).

Note, the first .[] works on object because it is a documented feature:

.[]
    If you use the .[index] syntax, but omit the index entirely, it
    will return all of the elements of an array...

    You can also use this on an object, and it will return all the
    values of the object.

edited Dec 5, 2022 at 3:49

Benjamin Loison

5,7504 gold badges20 silver badges37 bronze badges

answered Sep 30, 2016 at 19:28

Ruslan Osmanov

21.8k8 gold badges52 silver badges62 bronze badges

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

2 Comments

meallhour Over a year ago

thanks for your response. Can you please how can i get output in format rhel12/rhel6.6 In other words, I need o/p in format namespace/name

Ruslan Osmanov Over a year ago

@meallhour, jq -r '.[] | .[] | [.namespace, .name] | join("/")' test.json

that other guy · Accepted Answer · 2016-09-30 19:28:44Z

39

You want to look at the repositories array instead of treating the input as an array:

$ jq -r '.repositories[].name' file
rhel6.6
rhel7

answered Sep 30, 2016 at 19:28

that other guy

125k12 gold badges188 silver badges214 bronze badges

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

18

Here is another solution. Assuming the requirements

I want to get only name values with each of them in a new line so that I can use while read -r line.

Can you please how can i get output in format rhel12/rhel6.6 In other words, I need o/p in format namespace/name

if the data is in data.json then the command

jq -M -r '.repositories[] | "\(.namespace)/\(.name)"' data.json

should produce

rhel12/rhel6.6
rhel12/rhel7

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Aug 31, 2017 at 1:08

jq170727

15.1k6 gold badges52 silver badges61 bronze badges

Collectives™ on Stack Overflow

Using jq to fetch key value from json output

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related