How to parse and loads JSON in bash shell script?

Question

I am trying to loads and print JSON response in shell script.I dont have any idea how to achieve this.Please help me on this.

Code:

#!/bin/sh

malop_q=$(curl -X GET -k -H "SEC: xxxxxxxxxxxxxxxxxxxxxx" 'https://127.0.0.1/api/reference_data/sets/malopid?fields=data(value)')

echo $malop_q

JSON Response:

{"data":[{"value":"11.945403842773683082"},{"value":"11.945403842773683082"},{"value":"11.945403842773683082"}]}

Expected OP is

I need to print values from above JSON response is:

11.945403842773683082
11.945403842773683082
11.945403842773683082

Thanks in advance.

'

Are you looking for "bash only" answer? or answer which uses python? — Yaron
– Yaron, Commented May 31, 2016 at 7:55
Have a look at jq. Using text processing tools (like awk) for parsing json is never the best idea. Use a tool that has json parsing libraries. — anishsane
– anishsane, Commented May 31, 2016 at 8:03

Yaron · Accepted Answer · 2016-05-31 08:09:21Z

2

The following python code do the parsing, assuming that you save it as: my_json.py

import json,sys

obj=json.load(sys.stdin)
for i in range(len(obj['data'])):
    print obj['data'][i]['value']

You can get the respond using:

malop_q=$(curl -X GET -k -H "SEC: xxxxxxxxxxxxxxxxxxxxxx" 'https://127.0.0.1/api/reference_data/sets/malopid?fields=data(value)')   
echo $malop_q | python my_json.py

or in one line:

curl -X GET -k -H "SEC: xxxxxxxxxxxxxxxxxxxxxx" 'https://127.0.0.1/api/reference_data/sets/malopid?fields=data(value)' | python my_json.py

answered May 31, 2016 at 8:09

Yaron

10.6k9 gold badges50 silver badges72 bronze badges

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

Comments

SLePort · Accepted Answer · 2016-05-31 08:18:36Z

2

With Python :

import json

with open('file.json') as json_file:    
    datas = json.load(json_file)

for d in datas["data"]:
  print(d["value"])

edited May 31, 2016 at 8:18

answered May 31, 2016 at 8:10

SLePort

15.5k3 gold badges40 silver badges45 bronze badges

Collectives™ on Stack Overflow

How to parse and loads JSON in bash shell script?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related