Python - Parsing JSON Data Set

Question

I am trying to parse a JSON data set that looks something like this:

{"data":[
    {
    "Rest":0,
    "Status":"The campaign is moved to the archive",
    "IsActive":"No",
    "StatusArchive":"Yes",
    "Login":"some_login",
    "ContextStrategyName":"Default",
    "CampaignID":1111111,
    "StatusShow":"No",
    "StartDate":"2013-01-20",
    "Sum":0,
    "StatusModerate":"Yes",
    "Clicks":0,
    "Shows":0,
    "ManagerName":"XYZ",
    "StatusActivating":"Yes",
    "StrategyName":"HighestPosition",
    "SumAvailableForTransfer":0,
    "AgencyName":null,
    "Name":"Campaign_01"
    },
    {
    "Rest":82.6200000000008,
    "Status":"Impressions will begin tomorrow at 10:00",
    "IsActive":"Yes",
    "StatusArchive":"No",
    "Login":"some_login",
    "ContextStrategyName":"Default",
    "CampaignID":2222222,
    "StatusShow":"Yes",
    "StartDate":"2013-01-28",
    "Sum":15998,"StatusModerate":"Yes",
    "Clicks":7571,
    "Shows":5535646,
    "ManagerName":"XYZ",
    "StatusActivating":"Yes",
    "StrategyName":"HighestPosition",
    "SumAvailableForTransfer":0,
    "AgencyName":null,
    "Name":"Campaign_02"
    }
    ]
}

Lets assume that there can be many of these data sets.

I would like to iterate through each one of them and grab the "Name" and the "Campaign ID" parameter.

So far my code looks something like this:

decoded_response = response.read().decode("UTF-8")
data = json.loads(decoded.response)

    for item in data[0]:
        for x in data[0][item] ...
            -> need a get name procedure
            -> need a get campaign_id procedure

Probably quite straight forward! I am not good with lists/dictionaries :(

What good is python without lists and dictionaries?

JustinDanielson
– JustinDanielson

2013-05-21 17:37:57 +00:00
Commented May 21, 2013 at 17:37 — JustinDanielson
– JustinDanielson, Commented May 21, 2013 at 17:37

gsamaras · Accepted Answer · 2016-02-09 17:18:01Z

22

Access dictionaries with d[dict_key] or d.get(dict_key, default) (to provide default value):

jsonResponse=json.loads(decoded_response)
jsonData = jsonResponse["data"]
for item in jsonData:
    name = item.get("Name")
    campaignID = item.get("CampaignID")

I suggest you read something about dictionaries.

edited Feb 9, 2016 at 17:18

gsamaras

73.7k50 gold badges210 silver badges330 bronze badges

answered May 21, 2013 at 18:40

Zac

2,2902 gold badges24 silver badges36 bronze badges

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

1 Comment

Aivoric Over a year ago

It worked! Hooray! Also read all about dictionaries. Thank you :-)

Collectives™ on Stack Overflow

Python - Parsing JSON Data Set

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related