How to create array from json data in shell script

Question

I used to read the json file using

recordtype=python -c 'import sys,json,ast;print ast.literal_eval(json.dumps(json.load(sys.stdin)["record"].keys())) < 1.json

I got the value of recordtype like

['1', '2', '3', '4']

In order for me to loop to the recordtype, I need the array like this

(1 2 3 4)

How to convert the above to this type of array? And if its possible to loop through the above value? I used

for type in "${recordtype[@]}"

The json would be:

{"modes":["a","b","c"],"recordtype":{"1":{"mode":"a","inputpath":"/us/","archive":""},"2":{"mode":"b","inputpath":"","archive":""}}}

{ "modes": [ "a", "b", "c" ], "recordtype": { "1": { "mode":"a", "inputpath":"/us/", "archive":"" }, "2": { "mode":"b", "inputpath":"", "archive":"" } } } — SRIRAM RAMACHANDRAN
– SRIRAM RAMACHANDRAN, Commented Jan 30, 2018 at 14:53

iBug · Accepted Answer · 2018-01-30 12:58:14Z

1

What about running though the generated string again?

arr=($(echo "['1', '2', '3', '4']" | grep -oP "'[^']*'" | awk '{print substr($0, 2, length($0) - 2)}'))

This extracts everything between single quotes, then strips the quotes on the sides, and gives what you want.

ibug@linux:~ $ echo "${arr[@]}"
1 2 3 4
ibug@linux:~ $ for i in "${arr[@]}"; do echo "$i"; done
1
2
3
4
ibug@linux:~ $

answered Jan 30, 2018 at 12:58

iBug

37.6k8 gold badges101 silver badges155 bronze badges

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

5 Comments

SRIRAM RAMACHANDRAN Over a year ago

yeah thanks its working. But the issue it can't be static. The array is dynamic. And can you explain me the print part after awk?

iBug Over a year ago

@SRIRAMRAMACHANDRAN The array is dynamic. Just replace the first part echo "[...]" with your actual output.

iBug Over a year ago

@SRIRAMRAMACHANDRAN The print part is an AWK program that removes the first and the last character from each line, which is the unwanted single quotes.

SRIRAM RAMACHANDRAN Over a year ago

thanks for the explanation... and what does substr doing?

iBug Over a year ago

@SRIRAMRAMACHANDRAN It's the core part that does the quote-stripping job. It takes the substring starting from position 2, with a length of length - 2, which should be the part of the string exactly without the quotes.

Collectives™ on Stack Overflow

How to create array from json data in shell script

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related