The Sendgrid source supports Full Refresh syncs. That is, every time a sync is run, Airbyte will copy all rows in the tables and columns you set up for replication into the destination in a new table.
Note: SendGrid provides two different kinds of marketing campaigns, "legacy marketing campaigns" and "new marketing campaigns". Legacy marketing campaigns are not supported by this source connector. If you are seeing a 403 FORBIDDEN error message for https://api.sendgrid.com/v3/marketing/campaigns, it might be because your SendGrid account uses legacy marketing campaigns.
Several output streams are available from this source (campaigns, lists).
If there are more endpoints you'd like Airbyte to support, please create an issue.
| Feature | Supported? |
|---|---|
| Full Refresh Sync | Yes |
| Incremental Sync | Coming soon |
| Replicate Incremental Deletes | Coming soon |
| SSL connection | Yes |
| Namespaces | No |
The connector is restricted by normal Sendgrid requests limitation.
The Sendgrid connector should not run into Sendgrid API limitations under normal usage. Please create an issue if you see any rate limit issues that are not automatically retried successfully.
- Sendgrid Account
- Sendgrid API Key with the following permissions:
- Read-only access to all resources
- Full access to marketing resources
Generate a API key using the Sendgrid documentation.
We recommend creating a key specifically for Airbyte access. This will allow you to control which resources Airbyte should be able to access. The API key should be read-only on all resources except Marketing, where it needs Full Access.
To consume Messages resources requires to purchase an extra on Sendgrid. You can read more about this here
| Version | Date | Pull Request | Subject |
|---|---|---|---|
| 0.2.8 | 2022-06-07 | 13571 | Add Message stream |
| 0.2.7 | 2021-09-08 | 5910 | Add Single Sends Stats stream |
| 0.2.6 | 2021-07-19 | 4839 | Gracefully handle malformed responses from the API |