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

1. Generate Sendgrid API Key for Daton

2. Read more on How to create Sendgrid API Keys here

Integrate SendGrid with Daton

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

Workflow

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

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
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.

Source API Documentation https://sendgrid.com/docs/api-reference/

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.

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