Key Value Pair output

[UtiliseIT]

It's fair to guess that rows is returned from query to database, so it is list/tuple of tuples. You need to convert it to dict, before pass to json.dumps()

import json
rows = [(1, "Apple"), (2, "Banana"), (3, "Orange")]
print(json.dumps(rows))
print(json.dumps(dict(rows)))

Output:
[[1, "Apple"], [2, "Banana"], [3, "Orange"]]
{"1": "Apple", "2": "Banana", "3": "Orange"}
>>>

Thanks Buran,

You are correct in that this is results from a query. The code also executes inside a AWS Lambda function.

Ive modified my code to

return {
        'statusCode': 200,
        'headers': {'Access-Control-Allow-Origin': '*',
        'Content-Type': 'application/json'},
        "body": json.dumps(dict((rows))
    }

But am getting syntax error

Im told that output should be

{
"body": [{
"Id”: "1”,
"Fruit”: "Apple”
},{
"Id”: "2”,
"Fruit”: "Banana”
}]
}