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

자세한 내용은 SaaS 응용 프로그램에 연결을 참조하십시오.

1. 필요한 연결 속성을 입력합니다.

2. 연결 이름에 연결 이름을 입력합니다.

3. 연결이 만들어질 때 연결에 대한 메타데이터를 정의하려면 연결 메타데이터 열기를 선택합니다.

4. 만들기를 클릭합니다.

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.