# Reading from SendGrid entities
<a name="sendgrid-reading-from-entities"></a>

**Prerequisite**

A SendGrid object you would like to read from. You will need the object name such as `lists`, `singlesends` or `segments`.

**Supported entities for source**:


| Entity | Can be filtered | Supports limit | Supports Order by | Supports Select \$1 | Supports partitioning | 
| --- | --- | --- | --- | --- | --- | 
| Lists | No | Yes | No | Yes | No | 
| Single Sends | Yes | Yes | No | Yes | No | 
| Marketing Campaign Stats-Automations | Yes | Yes | No | Yes | No | 
| Marketing Campaign Stats-Single Sends | Yes | Yes | No | Yes | No | 
| Segments | Yes | No | No | Yes | No | 
| Contacts | Yes | No | No | Yes | No | 
| Category | No | No | No | Yes | No | 
| Stats | Yes | No | No | Yes | No | 
| Unsubscribe Groups | Yes | No | No | Yes | No | 

**Example**:

```
sendgrid_read = glueContext.create_dynamic_frame.from_options(
    connection_type="sendgrid",
    connection_options={
        "connectionName": "connectionName",
        "ENTITY_NAME": "lists",
        "API_VERSION": "v3",
        "INSTANCE_URL": "instanceUrl"
    }
```

**SendGrid entity and field details**:

Entities with static metadata:

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

**Note**  
Struct and List data types are converted to String data type, and DateTime data type is converted to Timestamp in the response of the connectors.

## Partitioning queries
<a name="sendgrid-reading-partitioning-queries"></a>

SendGrid doesn't support filter-based partitioning or record-based partitioning.