SendGrid Connector Objects (Legacy Schema)

This Data 360 connector is a beta service that is subject to the Beta Services Terms at Agreements - Salesforce.com or a written Unified Pilot Agreement if executed by Customer, and applicable terms in the Product Terms Directory. Use of this pilot or beta service is at the Customer's sole discretion.

Name	Description
Alerts	Create, update, delete, and query Alerts in SendGrid.
ApiKeys	Query, Create, Update and Delete the available ApiKeys in SendGrid.
Blocks	Query and Delete the available Blocks in SendGrid.
Bounces	Query and Delete the available Bounces in SendGrid.
CancelScheduledSends	Update, delete, and query Cancel Scheduled Sends in SendGrid.
Categories	Query the available Categories in SendGrid.
CategoryStats	Query the available Category Stats in SendGrid.
CustomFields	Create, delete, and query Custom Fields in SendGrid.
DynamicTemplates	Query Teammates in SendGrid.
GlobalStats	Query the available Global Stats in SendGrid.
GlobalUnsubscribes	Query Global Unsubscribes in SendGrid.
GroupSuppressions	Query group suppressions in SendGrid.
InvalidEmails	Query and Delete invalid emails in SendGrid.
IPAccessManagement	Query Global Unsubscribes in SendGrid.
Lists	Create, update, delete, and query the available Lists in SendGrid.
MailSettings	Query all the mail settings in SendGrid.
MarketingCampaigns	Create, update, delete, and query Marketing Campaigns in SendGrid.
MessageEvents	List of events related to email message in SendGrid.
Messages	Query Email Activities in SendGrid.
PartnerSettings	Query all the partner settings in SendGrid.
Recipients	The SendGrid table Recipients.
ReservedFields	Query the available Reserved Fields in SendGrid.
Schedules	Create, update, delete, and query Campaign Schedules in SendGrid.
Segments	Create, update, delete, and query Segments in SendGrid.
SenderIdentities	Create, update, delete, and query Sender Identities in SendGrid.
Spam	Query and delete Spam reports in SendGrid.
StatsByBrowser	Query Browser Statistics in SendGrid.
StatsByClient	Query Client Statistics in SendGrid.
StatsByDevice	Query Device Statistics in SendGrid.
StatsByLocation	Query Location Statistics in SendGrid.
StatsByMailboxProvider	Query Mailbox Provider Statistics in SendGrid.
Subusers	Query all the subusers in sendgrid.
SubuserStats	Query Subuser Statistics in SendGrid.
Teammates	Query Teammates in SendGrid.
UnsubscribeGroups	Create, update, delete, and query Unsubscribe Groups in SendGrid.
Users	Query the available Users in SendGrid.

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	Integer	False	No	The ID of the alert.
CreatedAt	Datetime	True	No	Date when the alert was created.
UpdatedAt	Datetime	True	No	Date when the alert was updated.
EmailTo	String	False	No	The email address that the alert will be sent to.
Percentage	Integer	False	No	The email address that the alert will be sent to.
Type	String	False	No	The type of alert. Allowed values (usage_limit, stats_notification).
Frequency	String	False	No	If the alert is of type stats_notification, this indicates how frequently the stats notifications will be sent.(daily, weekly, monthly).
AccountId	String	False	Yes	The ID of the account.
SubuserUsername	String	False	Yes	The username of the subuser.

Name	Type	ReadOnly	FilterOnly	Description
ApiKeyId [KEY]	String	False	No	The ID of your API Key.
Name	String	False	No	The name of your API Key.
Scopes	String	False	No	The permissions this API Key has access to. This is populated only when Id is specified.
AccountId	String	False	Yes	The ID of the account.
SubuserUsername	String	False	Yes	The username of the subuser.

Name	Type	ReadOnly	FilterOnly	Description
BatchId [KEY]	String	False	No	The Id of the batch.
Status	String	False	No	The status of the scheduled send.Allowed Values: cancel, pause
AccountId	String	False	Yes	The ID of the account.
SubuserUsername	String	False	Yes	The username of the subuser.

