Create json from shell script output

Question

I have a shell script version.sh in which i have code like.

#!/bin/sh
data = `lsb_release -a`
echo $data

it returned me the output like:

Distributor ID: Ubuntu
Description:    Ubuntu 20.04.3 LTS
Release:    20.04
Codename:   focal

so what I exactly want is want a JSON file to be created .and data should be there like

{'Release' : 20.04 , 'Codename' : focal}

I want to print data in JSON form .can anyone please help me related this ?? I am stuck here.any suggestion any help would be matter.

Perhaps an easier way would be to write a small awk script. You could pipe the output from lsb_release into awk, collect the values for release and codename, and in the END clause of awk you can generate the JSON string. — user1934428
– user1934428, Commented Apr 21, 2022 at 7:49
BTW, why is this tagged bash? It seems to be a sh-script. May I suggest to remove the bash-tag? — user1934428
– user1934428, Commented Apr 21, 2022 at 7:50

Baris Ozensel · Accepted Answer · 2022-04-22 10:31:51Z

3

You can use python ttp module to get this data. See the following example:

from ttp import ttp
import json

data_to_parse = """
Distributor ID: Ubuntu
Description:    Ubuntu 20.04.3 LTS
Release:    20.04
Codename:   focal
"""

ttp_template = """
Release:    {{release}}
Codename:   {{codename}}

"""

parser = ttp(data=data_to_parse, template=ttp_template)
parser.parse()

# print result in JSON format
results = parser.result(format='json')[0]
#print(results)

#converting str to json. 
result = json.loads(results)

print(result)

See the output:

EDITED as requested (without using any package):

data_to_parse = """
Distributor ID: Ubuntu
Description:    Ubuntu 20.04.3 LTS
Release:    20.04
Codename:   focal
"""

lines = data_to_parse.splitlines()

result = {}

for line in lines:
    if 'Release:' in line:
        line2 = line.split(':')
        result['Release'] = (line2[1].strip())

    elif 'Codename:' in line:
        line2 = line.split(':')
        result['Codename'] = (line2[1].strip())

print(result)

See the result:

EDITED 2. time:

New Data:

data_to_parse = """
Distributor ID: Ubuntu
Description:    Ubuntu 20.04.3 LTS
Release:    20.04
Codename:   focal

Distributor ID: Ubuntu
Description:    Ubuntu 20.04.3 LTS
Release:    22.04
Codename:   local

Distributor ID: Ubuntu
Description:    Ubuntu 20.04.3 LTS
Release:    21.04
Codename:   cocal

"""

The code:

lines = data_to_parse.splitlines()

result_list = []
result2 = {}
result_list3 = []

for line in lines:
    
    if 'Release:' in line:
        line2 = line.split(':')
        result_list.append({'Release': line2[1].strip()})
    
    elif 'Codename:' in line:
        line2 = line.split(':')
        result_list.append({'Codename': line2[1].strip()})
        result2 = {**result_list[0], **result_list[1]}
        result_list3.append(result2)
        result_list = []

print(result_list3)

The output:

edited Apr 22, 2022 at 10:31

answered Apr 21, 2022 at 7:41

Baris Ozensel

4831 gold badge4 silver badges11 bronze badges

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

10 Comments

Neha negi Over a year ago

Hello Baris Ozensel, Can't we do that without the ttp package ??

Baris Ozensel Over a year ago

Hi Neha, there should be some other ways to do that. As per my experience, ttp is the most easiest one.

Neha negi Over a year ago

I was asking because I can not install any package .so if there would be any solution without installing the package it would be great and helpful for me.

Neha negi Over a year ago

Hey thanx Baris Ozensel . that is what i exactly want but one issue is there it is not working with multiple data. when data_to_parse will be in multi data set then it should be return like [{'Release':'20.04', 'focal', '21.04'},{'Release':'20.04', 'focal', '21.04'}]

Baris Ozensel Over a year ago

You can create an empty list and add your data into the list. To do this, create an empty list as following result_list = [] first. Later on, result_list.append(result) needs to be added in one of if or elif statement (not at the same time.) This should work.

|

pmf · Accepted Answer · 2022-05-08 17:58:03Z

Not tagged or asked but with jq generally being an optimal choice for generating and/or manipulating JSON data in/for the shell (which indeed is tagged, along with bash), here's how a solution using jq could look like:

the -R option makes the input lines being interpreted as raw strings
the -n option makes the inputs keyword stand for an iterator over all input lines
the [inputs | …] array generator creates an array with one item per input line
the capture filter applies a regex on an input, and turns the matches into an object
the from_entries filter reduces an array of objects with key/value entries into one object
the {Release, Codename} object generator creates an object by filtering to only certain fields

lsb_release -a | jq -Rn '
  [ inputs | capture("(?<key>.*):\\s+(?<value>.*)") ]
  | from_entries | {Release, Codename}
'

{
  "Release": "20.04",
  "Codename": "focal"
}

Demo

If desired, adding the -c option would turn the output into a single line:

lsb_release -a | jq -Rnc '…'

{"Release":"20.04","Codename":"focal"}

Demo

Collectives™ on Stack Overflow

Create json from shell script output

2 Answers 2

10 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related