SendGrid Core 

SendGrid (now part of Twilio) is a cloud-based email delivery and marketing platform.

SendGrid Core integration replicates data using the SendGrid v3 API.

Preparing for authentication

To access your data, you need to authenticate the connection with a SendGrid API key.

To set up your SendGrid account, you need:

• An active SendGrid account with API access enabled.
• Permission to create API keys in your SendGrid account (Administrator role, or a Restricted Access role with the required permissions already assigned).

To create an API key:

1. Log into your SendGrid account.
2. Navigate to Settings > API Keys > Create API Key.
3. Enter a name for the key, for example QlikDataIntegration.
4. Select Restricted Access to limit the key to only the required permissions.
5. Expand the permission categories and grant Read Access to the following:
   • Suppressions — required to replicate blocks, bounces, invalids, spam_reports, global_suppressions, groups_all, and groups_members.
   • Marketing Campaigns — required to replicate contacts, lists_all, lists_members, segments_all, segments_members, and campaigns.
   • Template Engine — required to replicate templates_all.
6. Click Create & View.
7. Copy and paste your API key into a secured file.

Creating the connection

For more information, see Connecting to SaaS applications.

1. Fill in the required connection properties.

2. Provide a name for the connection in Connection name.

3. Select Open connection metadata to define metadata for the connection when it has been created.

4. Click Create.

Limitations and considerations

• An API key cannot be granted greater permissions than your own account's current permissions. If you have a Restricted Access role in SendGrid, you can only include permissions already assigned to your account.
• Custom contact fields defined in your SendGrid account appear as records inside the custom_fields array on each contact, not as separate top-level columns. Adding new custom contact fields does not require a destination schema reset.
• The groups_members, lists_members, and segments_members streams use member_count as the replication key. Each sync fetches member data only for groups, lists, or segments whose member count has increased since the last run. Membership changes that leave the count unchanged (for example, one member removed and another added) are not detected.
• The groups_members stream replicates suppressed (unsubscribed) email addresses for each unsubscribe group.
• This connector uses the Legacy Marketing Campaigns API endpoints (/v3/contactdb/). Accounts that have only ever used the newer Twilio SendGrid Marketing Campaigns (Single Sends) may find these endpoints unavailable or empty.

Schema

Depending on your destination, table and column names may not appear as they are outlined below.