AWS Dynamodb: validation error when calling put_item method

Question

The table in dynamodb has 2 columns: timeStamp(string) and tableName(string) when trying to insert datetime as string, it fails with this error:

"errorMessage": "Parameter validation failed:\nInvalid type for parameter Item.timeStamp, value: 2022-03-17 16:46:46.510210, type: <class 'str'>, valid types: <class 'dict'>

here is the code snippet:

import json
import boto3
from datetime import datetime as dt

def put_data(timeStamp, tableName):
    dynamodb = boto3.client('dynamodb')
    
    
    #data = json.loads(json.dumps({"timeStamp":timeStamp ,"tableName":tableName}))
    
    #print(data)
    
    response = dynamodb.put_item(TableName='dev-data-migration-state', Item= {"timeStamp":timeStamp ,"tableName":tableName})
    
    print(response)


def lambda_handler(event, context):
    
    put_data(json.loads(json.dumps(str(dt.now()))), 'orders')

i have tried just doing str(dt.now) but that didn't work either.

Maurice · Accepted Answer · 2022-03-18 06:47:05Z

1

I found the solution, I'm using the client-API, so I needed to put the data in the DynamoDB-JSON format with the data type:

import json
import boto3
from datetime import datetime as dt

def put_data(timeStamp, tableName):
    dynamodb = boto3.client('dynamodb')

    response = dynamodb.put_item(TableName='dev-data-migration-state', 
    Item= {
        "timeStamp":{'S': timeStamp},
        "tableName":{'S': tableName}
    }
    )
    
    print(response)


def lambda_handler(event, context):
    
    put_data(str(dt.now()), 'orders')

edited Mar 18, 2022 at 6:47

Maurice

13.3k2 gold badges31 silver badges55 bronze badges

answered Mar 17, 2022 at 17:27

Sahal Nurain

756 bronze badges

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

Collectives™ on Stack Overflow

AWS Dynamodb: validation error when calling put_item method

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related