Introduction

...

Configurables

Batch source

StandardapikeyLogin password username specified above

Section	User Configuration Label	Label Description	Options	Default	Variable	User Widget
Basic	Authentication type	The way, how user would like to be authenticated to the SendGrid acoount	Basic Api Key	Basic	auth-type	radio-group
	API Key	The SendGrid API Key taken from the SendGrid account of choice	Shows if "Authentication type" is set to "	api"		sendgrid-api-key	textboxsecurekey-text
	Username	Login name for SendGrid	Shows if "Authentication type" is set to "basic"		username	textbox
	Password	Password for the	SendGrid account	Shows if "Authentication type" is set to "basic"		password	password
	Data Source Types	List of data source groups	Marketing Campaigns Fields Stats Fields Suppressions Fields		data-source-typesdataSourceTypes	multi-select
	Data SourceMarketing Campaign Objects	One of the above sources picked from list	Marketing Campaigns Fields Automation Single Sends Senders Contacts Segments		dataSourceMarketing	multi-select
	Statistic Objects	One of the above sources picked from list	Stats Global Stats Category Stats Advanced Stats		dataSourceStats	multi-select
	Suppression Objects	One of the above sources picked from list	Suppressions Bounces Global Unsubscribes Group Unsubscribes		data-sourcedataSourceSuppressions	multi-select
	Data Source Fields	List of fields to be retrieved	see "Data sources description" section below		data-source-fieldsdataSourceFields	multi-select

Options	Start Date	(required by some SG API Endpoints) The date in format YYYY-MM-DD, starting from which the data is requested.	Displayed depends on list of the selected data sources	not set	start-date	textbox
	End Date	(required by some SG API Endpoints) The date in format YYYY-MM-DD, the end date for the requested data	Displayed depends on list of the selected data sources	not set	end-date	textbox
Error Handling	On Record Error	How to handle error in record processing	Skip error Send to error port Fail pipeline	Skip error	on-error	Radio Button (layout: block)

Batch sink

Section	User Configuration Label	Label Description	Options	Default	Variable	User Widget
Basic	Authentication type	The way, how user would like to be authenticated to the SendGrid account	Possible options: Basic Api Key Required field	Basic	auth-type	radio-group
	API Key	The SendGrid API Key taken from the SendGrid account	Shows if "Authentication type" is set to "api"		sendgrid-api-key	securekey-text
	Username	Login name for the SendGrid account	Shows if "Authentication type" is set to "basic"		username	textbox
	Password	Password for the SendGrid account	Shows if "Authentication type" is set to "basic"		password	password
	From	The author of the message	Required field		from	textbox
	Recipient address source	Recipients addresses source selection	The recipient address possible sources: Input Record (input) Configuration (config) Would be displayed depends on selection: recipientColumnName recipientConfigAddressList Required field		recipientAddressSource	radio-group
	Column name for recipients addresses	Name of the column with coma-separated list of recipients			recipientColumnName	textbox
	Recipient address list	List of mail recipients			recipientConfigAddressList	csv
	Email subject	Email Subject	Required field		mailSubject	textbox
	Email body column name	Name of the column for the mail content	Required field		bodyColumnName	textbox
	Reply To	Email address to which the author of the message suggests that replies be sent			replyTo	textbox
Options	Custom Mail Footer	Footer feature setting switcher	Possible states: On (true) Off (false)	Off	footerEnabled	toggle
	Footer HTML	The default footer which would be included to every email			footerHtml	textarea
	Sandbox Mode	Allows to send a test email to ensure that your request body is valid and formatted correctly	Possible states: On (true) Off (false)	Off	sandboxMode	toggle
	Click Tracking	Allows to track whether a recipient clicked a link in a email	Possible states: On (true) Off (false)	Off	clickTracking	toggle
	Open Tracking	Allows to track whether the email was opened or not, by including a single pixel image in the body of the content. When the pixel is loaded, SendGrid can log that the email was opened	Possible states: On (true) Off (false)	Off	openTracking	toggle
	Subscription Tracking	Allows to insert a subscription management link at the bottom of the text and html bodies of an email	Possible states: On (true) Off (false)	Off	subscriptionTracking	toggle

Design Tips and references

...

Data source reference

