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

Answer 1

Replace this,

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

or try jq command,

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

For more information read this article.