SendGrid Connector Objects (NMC 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.
AutomationStats	Get All Automation Stats
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.
Designs	List Designs
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.
MailSettings	Query all the mail settings in SendGrid.
MessageEvents	List of events related to email message in SendGrid.
Messages	Query Email Activities in SendGrid.
NMCContacts	Query New Marketing Campaign Contacts in SendGrid.
NMCCustomFields	Create, delete, and query New Marketing Campaign Custom Fields in SendGrid.
NMCLists	Create, update, delete, and query the available New Marketing Campaign Lists in SendGrid.
NMCReservedFields	Query the available New Marketing Campaign Reserved Fields in SendGrid.
NMCSegments	Create, update, delete, and query New Marketing Campaign Segments in SendGrid.
NMCSenders	Create, update, delete, and query New Marketing Campaign Senders in SendGrid.
NMCSingleSends	Create, update, delete, and query the available New Marketing Campaign Single Sends in SendGrid.
PartnerSettings	Query all the partner settings in SendGrid.
SingleSendClickTrackingStats	Get Single Send Click Tracking Stats by ID
SingleSendsStats	Get All Single Sends Stats
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.
Templates	Retrieve paged transactional templates
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
Id	String	False	No	This is the ID of the Automation you are requesting stats for.
Aggregation	String	False	No	This describes the time unit to which the stat is rolled up. It is based on the aggregated_by parameter included in the request. It can be 'total' or the date (in YYYY-MM-DD format) the stats are for.
StepId	String	False	No	This is the ID of the step if the stats were requested to be grouped by step_id.
BounceDrops	Integer	False	No	BounceDrops
Bounces	Integer	False	No	Bounces
Clicks	Integer	False	No	Clicks
Delivered	Integer	False	No	Delivered
InvalidEmails	Integer	False	No	InvalidEmails
Opens	Integer	False	No	Opens
Requests	Integer	False	No	Requests
SpamReportDrops	Integer	False	No	SpamReportDrops
SpamReports	Integer	False	No	SpamReports
UniqueClicks	Integer	False	No	UniqueClicks
UniqueOpens	Integer	False	No	UniqueOpens
Unsubscribes	Integer	False	No	Unsubscribes

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
Id [KEY]	String	True	No	This column is dynamic and maps to the corresponding field in the API.
AddressLine1	String	True	No	This column is dynamic and maps to the corresponding field in the API.
AddressLine2	String	True	No	This column is dynamic and maps to the corresponding field in the API.
City	String	True	No	This column is dynamic and maps to the corresponding field in the API.
Country	String	True	No	This column is dynamic and maps to the corresponding field in the API.
PostalCode	String	True	No	This column is dynamic and maps to the corresponding field in the API.
StateProvinceRegion	String	True	No	This column is dynamic and maps to the corresponding field in the API.
Line	String	True	No	This column is dynamic and maps to the corresponding field in the API.
Facebook	String	True	No	This column is dynamic and maps to the corresponding field in the API.
PhoneNumber	String	True	No	This column is dynamic and maps to the corresponding field in the API.
UniqueName	String	True	No	This column is dynamic and maps to the corresponding field in the API.
WhatsApp	String	True	No	This column is dynamic and maps to the corresponding field in the API.
Email	String	True	No	This column is dynamic and maps to the corresponding field in the API.
FirstName	String	True	No	This column is dynamic and maps to the corresponding field in the API.
LastName	String	True	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.
UpdatedAt	Datetime	True	No	This column is dynamic and maps to the corresponding field in the API.
ItemUrl	String	True	No	This column is dynamic and maps to the corresponding field in the API.
SegmentId	String	False	Yes	This column is dynamic and maps to the corresponding field in the API.
ListId	String	False	Yes	This column is dynamic and maps to the corresponding field in the API.

Name	Type	ReadOnly	FilterOnly	Description
Id	String	False	No	The Id of the reserved field.
Name	String	False	No	The name of the reserved field.
Type	String	False	No	The type of the reserved field.

Name	Type	ReadOnly	References	FilterOnly	Description
SingleSendId	String	False	NMCSingleSends.Id	No	The ID of Single Send for which you want to retrieve Click Tracking stats.
Url	String	False		No	This is the URL of the link clicked. If {{custom_fields}} are part of the URL, they will be included.
UrlLocation	Integer	False		No	This is the location of the link clicked in each Single Send A/B variation, or in the Single Send itself if there are no variations. Links are numbered from the top down; the topmost link is index 0.
ABvariation	String	False		No	This is the A/B variation of the Single Send stat returned. It is set to 'all' if the ab_variation query parameter was not set in the request and group_by doesn't contain ab_variation.
ABphase	String	False		No	This is the A/B phase of the Single Send stat returned. If the ab_phase query parameter was not provided, it will return 'all'.
Clicks	Integer	False		No	The number of clicks on this particular link.

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.