php Get items from DynamoDB table using a list

Question

I have an array of usernames and I want to retrieve from a DynamoDB table all the items that contains usernames that exist in the array.

For Example: if my array is:

["Foo","Bar"]

and my table is:

Then i want to get the first item and the last item.

I read the documentation for the scan operation but it doesn't seem to support this type of request.

Is what I'm asking for possible or am i going to have to iterate over my usernames array and retrieve items for each of them separately?

username is the hash key of the table?

notionquest
– notionquest

2017-05-19 09:34:54 +00:00
Commented May 19, 2017 at 9:34 — notionquest
– notionquest, Commented May 19, 2017 at 9:34
@notionquest Yes

John Mikerfield
– John Mikerfield

2017-05-19 13:10:25 +00:00
Commented May 19, 2017 at 13:10 — John Mikerfield
– John Mikerfield, Commented May 19, 2017 at 13:10

notionquest · Accepted Answer · 2017-05-19 13:18:20Z

1

Here is the batch get example. Please note that you may need to execute the batch API until UnprocessedKeys is null.

Batch Get API

var params = {
    "RequestItems" : {
        "yourtablename" : {
            "Keys" : [ {
                "username" : "Foo"              
            },{
                "username" : "Bar"              
            } ],
        }
    },
    "ReturnConsumedCapacity" : "TOTAL"
};

docClient.batchGet(params, function(err, data) {
    if (err) {
        console.error("Unable to read item. Error JSON:", JSON.stringify(err,
                null, 2));
    } else {
        console.log("GetItem succeeded:", JSON.stringify(data, null, 2));
    }
});

edited May 19, 2017 at 13:18

answered May 19, 2017 at 13:13

notionquest

39.4k6 gold badges120 silver badges111 bronze badges

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

Comments

Yeshodhan Kulkarni · Accepted Answer · 2017-05-19 09:42:57Z

0

You may want to use the Batch Get Item API if user name is the Hash Key of the table.

The Batch Get Item API allows you to retrieve multiple items from the DynamoDB table based, provided the keys you provide in the request are part of the HashKey(+RangeKey) or a Global Secondary Index (HashKey (+RangeKey)).

answered May 19, 2017 at 9:42

Yeshodhan Kulkarni

2,9731 gold badge20 silver badges21 bronze badges

1 Comment

John Mikerfield Over a year ago

Can you show me an example of how to do that? The username is my hash key but there's no range key.

Collectives™ on Stack Overflow

php Get items from DynamoDB table using a list

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related