SendGrid
SendGrid ETL connector for data replication
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 | |
- 1.Generate Sendgrid API Key for Daton
- 2.
- 1.Signin to Daton
- 2.Select SendGrid from Integrations page
- 3.Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
- 4.Provide SendGrid API Key and Email Address to authorize Daton to periodically extract data from SendGrid
- 5.Post successful authentication, you will be prompted to choose from the list of available tables
- 6.Then select all required fields for each table
- 7.Submit the integration
- 1.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
- 2.Users would be able to edit/pause/re-activate/delete integration anytime
- 3.Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Bounce
Purpose: This endpoint allows you to retrieve all of your bounces.
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.
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.
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.
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.
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.
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.
Replication: Key-Based Replication
Replication Key: created
Fields
Name | Target Datatype |
created | INTEGER |
email | 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.
Replication: Key-Based Replication
Replication Key: created
Fields
Name | Target Datatype |
id | INTEGER |
name | STRING |
recipient_count | INTEGER |
Segments
Purpose: This endpoint allows you to retrieve all of your segments.
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.
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.
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | INTEGER |
name | STRING |
versions | RECORD |
generation | STRING |
Last modified 3yr ago