Parsing JSON in Python

Question

I have below query stored in a variable I got and I need to fetch value of 'resource_status'.

I need 'UPDATE_IN_PROGRESS'

As requested, putting the code here. The variable evntsdata is storing the events list.

try:
    evntsdata = str(hc.events.list(stack_name)[0]).split(" ") # this is the variable that is getting the JSON response (or so) 

    #print(evntsdata[715:733])
    #event_handle = evntsdata[715:733]

    if event_handle == 'UPDATE_IN_PROGRESS':
        loopcontinue = True
        while loopcontinue:
            evntsdata = str(hc.events.list(stack_name)[0]).split(" ")
            #event_handle = evntsdata[715:733]
            if (event_handle == 'UPDATE_COMPLETE'):
                loopcontinue = False
                print(str(timestamp()) + " " + "Stack Update is Completed!" + ' - ' + evntsdata[-3] + ' = ' + evntsdata[-1])
            else:
                print(str(timestamp()) + " " + "Stack Update in Progress!" + ' - ' + evntsdata[-3] + ' = ' + evntsdata[-1])
                time.sleep(10)
    else:
        print("No updates to perform")
        exit(0)

except AttributeError as e:
   print(str(timestamp()) + " " + "ERROR: Stack Update Failure")
   raise

print(evntsdata) has below result

   ['<Event', "{'resource_name':", "'Stackstack1',", "'event_time':", "'2017-05-26T12:10:43',", "'links':", "[{'href':", "'x',", "'rel':", "'self'},", "{'href':", "'x',", "'rel':", "'resource'},", "{'href':", "'x',", "'rel':", "'stack'}],", "'logical_resource_id':", "'Stackstack1',", "'resource_status':", "'UPDATE_IN_PROGRESS',", "'resource_status_reason':", "'Stack", 'UPDATE', "started',", "'physical_resource_id':", "'xxx',", "'id':", "'xxx'}>"]

This isn't JSON. Looks like you've printed some Event object. Please show your code with an edit and also include your attempts at parsing this — OneCricketeer
– OneCricketeer, Commented May 26, 2017 at 12:05
please check the edit. Let me know if you need any other info — Heenashree Khandelwal
– Heenashree Khandelwal, Commented May 26, 2017 at 12:13
Whatever hc.events.list(stack_name)[0] is you should not str() and .split() it. This is wrong on so many levels. I assume this Event class has some methods to retrieve the field you are looking for. Use them. — freakish
– freakish, Commented May 26, 2017 at 12:15
Yes, the other info would be a minimal reproducible example. Please read carefully and edit again. What is hc, for example? — OneCricketeer
– OneCricketeer, Commented May 26, 2017 at 12:18
@HeenashreeKhandelwal Do not listen to that. This is wrong. This Event object has to have this dictionary inside. You just need a way to retrieve it. Usually you look for something like .data or .content. You seriously want to str it, do shenanigans to remove the envelope and then parse it (which will be hard since this is not JSON)? This is plainly stupid. Read the documentation of this Event class and try to retrieve the data properly. — freakish
– freakish, Commented May 26, 2017 at 12:25

freakish · Accepted Answer · 2017-05-26 12:34:37Z

1

Do not serialize and parse objects when the data is in front of you. This is inefficient and hard to understand and maintain. The solution is quite trivial:

data = hc.events.list(stack_name)[0].to_dict()
event_handle = data['resource_status']

answered May 26, 2017 at 12:34

freakish

57k12 gold badges141 silver badges181 bronze badges

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

Comments

OneCricketeer · Accepted Answer · 2017-05-26 12:43:05Z

0

It's not JSON, it's a class that you've printed

class Event(base.Resource):
    def __repr__(self):
        return "<Event %s>" % self._info

Try poking around the source code to get access to the dictionary self._info, then access your fields according

For example,

event_info = hc.events.list(stack_name)[0]._info
event_handle = event_info['resource_status']

Though, there may be another way like calling to_dict() instead, since the underscore indicates a private variable

edited May 26, 2017 at 12:43

answered May 26, 2017 at 12:28

OneCricketeer

193k20 gold badges146 silver badges276 bronze badges

4 Comments

freakish Over a year ago

The only thing I would not do is to use _info (which suggests its a private object). Actually this Event class does have a proper to_dict() method.

OneCricketeer Over a year ago

I didn't bother looking at the base class

Heenashree Khandelwal Over a year ago

This is so tricky. This github link has that actual code but I really didnt want to go that far. I just want the resource status. github.com/openstack/python-heatclient/blob/master/heatclient/….

OneCricketeer Over a year ago

Sometimes you need to actually read the documentation (code included) to get your information

Collectives™ on Stack Overflow

Parsing JSON in Python

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related