How to read and parse the json file and add it into the shell script variable?

Question

I am having the file named loaded.json which contains the below json data.

    {
        "name" : "xat",
        "code" : "QpiAc"
    }
    {
        "name" : "gbd",
        "code" : "gDSo3"
    }
    {
        "name" : "mbB",
        "code" : "mg33y"
    }
    {
        "name" : "sbd",
        "code" : "2Vl1w"
    }

Form the shell script i need to read and parse the json and add the result to the variable and print it like this.

#!/bin/sh
databasename = cat loaded.json | json select '.name'
echo $databasename

When i run the above script i am getting error like

databasename command not found
json command not found

I am new to shell script please help me to solve this problem

Remove spaces around '=', and wrap command into $(). And you should have json application installed — Dmitri Sosnik
– Dmitri Sosnik, Commented Jan 28, 2015 at 6:25

Arnab Nandy · Accepted Answer · 2020-06-06 05:31:18Z

24

Replace this,

databasename=`cat loaded.json | json select '.name'`

or try jq command,

databasename=`jq '.name' loaded.json`

For more information read this article.

edited Jun 6, 2020 at 5:31

answered Jan 28, 2015 at 6:24

Arnab Nandy

6,8025 gold badges50 silver badges52 bronze badges

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

3 Comments

Soorya Prakash Over a year ago

databasename = cat loaded.json | json select '.name' using this command i am getting error as "json: command not found". if i use underscore insted of json i am getting error as "Error while parsing STDIN in mode 'lax': Unexpected token :". I installed both underscore-cli and also json library.

Arnab Nandy Over a year ago

@SooryaPrakash replace above code of json command with modification to your shellscript first, if not working then try the jq command.

Arnab Nandy Over a year ago

@DrCord link is working perfectly

Arnab Nandy · Accepted Answer · 2015-04-18 02:18:06Z

4

I can able to get the result using jq command like below

databasename=`cat loaded.json | jq '.name'`

edited Apr 18, 2015 at 2:18

Arnab Nandy

6,8025 gold badges50 silver badges52 bronze badges

answered Jan 28, 2015 at 7:29

Soorya Prakash

9913 gold badges9 silver badges33 bronze badges

Collectives™ on Stack Overflow

How to read and parse the json file and add it into the shell script variable?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related