Name	Type	ReadOnly	FilterOnly	Description
Date	Date	True	No	The time the global statistic was created.
Blocks	Integer	False	No	The number of emails that were not allowed to be delivered by ISPs.
BounceDrops	Integer	False	No	The number of emails automatically dropped by SendGrid because they appear on one of the suppression lists.
Bounces	Integer	False	No	The number of emails that bounced instead of being delivered.
Clicks	Integer	False	No	The number of links clicked in your emails.
Deferred	Integer	False	No	The number of emails temporarily refused by the receiving server.
Delivered	Integer	False	No	The number of emails confirmed delivered.
InvalidEmails	Integer	False	No	The number of emails with a malformed address or reported as invalid by the receiving server.
Opens	Integer	False	No	The number of times your emails were opened by recipients.
Processed	Integer	False	No	The number of emails pushed to SendGrid.
Requests	Integer	False	No	The number of emails you requested to send via SendGrid.
SpamReportDrops	Integer	False	No	The number of emails automatically dropped because the emails were marked as spam by the recipients.
SpamReports	Integer	False	No	The number of emails marked as spam by recipients.
UniqueClicks	Integer	False	No	The number of unique recipients who clicked links in your emails.
UniqueOpens	Integer	False	No	The number of unique recipients who opened your emails.
UnsubscribeDrops	Integer	False	No	The number of emails globally dropped by SendGrid because the recipient unsubscribed from your emails.
Unsubscribes	Integer	False	No	The number of recipients who unsubscribed from your emails.
AccountId	String	False	Yes	The ID of the account.
SubuserUsername	String	False	Yes	The username of the subuser.

Name	Type	ReadOnly	FilterOnly	Description
Email [KEY]	String	False	No	Email of the unsubscriber.
CreatedAt	Datetime	True	No	The time the unsubscriber was created.
AccountId	String	False	Yes	The ID of the account.
SubuserUsername	String	False	Yes	The username of the subuser.

Name	Type	ReadOnly	FilterOnly	Description
GroupId [KEY]	Integer	False	No	Email of the unsubscriber.
Emails	String	False	No	The time the unsubscriber was created.
AccountId	String	False	Yes	The ID of the account.
SubuserUsername	String	False	Yes	The username of the subuser.

Name	Type	ReadOnly	FilterOnly	Description
Created	Datetime	True	No	The time the when the email address was added to the invalid emails list.
Reason	String	False	No	A reason explaining why the email address was marked as invalid..
Email [KEY]	String	False	No	The email address that was marked as invalid.
AccountId	String	False	Yes	The ID of the account.
SubuserUsername	String	False	Yes	The username of the subuser.

Name	Type	ReadOnly	FilterOnly	Description
IP	String	False	No	IP Address.
Allowed	Boolean	False	No	Indicator if this IP is allowed for access.
AuthMethod	String	False	No	Authentication method.
FirstAt	Timestamp	False	No	First time when IP has accessed the account.
LastAt	Timestamp	False	No	Last time when IP has accessed the account.
Location	String	False	No	Location of the IP.
AccountId	String	False	Yes	The ID of the account.
SubuserUsername	String	False	Yes	The username of the subuser.

Name	Type	ReadOnly	FilterOnly	Description
Title	String	False	No	The title of the mail setting.
Enabled	String	False	No	Indicates if this mail setting is currently enabled.
Name	String	False	No	The name of the mail setting.
Description	String	False	No	A description of the mail setting.
AccountId	String	False	Yes	The ID of the account.
SubuserUsername	String	False	Yes	The username of the subuser.

