Tables
The driver models the data in SendGrid into a list of tables that can be queried using standard SQL statements.
Generally, querying SendGrid tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
CData JDBC Driver for SendGrid Tables
| Name | Description |
| Alerts | Create, update, delete, and query Alerts in SendGrid. |
| ApiKeys | Query, Create, Update and Delete the available ApiKeys in SendGrid. |
| Blocks | Query and Delete the available Blocks in SendGrid. |
| Bounces | Query and Delete the available Bounces in SendGrid. |
| CancelScheduledSends | Update, delete, and query Cancel Scheduled Sends in SendGrid. |
| CustomFields | Create, delete, and query Custom Fields in SendGrid. |
| GlobalUnsubscribes | Query Global Unsubscribes in SendGrid. |
| InvalidEmails | Query and Delete invalid emails in SendGrid. |
| Lists | Create, update, delete, and query the available Lists in SendGrid. |
| MarketingCampaigns | Create, update, delete, and query Marketing Campaigns in SendGrid. |
| Recipients | The SendGrid table Recipients. |
| Schedules | Create, update, delete, and query Campaign Schedules in SendGrid. |
| Segments | Create, update, delete, and query Segments in SendGrid. |
| SenderIdentities | Create, update, delete, and query Sender Identities in SendGrid. |
| Spam | Query and delete Spam reports in SendGrid. |
| Teammates | Query Teammates in SendGrid. |
| UnsubscribeGroups | Create, update, delete, and query Unsubscribe Groups in SendGrid. |