[Yandex Cloud documentation](../../../../index.md) > [Yandex Managed Service for YDB](../../../index.md) > Amazon DynamoDB-compatible Document API > [Document API reference](../index.md) > Actions > Scan # Scan method Returns items and attributes from the specified table. By default, this method returns all items, but not more than 1 MB or up to 100 records per call. If the table contains more data, the last primary key evaluated by the scan operation will be retuned under `LastEvaluatedKey`. You can use it to continue scanning. Filters specified in `FilterExpression` only apply after the main selection. By default, the method returns eventually consistent data from the table. To get strongly consistent data, set `ConsistentRead=true`. ## Request The request contains data in JSON format. ```json { "ConditionalOperator": "string", "ConsistentRead": boolean, "ExclusiveStartKey": { "string" : { "B": blob, "BOOL": boolean, "BS": [ blob ], "L": [ "AttributeValue" ], "M": { "string" : "AttributeValue" }, "N": "string", "NS": [ "string" ], "NULL": boolean, "S": "string", "SS": [ "string" ] } }, "ExpressionAttributeNames": { "string" : "string" }, "ExpressionAttributeValues": { "string" : { "B": blob, "BOOL": boolean, "BS": [ blob ], "L": [ "AttributeValue" ], "M": { "string" : "AttributeValue" }, "N": "string", "NS": [ "string" ], "NULL": boolean, "S": "string", "SS": [ "string" ] } }, "FilterExpression": "string", "IndexName": "string", "Limit": number, "ProjectionExpression": "string", "ReturnConsumedCapacity": "string", "ScanFilter": { "string" : { "AttributeValueList": [ { "B": blob, "BOOL": boolean, "BS": [ blob ], "L": [ "AttributeValue" ], "M": { "string" : "AttributeValue" }, "N": "string", "NS": [ "string" ], "NULL": boolean, "S": "string", "SS": [ "string" ] } ], "ComparisonOperator": "string" } }, "Select": "string", "TableName": "string" } ``` ### Parameters Parameter | Description ----- | ----- `TableName` | Name of the table with the requested data.
It may contain a path in the hierarchical directory structure in `path/to/table` format.

**Type**: String
**Length**: 3 to 255 characters.
**Template**: [a-zA-Z0-9_.-]+
**Required**: Yes `ConsistentRead` | Consistency of data reads.
`true` enables strongly consistent reads; `false` (by default) enables sequential reads.
It is not supported for global secondary indexes. If you try to scan a secondary index set to `true`, the method will return `ValidationException`.

**Type**: Boolean
**Required**: No `ExclusiveStartKey` | Primary key of the item for the method to start a search from.
If the method returned `LastEvaluatedKey` in response to the previous request, use this value to continue the search from the last evaluated key.

**Type**: Object of the `AttributeValue` type
**Key length**: Up to 65,535.
**Required**: No `ExpressionAttributeNames` | Placeholder for an attribute name in an expression. The placeholder must start with the hash character, `#`.
You can use it in the following cases:For example, the `Percentile` attribute name conflicts with the reserved word, so you cannot use it explicitly in an expression. To fix this issue, specify the `{"#P":"Percentile"}` placeholder in the `ExpressionAttributeNames` parameter, and then, further on, use `#P` instead of the real attribute name.

**Type**: String
**Length**: 1 to 65,535 characters.
**Required**: No `ExpressionAttributeValues` | Placeholder for an attribute name in an expression, same as `ExpressionAttributeNames`. The placeholder must start with a `:` character.
For example, you need to check whether the value of the `ProductStatus` attribute was one of the following: `Available` \| `Backordered` \| `Discontinued`. To do this, first declare placeholders: `{ ":avail":{"S":"Available"}, ":back":{"S":"Backordered"}, ":disc":{"S":"Discontinued"} }`. Now you can use them in the expression: `ProductStatus IN (:avail, :back, :disc)`

