How to use LastEvaluatedKey in ExecuteStatement request?

Question

According to the documentation for [ExecuteStatement](https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_ExecuteStatement.html):
> If `LastEvaluatedKey` is present in the response, you need to paginate the result set.

How can I use `LastEvaluatedKey` if `ExecuteStatement` request has no `ExclusiveStartKey` parameter as `Scan` and `Query`.

I cannot use `NextToken` because it is not returned when `Limit` is specified.

Accepted Answer

This is something the team are currently working on. When you use `Limit` you are not returned a NextToken, but a `LastEvaluatedKey`, and due to the lack of `ExclusiveStartKey` it cannot be used for Pagination. Unfortunately I do not have an ETA on the fix, but it is being worked on priority.

For now, if you are using Query you can alter your request to add the SK of the `LastEvaluatedKey`:

`SELECT * FROM mytable WHERE PK='x' AND SK > {SK returned in LEK}`

Hope that helps

How to use LastEvaluatedKey in ExecuteStatement request?

相关内容