SendGrid
SendGrid ETL connector for data replication
SendGrid
SendGrid ETL connector for data replication
Snapshot
Features |
Details |
Release Status |
Released |
Source API Version |
v3 |
Table Selection |
Yes |
Column Selection |
Yes |
Edit Integration |
Yes |
Replication Type Selection |
No |
Authentication Parameters |
SendGrid API Key SendGrid Email Address |
Replication Type |
Key Based Replication Full Replication |
Replication Key |
Date |
Suggested Replication Frequency |
24 hrs |
| Tables/APIs Supported | |
Bounce |
GlobalSuppression |
Campaign |
Blocks |
Contacts |
Groups |
Invalid |
ListAll |
Segments |
SpamReports |
Templates |
Pre-requisites
- Generate Sendgrid API Key for Daton
- Read more on How to create Sendgrid API Keys here
Integrate SendGrid with Daton
- Signin to Daton
- Select SendGrid from Integrations page
- Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
- Provide SendGrid API Key and Email Address to authorize Daton to periodically extract data from SendGrid
- Post successful authentication, you will be prompted to choose from the list of available tables
- Then select all required fields for each table
- Submit the integration
Workflow
- Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
- Users would be able to edit/pause/re-activate/delete integration anytime
- Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
SendGrid Data
Bounce
Purpose: This endpoint allows you to retrieve all of your bounces.
Source API Documentation https://sendgrid.com/docs/api-reference/
Replication: Key-Based Replication
Replication Key: created
Fields
Name |
Target Datatype |
email |
STRING |
created |
INTEGER |
reason |
STRING |
status |
NUMERIC |
GlobalSuppression
Purpose: This endpoint allows you to retrieve a list of all email address that are globally suppressed.
Source API Documentation https://sendgrid.com/docs/api-reference/
Replication: Key-Based Replication
Replication Key: created
Fields
Name |
Target Datatype |
email |
STRING |
created |
INTEGER |
Campaign
Purpose: This endpoint allows you to retrieve a list of all of your campaigns.
Source API Documentation https://sendgrid.com/docs/api-reference/
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
id |
INTEGER |
title |
STRING |
subject |
STRING |
sender_id |
INTEGER |
list_ids |
RECORD |
segment_ids |
RECORD |
categories |
RECORD |
suppression_group_id |
INTEGER |
custom_unsubscribe_url |
STRING |
ip_pool |
STRING |
html_content |
STRING |
plain_content |
STRING |
status |
STRING |
Blocks
Purpose: This endpoint allows you to retrieve a list of all email addresses that are currently on your blocks list.
Source API Documentation https://sendgrid.com/docs/api-reference/
Replication: Key-Based Replication
Replication Key: created
Fields
Name |
Target Datatype |
email |
STRING |
created |
INTEGER |
| status | STRING |
Contacts
Purpose: This endpoint allows you to add a Marketing Campaigns recipient.
Source API Documentation https://sendgrid.com/docs/api-reference/
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
created_at |
INTEGER |
email |
STRING |
first_name |
STRING |
id |
STRING |
last_clicked |
STRING |
last_emailed |
STRING |
last_name |
STRING |
last_opened |
STRING |
updated_at |
STRING |
custom_fields |
RECORD |
Groups
Purpose: This endpoint allows you to retrieve a list of all suppression groups created by this user.
Source API Documentation https://sendgrid.com/docs/api-reference/
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
id |
INTEGER |
name |
STRING |
description |
STRING |
last_email_sent_at |
STRING |
is_default |
BOOLEAN |
unsubscribes |
INTEGER |
Invalid
Purpose: This endpoint allows you to retrieve a list of all invalid email addresses.
Source API Documentation https://sendgrid.com/docs/api-reference/
Replication: Key-Based Replication
Replication Key: created
Fields
Name |
Target Datatype |
email |
INTEGER |
created |
STRING |
| reason | STRING |
ListAll
Purpose: This endpoint allows you to retrieve all of your recipient lists. If you don't have any lists, an empty array will be returned.
Source API Documentation https://sendgrid.com/docs/api-reference/
Replication: Key-Based Replication
Replication Key: created
Fields
Name |
Target Datatype |
email |
INTEGER |
created |
STRING |
| recipient_count | INTEGER |
Segments
Purpose: This endpoint allows you to retrieve all of your segments.
Source API Documentation https://sendgrid.com/docs/api-reference/
Replication: Key-Based Replication
Replication Key: created_at
Fields
Name |
Target Datatype |
id |
INTEGER |
name |
STRING |
| recipient_count | INTEGER |
| conditions | RECORD |
SpamReports
Purpose: This endpoint allows you to retrieve all spam reports.
Source API Documentation https://sendgrid.com/docs/api-reference/
Replication: Key-Based Replication
Replication Key: created
Fields
Name |
Target Datatype |
email |
STRING |
created |
INTEGER |
| status | STRING |
Templates
Purpose: This endpoint allows you to retrieve all transactional templates.
Source API Documentation https://sendgrid.com/docs/api-reference/
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
id |
INTEGER |
name |
STRING |
| versions | RECORD |
| generation | STRING |