Object	API Reference	API Premissions	Notes
Automations	-	No documentation available, but the usage could be revers engineered through debugging of official UI
Single Sends	https://sendgrid.api-docs.io/v3.0/single-sends/get-all-single-sends
Senders	-	No documentation available, but the usage could be revers engineered through debugging of official UI
Contacts	https://sendgrid.api-docs.io/v3.0/contacts/get-all-contacts
Segments	https://sendgrid.api-docs.io/v3.0/segmenting-contacts/get-list-of-segments
GlobalStats	https://sendgrid.api-docs.io/v3.0/stats/retrieve-global-email-statistics
CategoryStats	https://sendgrid.api-docs.io/v3.0/categories/retrieve-email-statistics-for-categories
AdvancedStats	https://sendgrid.com/docs/API_Reference/Web_API_v3/Stats/advanced.html
Bounces	https://sendgrid.api-docs.io/v3.0/bounces-api/retrieve-all-bounces
Global Unsubscribes	-	No documentation available, but the usage could be revers engineered through debugging of official UI
Group Unsubscribes	https://sendgrid.api-docs.io/v3.0/suppressions-unsubscribe-groups/retrieve-all-suppression-groups-associated-with-the-user
Spam Reports	https://sendgrid.api-docs.io/v3.0/spam-reports-api/retrieve-all-spam-reports
Blocks	https://sendgrid.api-docs.io/v3.0/blocks-api/retrieve-all-blocks	Schedule	-

Data sources description

(TODO)

Field name	TypeDescription
Automation
id	string
name	string
status	string
type	string
message_count	number
created_at	datetimestring
updated_at	datetimestring
live_at	datetimestring
SingleSends
id	string
name	string
status	string
created_at	datetimestring
updated_at	datetimestring
is_abtest	boolean
Senders
id	string
nickname	string
address	string
address_2	string
city	string
country	string
state	string
zip	number
locked	boolean
created_at	datetimestring
updated_at	datetimestring
from_email	string
from_name	string
verified_status	string
verified_reason	string
reply_to_name	string
reply_to_email	string
Contacts
id	string
first_name	string
last_name	string
list_ids	list[string]
created_at	datetimestring
updated_at	datetimestring
email	string
Segments
id	string
name	string
parent_list_id	string
created_at	datetime
updated_at	datetime
sample_updated_at	datetime
contacts_count	number
GlobalStats
date	datetimestring
metrics_blocks	number
metrics_bounce_drops	number
metrics_bounces	number
metrics_clicks	number
metrics_deferred	number
metrics_invalid_emails	number
metrics_opens	number
metrics_processed	number
metrics_requests	number
metrics_spam_report_drops	number
metrics_spam_reports	number
metrics_unique_clicks	number
metrics_unique_opens	number
metrics_unsubscribe_drops	number
metrics_unsubscribes	number
CategoryStats
name	string
type	string
date	datetimestring
metrics_blocks	number
metrics_bounce_drops	number
metrics_bounces	number
metrics_clicks	number
metrics_deferred	number
metrics_delivered	number
metrics_invalid_emails	number
metrics_opens	number
metrics_processed	number
metrics_requests	number
metrics_spam_report_drops	number
metrics_spam_reports	number
metrics_unique_clicks	number
metrics_unique_opens	number
metrics_unsubscribe_drops	number
metrics_unsubscribes	number
AdvancedStats
name	string
type	string
date	datetimestring
metrics_clicks	number
metrics_opens	number
metrics_unique_clicks	number
metrics_unique_opens	number
Bounces
created	datetimestring
email	string
reason	string
status	string
GlobalUnsubscribes
created	string
email	string
GroupUnsubscribes
id	string
name	string
description	string
is_default	boolean
last_email_send_at	datetimestring
unsubscribes	number
SpamReports (TODO)
Blocks (TODO)
Schedule (TODO)

Authorization

Plugin supporting Basic and API Key authorization, with using API Key by default when provided.

...

SendGrid v3 API have an request rate limiting. # todo: what to do if the plugin will hit the rate limit?

Approach

TODOThe API requester have integrated way to retry over time to fetch wait for penalty time.

Approach

Create a module sendgrid plugin in sendgrid project with use of existing SendGrid library. Add SendGrid objects with their deserialization from API and transformation to structured records.

UI Impact or Changes

TODOSendGrid source and sink are separate entries with SendGrid logo in source and sink lists.

Test Case(s)

TODO

Sample Pipeline

...

Versions Compared

Old Version 21

New Version Current

Key

Introduction

Configurables

Batch source

Batch sink

Design Tips and references

Data source reference

Data sources description

Automation

SingleSends

Senders

Contacts

Segments

GlobalStats

CategoryStats

AdvancedStats

Bounces

GlobalUnsubscribes

GroupUnsubscribes

SpamReports (TODO)

Blocks (TODO)

Schedule (TODO)

Authorization

Approach

Approach

UI Impact or Changes

Test Case(s)

Sample Pipeline

Page Comparison

Versions Compared

Old Version 21

New Version Current

Key

Configurables

Batch source

Batch sink

Design Tips and references

Data source reference

Data sources description

Automation

SingleSends

Senders

Contacts

Segments

GlobalStats

CategoryStats

AdvancedStats

Bounces

GlobalUnsubscribes

GroupUnsubscribes

SpamReports (TODO)

Blocks (TODO)

Schedule (TODO)

Authorization

Approach

Approach

UI Impact or Changes

Test Case(s)

Sample Pipeline