Sendgrid

Overview

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.

Output schema

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.

Features

Feature

Supported?

Full Refresh Sync

Yes

Incremental Sync

Coming soon

Replicate Incremental Deletes

Coming soon

SSL connection

Yes

Namespaces

No

Performance considerations

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.

Getting started

Requirements

  • Sendgrid Account

  • Sendgrid API Key with the following permissions:

    • Read-only access to all resources

    • Full access to marketing resources

Setup guide

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.

Version

Date

Pull Request

Subject

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