transform json to key/value file in bash

Question

I have a JSON which looks like this:

{
    "lorem": "ipsum",
    "dolor": "sid",
    "data": {
        "key1": "value1",
        "key2": "value2"
    }
}

and I want an output which is ini like where I only need the content of 'data' (which is always flat, no branches). The output should look like this:

key1=value1
key2=value2

I can use jq (just don't get it running) but have to use a bash script for it. Can anyone help?

What does "I can use jq (just don't get it running)" mean??? — peak, Dec 06 '17 at 14:33

RomanPerekhrest · Accepted Answer · 2017-12-06T14:32:35.943

3

jq solution:

jq -r '.data | to_entries[] | "\(.key)=\(.value)"' input.json

The output:

key1=value1
key2=value2

edited Dec 06 '17 at 14:32

answered Dec 06 '17 at 14:28

RomanPerekhrest

75,918
4
51
91

1

@MatiasBarrios, there are 2 moments: 1) the OP have written **I can use jq** ; 2) **jq** tag is ON – RomanPerekhrest Dec 06 '17 at 14:34
1

I actually can, but great to have a solution without it, too. Thanks to both of you. – Iarwa1n Dec 06 '17 at 14:43

score 0 · Answer 2 · answered Dec 06 '17 at 14:31

This will work in BASH.

#!/bin/bash

all_keys=$( cat input.txt );

while read key
do
    grep "$key" ./text.txt | awk -F':' '{ print $1"="$2}' | tr -d '[", ]'
done <<< "$all_keys"

Assuming you values are in text.txt and that you have your keys in input.txt.

Regards!

score 0 · Answer 3 · answered Dec 06 '17 at 14:35

In python This reads stdin and outputs the desired "key=value" one per line

#!/usr/bin/python

import json
import sys

data = sys.stdin.read()

json_structure=json.loads(data)

start_point=json_structure["data"]

for k in start_point.keys():
    print("%s=%s" % (k, start_point[k]))

If I was using python to unmangle the json input however, I would probably rewrite the bash script in python

transform json to key/value file in bash

3 Answers3

Linked