To query and retrieve 100 records from DynamoDB and order them by a sort key column in Node.js, you can use the AWS SDK for JavaScript. Make sure you have the AWS SDK installed and configured. Here's an example code snippet:
const AWS = require('aws-sdk');
AWS.config.update({
region: 'your-dynamodb-region', // Replace with your DynamoDB region
accessKeyId: 'your-access-key-id', // Replace with your AWS access key ID
secretAccessKey: 'your-secret-access-key', // Replace with your AWS secret access key
});
const dynamoDB = new AWS.DynamoDB.DocumentClient();
const tableName = 'your-dynamodb-table-name'; // Replace with your DynamoDB table name
const sortKeyColumn = 'your-sort-key-column'; // Replace with your sort key column name
const params = {
TableName: tableName,
Limit: 100,
ScanIndexForward: true, // Set to false for descending order
KeyConditionExpression: '#sk > :sk', // Replace > with < for descending order
ExpressionAttributeNames: {
'#sk': sortKeyColumn,
},
ExpressionAttributeValues: {
':sk': '0', // Replace with your start key value
},
};
dynamoDB.query(params, (err, data) => {
if (err) {
console.error('Error querying DynamoDB:', err);
} else {
console.log('Queried records:', data.Items);
}
});
Top comments (0)