pythonjsonaws-lambdaamazon-dynamodbjson-serialization

Object of type 'Decimal' is not JSON serializable : AWS Lambda - DynamoDB


Lambda execution failed with status 200 due to customer function error: Object of type 'Decimal' is not JSON serializable

I went through all the existing solutions in the following link but nothing worked for me. What am I doing wrong?: Python JSON serialize a Decimal object

import json
import boto3
import decimal


client = boto3.resource('dynamodb')
table = client.Table('table')

def lambda_handler(event, context):
    method = event["httpMethod"]
    print(event)
    if method=="POST":
        return POST(event)
    elif method=="DELETE":
        return DELETE(event)
    elif method=="GET":
        return GET(event)

#the respons format
def send_respons(responseBody, statusCode):
    response = {
        "statusCode": statusCode,
        "headers": {
            "my_header": "my_value"
        },
        "body": json.dumps(responseBody),
        "isBase64Encoded": 'false'
    }
    return response
    

def GET(event):
    tab = table.scan()['Items']
    ids = []
            for item in tab:
                    ids.append({"id":item["id"], "decimalOBJ":decimal.Decimal(item["decimalOBJ"]}))
            return send_respons(ids, 201)

Solution

  • It seems you have two options:

    1. Probably easiest, you can serialize the int/float value of a Decimal object:

    """ assume d is your decimal object """

    serializable_d = int(d) # or float(d)

    d_json = json.dumps(d)

    1. You can add simplejson to your requirements.txt, which now has support for serializing Decimals. It's a drop-in replacement for the included json module.
    import simplejson as json # instead of import json
    

    The rest of your code will work the same. If you need further assistance, kindly leave a comment.