Importing JSON file with python

Question

I have imported a json file with python and still read the first json elements i need to add a loop for to read all the file

JSON file content

 [
        {
            "severity": 4,
            "status": "OPEN",
            "id": 1987,
            "description": "Multiple Login Failures for the Same User containing Bad Username",
            "start_time": 1525269490400
        },
        {
            "severity": 4,
            "status": "OPEN",
            "id": 1986,
            "description": "Multiple Login Failures for the Same User containing Bad Username",
            "start_time": 1525269181679
        },
.
.
.
.
.
    ]

and this is the python script

# Prepare the sample Alert

with open('output.json') as json_data:
    data = json.load(json_data,) 
if severity=data[0]['severity'] < 4:
    severity=1
elif severity=data[0]['severity'] > 6:
    severity=3
else:
    severity=2  
alert = Alert(title=data[0]['description'],
              date=data[0]['start_time'],
              severity=severity,
              description='N/A',
              type='Offense',
              source='QradarSiem',
              sourceRef=data[0]['id'])

i know that i need to use

for line in f:
    data.append(json.loads(line))

but i don't know where and how to use it, can you help ?

Please rephrase. Your question is unclear. What are you trying to do? What is a 'boucle'? — uwain12345
– uwain12345, Commented May 2, 2018 at 15:17

bruno desthuilliers · Accepted Answer · 2018-05-02 15:17:28Z

1

i know that i need to use for line in f: data.append(json.loads(line))"

Why on earth would you do that ??? You've already parsed the whole file, you have a list object back, all you have to do is iterate on the list.

with open('output.json') as json_data:
    data = json.load(json_data,) 

for item in data:
    print(item)

answered May 2, 2018 at 15:17

bruno desthuilliers

78.3k6 gold badges102 silver badges129 bronze badges

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

Comments

uwain12345 · Accepted Answer · 2018-05-02 15:20:26Z

1

With the line

 data = json.load(json_data,)

you already have all the data loaded. Now you can just iterate over 'data':

for item in data:
    if item['severity'] == 4:
        do_something(item)

answered May 2, 2018 at 15:20

uwain12345

3865 silver badges21 bronze badges

Comments

Elizabeth · Accepted Answer · 2019-09-30 02:53:56Z

0

Try:

import json
with open("infile.json","r") as infile:
    val = infile.read()
    json=json.loads(val)
print(json)

answered Sep 30, 2019 at 2:53

Elizabeth

113 bronze badges

1 Comment

Thingamajig Over a year ago

Can you explain what this does? Just providing code is not often enough to provide full context to support your answer.

Collectives™ on Stack Overflow

Importing JSON file with python

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related