Python | How to parse JSON from results from AWS response?

Question

I was trying to get the value of VersionLabel which is php-v1 but my code doesn't work properly and I don't know what I'm doing wrong.

Could you please let me know what's wrong and how can I parse the php-v1?

This is my error message.

TypeError: the JSON object must be str, not 'dict'

This is my code.

#!/usr/bin/env python3

import boto3
import json

def get_label():
   try:
      env_name = 'my-env'
      eb = boto3.client('elasticbeanstalk')
      response = eb.describe_instances_health(
         EnvironmentName=env_name,
         AttributeNames=[
            'Deployment'
         ]
      )
      #print(response)
      data = json.loads(response)
      print(data['VersionLabel'])
   except:
      raise

if __name__ == '__main__':
   get_label()

This is the response I got from AWS when print(response) is invoked.

{
   'InstanceHealthList':[  
      {  
         'InstanceId':'i-12345678',
         'Deployment':{  
            'DeploymentId':2,
            'DeploymentTime':datetime.datetime(2016,
            9,
            29,
            4,
            29,
            26,
            tzinfo=tzutc()),
            'Status':'Deployed',
            'VersionLabel':'php-v1'
         }
      }
   ],
   'ResponseMetadata':{  
      'HTTPStatusCode':200,
      'RequestId':'12345678-1234-1234-1234-123456789012',
      'RetryAttempts':0,
      'HTTPHeaders':{  
         'content-length':'665',
         'content-type':'text/xml',
         'date':'Sat, 01 Oct 2016 11:04:56 GMT',
         'x-amzn-requestid':'12345678-1234-1234-1234-123456789012'
      }
   }
}

Thanks so much!

I'm not a boto3 user but it appears that the json decode has already been done for you. Does the dict in response look right to you? — tdelaney
– tdelaney, Commented Oct 1, 2016 at 15:59
If your print(response) is saying such things as datetime.datetime and using single quotes (illegal in JSON), it definitely converted it for you already. — Nick T
– Nick T, Commented Oct 1, 2016 at 16:07
Try commenting out #data = json.loads(response) and add this line instead: print(response['InstanceHealthList'][0]['Deployment']['VersionLabel']). Does this give you the desired result? — B B
– B B, Commented Oct 1, 2016 at 16:14
@tdelaney Thanks for checking! So meaning I have to stop using json module? How can I get the value of the VersionLabel? — devxvda1
– devxvda1, Commented Oct 1, 2016 at 16:15

kost · Accepted Answer · 2024-05-09 12:32:25Z

11

As per the boto3 docs, the describe_instances_health method returns dict and not json. Hence, there is no need for you to do the conversion.

To get VersionLabel from data, use:

data ['InstanceHealthList'][0]['Deployment']['VersionLabel']

Edit : Note that the above fetches the VersionLabel for the first instance, out of possible multiple instances. In case you have multiple instances and they happen to have different values of VersionLabel, then you would require additional logic to get the one you need.

edited May 9, 2024 at 12:32

kost

7298 silver badges22 bronze badges

answered Oct 1, 2016 at 16:26

AnishT

3563 silver badges4 bronze badges

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

1 Comment

rustyMagnet Over a year ago

Thumbs-down for AWS Responses having such deep nesting...

Hari K · Accepted Answer · 2021-08-19 13:41:18Z

6

just incase the ask is to convert the boto response into a legal json format -

import json
response_json = json.dumps(response, default=str))

datetime.datetime needs to be handled during the dict to json conversion

answered Aug 19, 2021 at 13:41

Hari K

2694 silver badges8 bronze badges

Collectives™ on Stack Overflow

Python | How to parse JSON from results from AWS response?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related