Take particular Key and values from JSON response using python?

Question

I have a different kind of JSON format. I am stuck on how to get the 1st Key alone.

My JSON RESPONSE:

resp={
"root[0]": {
"Name": "res1",
"region": "ca-1",
"tags": [
  {
    "name": "Environment",
    "value": "TC1"
  },     
  {
    "name": "Test",
    "value": "yes"
  }
]
},
"root[3]": {
"Name": "Demo",
"region": "ca-1",
"tags": [
  {
    "name": "Test1",
    "value": "check"
  },

  {
    "name": "Test12",
    "value": "yes"
  }
]

} }

I want to take the Name and Region key and values alone. Note that root[] will have any number inside so I cant explicitly put the number as it changes every time.

Python Code

test = resp.get('Name')
test2= resp.get('region')
print(test,test2)
##Both prints None

Expected:

 "Name": "res1",
 "region": "ca-1",
 "Name": "Demo",
 "region": "ca-1"

Linh Nguyen · Accepted Answer · 2019-12-04 10:02:45Z

2

Pretty simple task if you loop through the dict:

test = {
"root[0]": {
"Name": "res1",
"region": "ca-1",
"tags": [
  {
    "name": "Environment",
    "value": "TC1"
  },     
  {
    "name": "Test",
    "value": "yes"
  }
]
},
"root[3]": {
"Name": "Demo",
"region": "ca-1",
"tags": [
  {
    "name": "Test1",
    "value": "check"
  },

  {
    "name": "Test12",
    "value": "yes"
  }
]
}}
for k in test:
  print(test[k]["Name"])
  print(test[k]["region"])

answered Dec 4, 2019 at 10:02

Linh Nguyen

3,9605 gold badges35 silver badges77 bronze badges

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

Comments

Rakesh · Accepted Answer · 2019-12-04 10:01:00Z

1

One approach is to iterate the dict.

Ex:

for _, v in resp.items():
    print(v['Name'], v['region'])

Output:

res1 ca-1
Demo ca-1

answered Dec 4, 2019 at 10:01

Rakesh

82.9k17 gold badges85 silver badges122 bronze badges

Comments

Riccardo Bucco · Accepted Answer · 2019-12-04 10:05:02Z

1

If you want to obtain the values related to a specific key of your resp object (for example, "root[0]") you can use the following solution:

number = 0 # your chosen number (the one inside root)
name = resp[f"root[{number}]"]["Name"]
region = resp[f"root[{number}]"]["region"]

edited Dec 4, 2019 at 10:05

answered Dec 4, 2019 at 10:00

Riccardo Bucco

15.5k4 gold badges29 silver badges57 bronze badges

Comments

Bharat Kul Ratan · Accepted Answer · 2019-12-04 10:06:01Z

1

a rough approach given resp is your provided dict:

for k, v in resp.items():
    for kk, vv in v.items():
        if kk == "Name" or kk == "region":
            print(kk, vv)

output would be:

Name res1
region ca-1
Name Demo
region ca-1

answered Dec 4, 2019 at 10:06

Bharat Kul Ratan

1,0032 gold badges14 silver badges25 bronze badges

Collectives™ on Stack Overflow

Take particular Key and values from JSON response using python?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related