Python loop through nested JSON object without root element [duplicate]

Question

I've already checked here and here.

I have the following json which has no root element and I want to loop through each item in objects and print the value for object_code:

{
  "count": 3,
  "objects": [
    {
      "object_code": "HN1059"
    },
    {
      "object_code": "HN1060"
    },
    {
      "object_code": "VO1013"
    }
  ]
}

I tried:

json='{"count": 3,"objects": [{"object_code": "HN1059"},{"object_code": "HN1060"},{"object_code": "VO1013"}]}'

for obj in json['objects']:
    print(obj.get('object_code'))


for obj in json[0]['objects']:
    print(obj.get('object_code'))

Neither work and I get the error:

TypeError: string indices must be integers

UPDATE 1

The suggested solutions don't work for me, maybe that's because I'm using it in the context of a Scrapy class, here's the full code that throws error

TypeError: 'NoneType' object is not iterable

import json
import scrapy

class MySpider(scrapy.Spider):
    name = 'mytest'
    start_urls = []

    def start_requests(self):
        s='{"count": 3,"objects": [{"object_code": "HN1059"},{"object_code": "HN1060"},{"object_code": "VO1013"}]}'
        obj = json.loads(s)
        for o in obj['objects']:
            print(o.get('object_code'))

your json contains JSON content : so a string, not a python structure — azro
– azro, Commented Dec 21, 2022 at 20:25
Your JSON is a string (thank you for correctly using the word JSON!). But why do you think you can manipulate that serialized data like unserialized data? — juanpa.arrivillaga
– juanpa.arrivillaga, Commented Dec 21, 2022 at 20:29
You could post a new question about your update. Include Scrapy in the tags if it's required to reproduce the issue. See minimal reproducible example. — wjandrea
– wjandrea, Commented Dec 21, 2022 at 21:38
@wjandrea I'll do that. As a best practice, should I delete this question since it's a duplicate anyway? Or would that not be fair to folks who already provided answers? — Adam
– Adam, Commented Dec 22, 2022 at 7:20
@wjandrea just tried to delete, I indeed can't "You cannot delete this question as others have invested time and effort into answering it." — Adam
– Adam, Commented Dec 23, 2022 at 9:56

azro · Accepted Answer · 2022-12-21 20:26:00Z

2

You need to load fom the JSON content to python structure

import json

value = '{"count": 3,"objects": [{"object_code": "HN1059"},{"object_code": "HN1060"},{"object_code": "VO1013"}]}'
content = json.loads(value)

for obj in content['objects']:
    print(obj.get('object_code'))

answered Dec 21, 2022 at 20:26

azro

54.2k9 gold badges38 silver badges75 bronze badges

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

Comments

Unmitigated · Accepted Answer · 2022-12-21 20:26:09Z

0

Use json.loads to convert the JSON string to a dict.

import json
s='{"count": 3,"objects": [{"object_code": "HN1059"},{"object_code": "HN1060"},{"object_code": "VO1013"}]}'
obj = json.loads(s)
for o in obj['objects']:
    print(o.get('object_code'))

answered Dec 21, 2022 at 20:26

Unmitigated

91.4k12 gold badges102 silver badges109 bronze badges

6 Comments

Adam Over a year ago

This gives me error TypeError: 'NoneType' object is not iterable

Unmitigated Over a year ago

@Adam It runs fine: ideone.com/v0Zx7H

Unmitigated Over a year ago

@Adam Please provide a minimal reproducible example if there is a problem.

Unmitigated Over a year ago

@Adam Maybe your problem is related to this: stackoverflow.com/questions/45784067/scrapy-on-a-json-response

Adam Over a year ago

I don't think so. That actually loads and tries to parse a Scrapy response object, but I'm just trying to parse a string, I never do anything with a response object...

|

Collectives™ on Stack Overflow

Python loop through nested JSON object without root element [duplicate]

2 Answers 2

Comments

6 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Linked

Related