Extracting Values from a nested JSON 1

[mmiah1982]

Hi,

I'd like to extract certain values from an API call which is returning a nested JSON file.

This is some of the Python I use to call the API:

Current API Call
classification = client.classifyProduct(Text =text, EndpointArn = endpoint ) #API call for document classification, calling custom model via endpoint
QuereyClassification = ['Name']
QuereyClassicationScore = ['Score']
print(QuereyClassification)
print(QuereyClassicationScore)

return {

'body': str(classification) #body returned from our function


}

Sample output below
{
"body": "{'Classes': [{'Name': 'Loans', 'Score': 0.7328000068664551}, {'Name': 'Mortgage', 'Score': 0.14270000159740448}, {'Name': 'Savings', 'Score': 0.0649000033736229}], 'ResponseMetadata': {'RequestId': 'eb8e3b9f-2116-4398-8af4-e15a7ae609fb', 'HTTPStatusCode': 200, 'HTTPHeaders': {'x-amzn-requestid': 'eb8e3b9f-2116-4398-8af4-e15a7ae609fb', 'content-type': 'application/x-amz-json-1.1', 'content-length': '151', 'date': 'Fri, 06 May 2022 18:36:04 GMT'}, 'RetryAttempts': 0}}"
}



Instead of the above output format, I'd like the result to display the the first entry for Name and Score in the list and store into separate variables, from the above example it would be

VarProduct: Loans
VarScore: 0.7328000068664551


Would be great if someone can point me to some code in Python that would achieve this, TIA

 

[mikrom]

Hi mmiah1982,

This works for me:
json_parse.py

[COLOR=#a020f0]import[/color] json
DBG_INFO = [COLOR=#008b8b]False[/color]

my_dictionary = {
[COLOR=#ff00ff]"[/color][COLOR=#ff00ff]body[/color][COLOR=#ff00ff]"[/color]: [COLOR=#ff00ff]"[/color][COLOR=#ff00ff]{'Classes': [{'Name': 'Loans', 'Score': 0.7328000068664551}, {'Name': 'Mortgage', 'Score': 0.14270000159740448}, {'Name': 'Savings', 'Score': 0.0649000033736229}], 'ResponseMetadata': {'RequestId': 'eb8e3b9f-2116-4398-8af4-e15a7ae609fb', 'HTTPStatusCode': 200, 'HTTPHeaders': {'x-amzn-requestid': 'eb8e3b9f-2116-4398-8af4-e15a7ae609fb', 'content-type': 'application/x-amz-json-1.1', 'content-length': '151', 'date': 'Fri, 06 May 2022 18:36:04 GMT'}, 'RetryAttempts': 0}}[/color][COLOR=#ff00ff]"[/color]
}

my_body_string = my_dictionary[[COLOR=#ff00ff]"[/color][COLOR=#ff00ff]body[/color][COLOR=#ff00ff]"[/color]]
[COLOR=#a52a2a][b]if[/b][/color] DBG_INFO: [COLOR=#008b8b]print[/color]([COLOR=#ff00ff]"[/color][COLOR=#ff00ff]my_body_string:[/color][COLOR=#6a5acd]\n[/color][COLOR=#ff00ff]%s[/color][COLOR=#6a5acd]\n[/color][COLOR=#ff00ff]"[/color] % my_body_string)

[COLOR=#0000ff]# for valid JSON replace single quotes with double quotes[/color]
my_json_string = my_body_string.replace([COLOR=#ff00ff]"[/color][COLOR=#ff00ff]'[/color][COLOR=#ff00ff]"[/color], [COLOR=#ff00ff]'[/color][COLOR=#ff00ff]"[/color][COLOR=#ff00ff]'[/color]) 
[COLOR=#a52a2a][b]if[/b][/color] DBG_INFO: [COLOR=#008b8b]print[/color]([COLOR=#ff00ff]"[/color][COLOR=#ff00ff]my_json_string:[/color][COLOR=#6a5acd]\n[/color][COLOR=#ff00ff]%s[/color][COLOR=#6a5acd]\n[/color][COLOR=#ff00ff]"[/color] % my_json_string)

[COLOR=#0000ff]# load and parse JSON[/color]
my_json = json.loads(my_json_string)
[COLOR=#008b8b]print[/color]([COLOR=#ff00ff]"[/color][COLOR=#ff00ff]VarProduct: %s[/color][COLOR=#ff00ff]"[/color] % my_json[[COLOR=#ff00ff]"[/color][COLOR=#ff00ff]Classes[/color][COLOR=#ff00ff]"[/color]][[COLOR=#ff00ff]0[/color]][[COLOR=#ff00ff]"[/color][COLOR=#ff00ff]Name[/color][COLOR=#ff00ff]"[/color]])
[COLOR=#008b8b]print[/color]([COLOR=#ff00ff]"[/color][COLOR=#ff00ff]VarScore: %s[/color][COLOR=#ff00ff]"[/color] % my_json[[COLOR=#ff00ff]"[/color][COLOR=#ff00ff]Classes[/color][COLOR=#ff00ff]"[/color]][[COLOR=#ff00ff]0[/color]][[COLOR=#ff00ff]"[/color][COLOR=#ff00ff]Score[/color][COLOR=#ff00ff]"[/color]])

Result:

$ python3 json_parse.py 
VarProduct: Loans
VarScore: 0.7328000068664551

 

[mmiah1982]

@Mikrom your a Superstar! This works a treat. Thank you for your guidance!

 

[mikrom]

@mmiah1982
You're welcome!