Name	Type	ReadOnly	FilterOnly	Description
MessageId	String	True	No	The Id of the message.
EventName	String	True	No	Name of event.
Processed	Datetime	True	No	The date when the event was processed.
Reason	String	True	No	Explanation of what caused the message to be 'bounced', 'deferred', or 'blocked'.
AttemptNum	Integer	True	No	Used with 'deferred' events to indicate the attempt number out of 10.
Url	String	True	No	Used with 'clicked' event to indicate which url the user clicked.
BounceType	String	True	No	Use to distinguish between types of bounces.
HttpUserAgent	String	True	No	Client recipient used to click or open message.
MXServer	String	True	No	The MX server that received the email.
ApiKeyId	String	True	No	Id of the API Key.
AsmGroupId	String	True	No	ASM Group Id.
Categories	String	True	No	Categories users associated to the message.
UniqueArgs	String	True	No	JSON hash of key-value pairs associated with the message.
OriginatingIp	String	True	No	This is the IP address of the person sending the message
OutboundIp	String	True	No	This is the SendGrid dedicated IP address used to send the email
OutboundIpType	String	True	No	The type of the outbound IP.
Teammate	String	True	No	Username of the teammate.
TemplateId	String	True	No	Template ID of the email.

Name	Type	ReadOnly	FilterOnly	Description
MarketingCampaignId [KEY]	Integer	False	No	Id of the campaign.
Status	String	True	No	Status of the campaign.
SendAt	Datetime	False	No	Date to start the campaign.
AccountId	String	False	Yes	The ID of the account.
SubuserUsername	String	False	Yes	The username of the subuser.

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	This column is dynamic and maps to the corresponding field in the API.
SegmentId	Int32	False	No	This column is dynamic and maps to the corresponding field in the API.
ListId	Int32	False	No	This column is dynamic and maps to the corresponding field in the API.
Email	String	False	No	This column is dynamic and maps to the corresponding field in the API.
FirstName	String	False	No	This column is dynamic and maps to the corresponding field in the API.
LastName	String	False	No	This column is dynamic and maps to the corresponding field in the API.
CreatedAt	Datetime	True	No	This column is dynamic and maps to the corresponding field in the API.
LastClicked	Datetime	True	No	This column is dynamic and maps to the corresponding field in the API.
LastEmailed	Datetime	False	No	This column is dynamic and maps to the corresponding field in the API.
LastOpened	Datetime	True	No	This column is dynamic and maps to the corresponding field in the API.
UpdatedAt	Datetime	True	No	This column is dynamic and maps to the corresponding field in the API.
Age	String	False	No	This column is dynamic and maps to the corresponding field in the API.
Department	String	False	No	This column is dynamic and maps to the corresponding field in the API.
University	String	False	No	This column is dynamic and maps to the corresponding field in the API.

Name	Type	ReadOnly	FilterOnly	Description
Id	Integer	True	No	The Id of the subuser.
Email	String	True	No	The email of the subuser.
Username	String	True	No	The username of the subuser.
Disabled	Boolean	True	No	Indicates whether the subuser is enabled or disabled.

Name	Type	ReadOnly	FilterOnly	Description
Username [KEY]	String	False	No	The username of the teammate.
Email	String	False	No	Email of the teammate.
FirstName	String	False	No	First name of the teammate.
LastName	String	False	No	Last name of the teammate.
UserType	String	False	No	User type of the teammate.
IsAdmin	Boolean	False	No	Indicator if the teammate is admin.
Phone	String	False	No	Phone of the teammate.
Website	String	False	No	Website of the teammate.
Company	String	False	No	Company of the teammate.
Address	String	False	No	Address of the teammate.
Address2	String	False	No	Address 2 of the teammate.
City	String	False	No	City of the teammate.
State	String	False	No	State of the teammate.
Country	String	False	No	Country of the teammate.
Zip	String	False	No	Zip of the teammate.
Scopes	String	False	No	Scope of the permissions for the new teammate. Multiple values are allowed and should be split by a comma symbol. Possible values are: user.account.read,user.credits.read,user.email.create,user.email.read,user.email.update,user.email.delete,user.profile.create,user.profile.read,user.profile.update,user.profile.delete
AccountId	String	False	Yes	The ID of the account.
SubuserUsername	String	False	Yes	The username of the subuser.