Bash - Loop through JSON array

Question

This is how my input looks like:

[
    {
        "Description": "Description 1"
        "OutputKey": "OutputKey 1"
        "OutputValue": "OutputValue 1"
    }
    {
        "Description": "Description 2"
        "OutputKey": "OutputKey 2"
        "OutputValue": "OutputValue 2"
    }
    {
        "Description": "Description 3"
        "OutputKey": "OutputKey 3"
        "OutputValue": "OutputValue 3"
    }
    {
        "Description": "Description 4"
        "OutputKey": "OutputKey 4"
        "OutputValue": "OutputValue 4"
    }
    {
        "Description": "Description 5"
        "OutputKey": "OutputKey 5"
        "OutputValue": "OutputValue "
    }
    {
        "Description": "Description 6"
        "OutputKey": "OutputKey 6"
        "OutputValue": "OutputValue 6"
    }
]

I need to loop through each object inside the array and fetch OutputKey and OutPutValue and use it in another function.

How do i loop through this array and get the desired values?

I am using GitBash on Windows box.

Gilles Quénot · Accepted Answer · 2016-09-27 21:11:20Z

2

1) your JSON is invalid, this is a correct version (input.json) :

[
    {
        "Description": "Description 1",
        "OutputKey": "OutputKey 1",
        "OutputValue": "OutputValue 1"
    },
    {
        "Description": "Description 2",
        "OutputKey": "OutputKey 2",
        "OutputValue": "OutputValue 2"
    },
    {
        "Description": "Description 3",
        "OutputKey": "OutputKey 3",
        "OutputValue": "OutputValue 3"
    },
    {
        "Description": "Description 4",
        "OutputKey": "OutputKey 4",
        "OutputValue": "OutputValue 4"
    },
    {
        "Description": "Description 5",
        "OutputKey": "OutputKey 5",
        "OutputValue": "OutputValue "
    },
    {
        "Description": "Description 6",
        "OutputKey": "OutputKey 6",
        "OutputValue": "OutputValue 6"
    }
]

2) as far as json means JavaScript Object Notation, I use js with nodejs in a shell script :

#!/bin/bash

node<<EOF
var arr = $(cat input.json);
arr.forEach(function(el){ console.log(el.OutputKey + " " + el.OutputValue ); })
EOF

Output

OutputKey 1 OutputValue 1
OutputKey 2 OutputValue 2
OutputKey 3 OutputValue 3
OutputKey 4 OutputValue 4
OutputKey 5 OutputValue 
OutputKey 6 OutputValue 6

Note

you can use rhino instead of node and the print() command instead of console.log() if you prefer
you can use jq too

edited Sep 27, 2016 at 21:11

answered Sep 27, 2016 at 21:08

Gilles Quénot

188k43 gold badges232 silver badges229 bronze badges

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

7 Comments

Asdfg Over a year ago

The output i am receiving is from aws CLI.

Gilles Quénot Over a year ago

Which command ? Look for app switchs, I'm pretty sure it can produce a valid JSON as well...

Asdfg Over a year ago

this is the command:

echo $(aws cloudformation describe-stacks --profile myProfile --region us-east-1 --stack-name "myStack" --query 'Stacks[*].Outputs[*]' --output json)

Gilles Quénot Over a year ago

Check docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/…, you have to define a valid JSON template

Asdfg Over a year ago

I am not defining the template. I already have stack created from the template. I am just trying to grab the output values from that stack.

|

Collectives™ on Stack Overflow

Bash - Loop through JSON array

1 Answer 1

Output

Note

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Output

Note

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related