Parse json into array in bash

Question

{
    "db_status": {
        "sysa": {
            "taskname": "AB",
            "state": "Running",
            "status": "System ATTENTION",
            "updated": "0727",
            "version": "5"
        },

        "sysb": {
            "taskname": "null",
            "state": "Standby",
            "status": "System OK",
            "updated": "0727",
            "version": "6"
        }
    }
}

CURL command returns json object. Trying to get both state variables in an array i.e. running and standby. So far i have tried

curl -s http://localhost:9099/api | grep state | sed 's/"//g' | awk -F  ": " '/state/ {print $2}' | tr '\n' ' ' |  sed s'/..$//'

You can edit the detail in the question no need to put that in comment and also your code is not indented properly please indent that properly — always-a-learner
– always-a-learner, Commented Jul 28, 2017 at 3:29

Ed Morton · Accepted Answer · 2017-07-28 11:29:14Z

2

FYI you don't need a pipeline of 20 different commands when you're using awk. The command line you provided can be written as just one command:

awk -F'"' '$2=="state"{printf "%s%s", (++c>1?", ":""),$4}'

but all you really need is:

awk -F'"' '$2=="state"{print $4}'

and to save the output in a shell array (assuming your json is really always formatted as you show in your question) would be:

$ arr=( $(cat file | awk -F'"' '$2=="state"{print $4}') )
$ echo "${arr[0]}"
Running
$ echo "${arr[1]}"
Standby

Replace cat file with your curl command.

answered Jul 28, 2017 at 11:29

Ed Morton

209k18 gold badges90 silver badges212 bronze badges

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

Comments

Soren · Accepted Answer · 2017-07-28 04:14:55Z

1

You could use jq

$ curl -s http://localhost:9099/api | jq '.db_status.sysa.state, .db_status.sysb.state'
"Running"
"Standby"

Or if you want all the entries no matter how many

$ curl -s http://localhost:9099/api | jq '.db_status[].state'
"Running"
"Standby"

Alternatively, if you don't have jq (or just looking for ways of feeling pain) you can parse most json in bash using ticktick -- which is written in 250 lines of bash

edited Jul 28, 2017 at 4:14

answered Jul 28, 2017 at 4:02

Soren

14.8k4 gold badges43 silver badges69 bronze badges

Collectives™ on Stack Overflow

Parse json into array in bash

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