

# Reading from Smartsheet entities
<a name="smartsheet-reading-from-entities"></a>

 **Prerequisites** 

A `Smartsheet` Object you would like to read from. Refer the supported entities table below to check the available entities. 

 **Supported entities** 


| Entity | Can be Filtered | Supports Limit | Supports Order By | Supports Select \$1 | Supports Partitioning | 
| --- | --- | --- | --- | --- | --- | 
| List Sheet | Yes | Yes | No | Yes | No | 
| Row Metadata | Yes | Yes | No | Yes | No | 
| Sheet Metadata | No | No | No | Yes | No | 
| Sheet Data | Yes | Yes | Yes | Yes | No | 
| Event | Yes | Yes | No | Yes | No | 

 **Example** 

```
Smartsheet_read = glueContext.create_dynamic_frame.from_options(
    connection_type="smartsheet",
    connection_options={
        "connectionName": "connectionName",
        "ENTITY_NAME": "list-sheets",
        "API_VERSION": "2.0",
        "INSTANCE_URL": "https://api.smartsheet.com"
    })
```

 **Smartsheet entity and field details** 

[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/glue/latest/dg/smartsheet-reading-from-entities.html)