SendGrid is a cloud-based platform intended for delivering transactional and marketing emails.
Data integration: Skyvia supports importing data to and from SendGrid, exporting SendGrid data to CSV files, replicating SendGrid data to relational databases, and synchronizing SendGrid data with other cloud apps and relational databases.
Backup: Skyvia Backup does not support SendGrid.
Query: Skyvia Query supports SendGrid.
To create a connection to SendGrid, you need to specify an API Key.
To get your API Key, perform the following steps:
- Sign in to SendGrid.
Click Settings in the menu on the left.
In the drop-down list, click API Keys and copy your API Key.
If you don’t have an API Key in your SendGrid account yet, you need to create it and select API Key permissions.
Paste the obtained API Key to the corresponding box in the Connection Editor.
Additional Connection Parameters
Use Custom Fields
Select this checkbox to make custom fields available in Skyvia.
Due to SendGrid API peculiarities, the INSERT and UPDATE operations work the following way. When you import a record with an existing Email value, the integration updates the corresponding target record. When you import a record with a new Email value, the integration inserts a new record to the target.
It takes several minutes for changes to display in the Contact object.
The ListIds field supports the INSERT operation and does not support the UPDATE operation. To update the ListIds field, you can use the Insert action, map the existing value to the Email field and map the ListId field.
To get data from the -EmailStatistics objects (GlobalEmailStatistics, EmailStatisticsByCountry, EmailStatisticsByDeviceType etc.), you must set the filter by StartDate with = (equals) operator only. Optionally, you can add the filter by EndDate. StartDate and EndDate fields are used for filtering only and do not display values when querying.
When you get the data from the CustomFields field of the Contacts object, the data is returned in form of a JSON array with pairs of “custom field name”:”custom field value”.
To successfully import data to custom fields, you must pass the custom field Id instead of name, in the following format: “custom field Id”:”custom field value”.
DML Operations Support
|INSERT, UPDATE, DELETE||Alerts, API Keys, AuthenticatedDomains, BrandedLinks, Campaign, CancelSheduledSends, ContactLists, Contacts, CustomFields, Designs, Lists, Segments, Senders, SingleSends, Subusers, Templates, TransactionalTemplateVersions, UnsubscribeGroups, VerifiedSenders|
|UPDATE, DELETE||CampaignSchedules, Teammates|
|INSERT, DELETE||ContactCustomFields, Contacts, ContactSegments, PendingTeammates, ReverseDNS, Suppressions, Unsubscribes|
|DELETE||Blocks, Bounces, ContactListRecipients, InvalidEmails, SpamReports|
Incremental Replication and Synchronization
Skyvia supports Replication with Incremental Updates selected for SendGrid objects, which have either the UpdatedDate or CreatedDate field. Thus, such objects as Alerts, Blocks, Bounces, Contacts, ContactListRecipients, Designs, DesignsPre-built, InvalidEmails, Senders, Segments,SingleSends, SpamReports, Suppressions, Templates, TransactionalTemplateVersions, Unsubscribes can be replicated with incremental updates.
Skyvia supports Synchronization for such SendGrid objects as Alerts, Designs, Segments, Senders, SingleSends, Templates, TransactionalTemplateVersions.
Skyvia supports all the common actions for SendGrid.