How to iterate through json in bash script

Question

I have the json as below, i need to get only the mail from the above json in bash script

value={"count":5,"users":[{"username":"asa","name":"asa Tran","mail":"[email protected]"},{"username":"qq","name":"qq Morris","mail":"[email protected]"},{"username":"qwe","name":"qwe Org","mail":"[email protected]"}]}

Output can be as

[email protected],[email protected],[email protected]

All the above need to be done in the bash script (.sh)

I have already tried with the array iteration as but of no use

for key in "${!value[@]}"
do
        #echo "key = $key"
        echo "value = ${value[$key]}"
done

Even i have tried with the array conversion as

alias json-decode="php -r 'print_r(json_decode(file_get_contents(\"php://stdin\"),1));'" value=$(curl --user $credentials -k $endPoint | json-decode)

Still i was not able to get the specific output.

Chris Maes · Accepted Answer · 2018-08-21 10:42:03Z

9

jq is the tool to iterate through a json. In your case:

while read user; do
    jq -r '.mail' <<< $user
done <<< $(jq -c '.users[]' users.json)

would give:

[email protected]
[email protected]
[email protected]

NOTE: I removed "value=" because that is not valid json. Users.json contains:

{"count":5,"users":[{"username":"asa","name":"asa Tran","mail":"[email protected]"},{"username":"qq","name":"qq Morris","mail":"[email protected]"},{"username":"qwe","name":"qwe Org","mail":"[email protected]"}]}

answered Aug 21, 2018 at 10:42

Chris Maes

38.3k15 gold badges119 silver badges159 bronze badges

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

Comments

cbliard · Accepted Answer · 2013-10-21 07:37:08Z

7

If this is valid json and the email field is the only one containing a @ character, you can do something like this:

echo $value | tr '"' '\n' | grep @

It replaces double-quotes by new line character and only keeps lines containing @. It is really not json parsing, but it works.

You can store the result in a bash array

emails=($(echo $value | tr '"' '\n' | grep @))

and iterate on them

for email in ${emails[@]}
do
    echo $email
done

edited Oct 21, 2013 at 7:37

answered Oct 21, 2013 at 7:28

cbliard

7,3226 gold badges45 silver badges48 bronze badges

Comments

Thibault · Accepted Answer · 2013-10-21 07:57:55Z

3

You should use json_pp tool (in debian, it is part of the libjson-pp-perl package)

One would use it like this :

cat file.json | json_pp

And get a pretty print for your json.

So in your case, you could do :

#!/bin/bash
MAILS=""  
LINES=`cat test.json | json_pp | grep '"mail"' | sed 's/.* : "\(.*\)".*/\1/'`
for LINE in $LINES ; do
    MAILS="$LINE,$MAILS"
done
echo $MAILS | sed 's/.$//'

Output :

[email protected],[email protected],[email protected]

edited Oct 21, 2013 at 7:57

answered Oct 21, 2013 at 7:50

Thibault

1,59416 silver badges22 bronze badges

Comments

Yann Moisan · Accepted Answer · 2013-10-21 08:55:24Z

1

Using standard unix toolbox : sed command

cat so.json | sed "s/},/\n/g" | sed 's/.*"mail":"\([^"]*\)".*/\1/'

answered Oct 21, 2013 at 8:55

Yann Moisan

8,3099 gold badges53 silver badges92 bronze badges

1 Comment

koolunix Over a year ago

unfortunately this will not work with complex objects

Jacek Pospychala · Accepted Answer · 2014-12-07 12:31:49Z

-1

With R you could do this as follows:

$ value={"count":5,"users":[{"username":"asa","name":"asa Tran","mail":"[email protected]"},{"username":"qq","name":"qq Morris","mail":"[email protected]"},{"username":"qwe","name":"qwe Org","mail":"[email protected]"}]}
$ echo $value | R path users | R map path mail
["[email protected]", "[email protected]", "[email protected]"]

answered Dec 7, 2014 at 12:31

Jacek Pospychala

973 bronze badges

Collectives™ on Stack Overflow

How to iterate through json in bash script

5 Answers 5

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related