key error lambda function dynamodb

Question

Hi,

I am getting the following error when testing a lambda function which exports fields from a dynamodb if they are populated :

"errorMessage": "'Win'",
"errorType": "KeyError",

The lambda function is:

-----
import boto3

def lambda_handler(event, context):
    # Connect to DynamoDB
    dynamodb = boto3.resource('dynamodb')
    table = dynamodb.Table('ticketing')
    
    # Get all items from the table
    items = table.scan()['Items']
    
    # Create a list to hold the filtered items
    filtered_items = []
    
    # Iterate through the items and check if the fields are not empty
    for item in items:
        if item['username'] and item['Win'] and item['Lose'] and item['Score']:
            filtered_items.append({'username': item['username'], 'Win': item['Win'], 'Lose': item['Lose'], 'Score': item['Score']})
            
    # Return the filtered items
    return filtered_items
-------
Can anyone shed some light on this please?

Thank you :-)

Answer

You should first check the items have those keys before using them:

```
for item in items:
    if all(key in item for key in ("username", "Win", "Lose", "Score")):
       if item['username'] and item['Win'] and item['Lose'] and item['Score']:
```

key error lambda function dynamodb

Relevant content