Getting a JSON value with Python

Question

I'm trying to get the malicious value from a JSON string.

What's a straight forward way of getting this value? Screenshot and code below.

Pastebin: link

Screenshot:

import json
  
def vt(domain):

  # load json content from file
  with open('vt.txt', 'r') as file:
    content = file.read()

  # convert from sring to json
  content = json.loads(content)

  # read how many engines detect this domain as malicious 
  malicious = content["data"]["attributes"]["last_analysis_stats"]["malicious"]
            
  
vt("pp-alert.com")

Repl.it code: https://repl.it/@MiguelDuarte1/ButteryCanineDonateware

How did you get the idea to use [0] in content["data"]["attributes"][0]["malicious"]? I don't see any list in your JSON file. You have to access the correct dictionary key. — Matthias
– Matthias, Commented Oct 17, 2020 at 19:46
Based on the POST link from the bottom. Also tried ´content["data"]["attributes"]["last_analysis_stats"]["malicious"]´ without success. — Andre
– Andre, Commented Oct 17, 2020 at 19:47

Kokul Jose · Accepted Answer · 2020-10-17 20:20:13Z

2

import json
  
def vt(domain):

  # load json content from file
  with open('vt.txt', 'r') as file:
    content = file.read()

  # convert from sring to json
  content = json.loads(content)

  # read how many engines detect this domain as 
  malicious = content['data'][0]['attributes']['last_analysis_stats']['malicious']
  #print(malicious)        
  
vt("pp-alert.com")

This will give you the result.

Note: the JSON in Pastebin link you have provided is different than that you actually use in the vt.txt file.

answered Oct 17, 2020 at 20:20

Kokul Jose

1,7822 gold badges18 silver badges28 bronze badges

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

2 Comments

Andre Over a year ago

Thanks man! Really worked... thanks for helping a total stranger :-) +1

Matthias Over a year ago

We're always eager to help. But please make sure, that you give us correct information. As @KokulJose said: This code won't run with the JSON file you provided in the pastebin.

Ofek Hod · Accepted Answer · 2020-10-17 19:48:37Z

0

I think you missed a field, you don't need [0] since attributes is not an array.
Please try:

malicious = content['data']['attributes']['last_analysis_stats']['malicious']

answered Oct 17, 2020 at 19:48

Ofek Hod

4,0842 gold badges20 silver badges32 bronze badges

4 Comments

Andre Over a year ago

TypeError: list indices must be integers or slices, not str

zmike Over a year ago

@Andre I was able to successfully read the malicious field using Ofek Hod's solution. Is there other JSON input that you are trying to read as well?

Andre Over a year ago

See the rep.it: repl.it/join/kdcmnmou-miguelduarte1

Kokul Jose Over a year ago

This will be the answer if the JSON in Pastebin is the input.

Collectives™ on Stack Overflow

Getting a JSON value with Python

2 Answers 2

2 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related