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. |
| GlobalUnsubscribes | Query Global Unsubscribes in SendGrid. |
| InvalidEmails | Query and Delete invalid emails in SendGrid. |
| NMCCustomFields | Create, delete, and query New Marketing Campaign Custom Fields in SendGrid. |
| NMCLists | Create, update, delete, and query the available New Marketing Campaign Lists in SendGrid. |
| NMCSegments | Create, update, delete, and query New Marketing Campaign Segments in SendGrid. |
| NMCSenders | Create, update, delete, and query New Marketing Campaign Senders in SendGrid. |
| NMCSingleSends | Create, update, delete, and query the available New Marketing Campaign Single Sends 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. |