**Type**: String of the `AttributeValue` type
**Required**: No `FilterExpression` | Conditions to apply after the initial data selection.
Items not meeting this condition will not be included in the final response.
**Type**: String
**Required**: No `IndexName` | Name of the global secondary index to scan. Please note that if you use this parameter, you must also specify `TableName`.
**Type**: String
**Length**: 3 to 255 characters.
**Template**: [a-zA-Z0-9_.-]+
**Required**: No `Limit` | Maximum number of items to evaluate for the selection.
As soon as the method processes the specified number of items, it will stop and return the result up to the last evaluated item. In this case, the `LastEvaluatedKey` parameter will contain the last key that the method evaluated. You can use it to continue scanning from the last evaluated key.

**Type**: Integer
**Range**: Minimum value is 1.
**Required**: No `ProjectionExpression` | Expression that defines attributes to get. The attributes must be comma-separated.
If you do not explicitly specify the attribute names, all item attributes will be returned.

**Type**: String
**Required**: No `ReturnConsumedCapacity` | Sets whether to return information about the consumed capacity.
**Type**: String
**Possible values**: `TOTAL` \| `NONE`
**Required**: No `Select` | Attributes to return.
Possible values:
**Type**: String
**Valid values**: `ALL_ATTRIBUTES` \| `COUNT`
**Required**: No ## Response If successful, HTTP code 200 is returned. You will get data in JSON format. ```json { "ConsumedCapacity": { "CapacityUnits": number, "GlobalSecondaryIndexes": { "string" : { "CapacityUnits": number, "ReadCapacityUnits": number, "WriteCapacityUnits": number } }, "LocalSecondaryIndexes": { "string" : { "CapacityUnits": number, "ReadCapacityUnits": number, "WriteCapacityUnits": number } }, "ReadCapacityUnits": number, "Table": { "CapacityUnits": number, "ReadCapacityUnits": number, "WriteCapacityUnits": number }, "TableName": "string", "WriteCapacityUnits": number }, "Count": number, "Items": [ { "string" : { "B": blob, "BOOL": boolean, "BS": [ blob ], "L": [ "AttributeValue" ], "M": { "string" : "AttributeValue" }, "N": "string", "NS": [ "string" ], "NULL": boolean, "S": "string", "SS": [ "string" ] } } ], "LastEvaluatedKey": { "string" : { "B": blob, "BOOL": boolean, "BS": [ blob ], "L": [ "AttributeValue" ], "M": { "string" : "AttributeValue" }, "N": "string", "NS": [ "string" ], "NULL": boolean, "S": "string", "SS": [ "string" ] } }, "ScannedCount": number } ``` ### Parameters Parameter | Description ----- | ----- `ConsumedCapacity` | Capacity units consumed by a delete operation.
It is returned only if you provide `ReturnConsumedCapacity` set to `TOTAL` in the request.

**Type**: Object of the `ConsumedCapacity` type. `Count` | Number of items in a response.
If you used `FilterExpression` in your request, then it is the number of items returned after applying the filter.

**Type**: Integer `Items` | Array of attributes that match the scan criteria.
Each item in the array consists of the name and value of this attribute.

**Type**: Array of objects of the `AttributeValue` type
**Key length**: 1 to 65,535 characters. `LastEvaluatedKey` | Primary key of the last evaluated item. Use this value to continue scanning from the last evaluated key. Empty `LastEvaluatedKey` means that the method processed all items and there is nothing more to return.

**Type**: Associative array of the `AttributeValue` type
**Key length**: 1 to 65,535 characters. `ScannedCount` | Number of items found before using the `FilterExpression` filters.

**Type**: Integer ## Errors Parameter | Description ----- | ----- `InternalServerError` | An internal error occurred on the server side.

**HTTP status code**: 500
`ProvisionedThroughputExceededException` | Your request rate is too high. Try to reduce the frequency of requests.
If their number is not too large, Managed Service for YDB will try to process them all.

**HTTP status code**: 400 `RequestLimitExceeded` | The throughput capacity exceeds the set quota.

**HTTP status code**: 400 `ResourceNotFoundException` | The requested table does not exist.

**HTTP status code**: 400 There may be some [common errors](../../common-errors.md) as well shared by all methods.