Parse JSON data into a variable assignment format

Question

I am trying to parse JSON data into variable format

[
  {
    "Name" : "a",
    "Value" : "1"
  },
  {
    "Name" : "b",
    "Value" : "2"
  },
  {
    "Name" : "c",
    "Value" : "3"
  }
]

output should be like

a=1
b=2
c=3

This is what I tried, but it is not giving the expected result:

jq '.[].Value' file.txt

jq .[].Name file.txt or jq .[].Value file.txt this is printing key, valye in one go but how to assign value to key — Sandeep Sharma, May 02 '16 at 12:50
Possible duplicate of [Parsing JSON with UNIX tools](http://stackoverflow.com/questions/1955505/parsing-json-with-unix-tools) — redoc, May 02 '16 at 12:51
cat file.txt |jq -r '.[].Name,.[].Value' I have tried this. Now how can I assign value to key in output? — Sandeep Sharma, May 02 '16 at 13:22

score 5 · Answer 1 · answered May 02 '16 at 14:37

5

Since you're only printing out two values, it might just be easier to print out the strings directly.

$ jq -r '.[] | "\(.Name)=\(.Value)"' file.txt

answered May 02 '16 at 14:37

Jeff Mercado

Better than my attempt using a list and then join. I never knew that this kind if string interpolation is possible using jq. – hek2mgl May 02 '16 at 14:41
1

Also `... | .Name + "=" + .Value` – glenn jackman May 02 '16 at 20:16

hek2mgl · Answer 2 · 2016-05-02T13:27:48.030

3

You can use the following jq command:

jq -r '.[]|[.Name,.Value]|join("=")' file.json

Output:

a=1
b=2
c=3

edited May 02 '16 at 13:27

answered May 02 '16 at 13:23

hek2mgl

This answer better represents the expected output, though my answer might be useful if the json format needs preservation through other modifications. Feel free to copy mine into your answer to provide an all-encompassing solution (then I'll delete mine). – bishop May 02 '16 at 13:26
1

@bishop I see your point, but let me keep it simple. Readers will still have your answer as an alternative in such cases. – hek2mgl May 02 '16 at 13:32

bishop · Answer 3 · 2016-05-02T13:35:32.373

2

Using jq:

jq 'map({(.Name):.Value})|add|.//={}' < data.json

Produces:

{
  "a": "1",
  "b": "2",
  "c": "3"
}

If you have jq version 1.5+, you can use from_entries instead.

edited May 02 '16 at 13:35

answered May 02 '16 at 13:20

bishop

C14L · Answer 4 · 2016-05-02T13:23:29.357

0

This does it

python3 -c 'import json; print("\n".join(["{}={}".format(x["Value"], x["Name"]) for x in json.load(open("file.json"))]))'

result

a=1
b=2
c=3

edited May 02 '16 at 13:23

answered May 02 '16 at 13:15

C14L

A Python solution would not be adequate here, he was specifically looking for a jq solution. – Jeff Mercado May 02 '16 at 18:26

4 Answers4