extract variable from json style output in Linux command

Question

I try to use the AWS secrets manager in the linux system. I could use aws cli command

aws secretsmanager get-secret-value --secret-id abc_account --version-stage AWSCURRENT

to get following output

{
    "ARN": "arn:aws:secretsmanager:us-east-1:123456789:secret:abc_account-XhteiW",
    "Name": "abc_account",
    "VersionId": "89637ef4-4594-4c63-9887-3f7d2c7ccc6f",
    "SecretString": "{\"username\":\"abc_account\",\"password\":\"PASSWORD111\"}",
    "VersionStages": [
        "AWSCURRENT"
    ],
    "CreatedDate": "2021-02-08T23:57:58.325000-05:00"
}

what I need is to save the password PASSWORD111 into a variable var1 in the linux. something like

var1=$(aws secretsmanager get-secret-value --secret-id svc_vma_insights_data_platform --version-stage AWSCURRENT | awk XXXXXX )
or 
var1=$(aws secretsmanager get-secret-value --secret-id svc_vma_insights_data_platform --version-stage AWSCURRENT | grep XXXXXX )

glenn jackman · Accepted Answer · 2021-02-09 15:24:06Z

2

This is extracting the secret string from the JSON output, and then extracting the password from that JSON:

passwd=$(aws ...  | jq -r '.SecretString' | jq -r '.password')

answered Feb 9, 2021 at 15:24

glenn jackman

249k42 gold badges233 silver badges362 bronze badges

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

Comments

anubhava · Accepted Answer · 2021-02-09 14:19:06Z

1

On linux you may try this gnu grep:

var1=$(aws ... | grep -oP 'password\W+\K[^"\\]+')
echo "$var1"

PASSWORD111

Command regex:

password\W+: Match text password followed by 1+ non-word characters
\K: Reset match info
[^"\\]+: Match 1+ of any character that is not a " and not a \

answered Feb 9, 2021 at 14:19

anubhava

790k67 gold badges603 silver badges671 bronze badges

1 Comment

cuaspectcox Over a year ago

Great. That works fine. Thank you so much.

Collectives™ on Stack Overflow

extract variable from json style output in Linux command

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related