I have a partition key and a sort key on table (DynamoDB)
partition key: ClientID sort key: CaseID
The Delete Code (Lambda):
'use strict';
const AWS = require('aws-sdk');
exports.handler = async (event, context) => {
const documentClient = new AWS.DynamoDB.DocumentClient();
let responseBody = "";
let statusCode = 0;
const {ClientID} = event.pathParameters;
const {CaseID} = event.pathParameters;
const params = {
TableName: "Case",
Key: {
ClientID: ClientID,
CaseID: CaseID
}
};
try {
const data = await documentClient.delete(params).promise();
responseBody = JSON.stringify(data.Items.key);
statusCode = 204;
} catch(err) {
responseBody = `Unable to delete Case: ${err}`;
statusCode = 403;
}
const response = {
statusCode: statusCode,
headers: {
"Content-Type": "application/json",
"access-control-allow-origin":"*"
},
body: responseBody
};
return response;
};
If I try to delete element on API Getaway:
I got this error:
Status: 403 Unable to delete Case: ValidationException: The provided key element does not match the schema
How I can fix this error.
On The AWS Lambda with API Gateway:
I get this error:
Response "errorType": "TypeError", "errorMessage": "Cannot destructure property 'ClientID' of 'event.pathParameters' as it is undefined.",
Thank you.
The issue is in your params:
const params = {
TableName: "Case",
Key: {
ClientID: ClientID,
CaseID: CaseID
}
};
You have constants in your code with the same names as the Key portion of params, so it would be replaced with the constant's value. You should add quotes around your keys:
const params = {
TableName: "Case",
Key: {
"ClientID": ClientID,
"CaseID": CaseID
}
};
Option 2 I had a similar issue in Python, where I had to add types of data as well (basically it's DynamoDB JSON)
const params = {
TableName: "Case",
Key: {
"ClientID": {"S": ClientID},
"CaseID": {"S": CaseID}
}
};
According to the documentation (for proxy integrations) pathParameters is null, so both ClientID and CaseID will come empty and you will get an error from DynamoDB, when you try to get an item. Examine the format of the input format and modify your code accordingly.