SendGrid Core | Qlik Cloud Yardımı
Ana içeriğe geç Tamamlayıcı içeriğe geç

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.

Çoğaltma için kullanılabilir nesnelerin listesi için Şema bölümüne bakın.

Preparing for authentication

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

Bilgi notuKullandığınız hesabın, almak istediğiniz tablolar için okuma erişimine sahip olduğundan emin olun.

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

Daha fazla bilgi için bk. SaaS uygulamalarına bağlanma.

  1. Zorunlu bağlantı özelliklerini doldurun.
  2. Bağlantı adı kısmında bağlantı için bir ad sağlayın.

  3. Oluşturulduğu zaman bağlantı için meta verileri tanımlamak üzere Bağlantı meta verilerini aç'ı seçin.

  4. Oluştur'a tıklayın.

Connection settings
SettingDescription
Data gateway

Kullanım durumunuz gerektiriyorsa bir Veri Hareketi ağ geçidi seçin.

Bilgi notu

Qlik Talend Cloud Başlangıç Kılavuzu aboneliği Veri Hareketi ağ geçidi desteklenmediğinden bu alan, söz konusu abonelikle kullanılamaz. Başka bir abonelik kademeniz varsa ve Veri Hareketi ağ geçidi kullanmak istemiyorsanız Hiçbiri'ni seçin.

Veri Hareketi ağ geçidi avantajları ve bunu gerektiren kullanım durumları hakkında bilgi için bkz. Qlik Data Gateway - Veri Hareketi.

Start Date

Verilerin kaynağınızdan hedefinize çoğaltılması gereken tarihi MM/DD/YYYY biçiminde girin.

API KeyAPI key.

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

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

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

blocks

The blocks table contains information about email addresses that were blocked from receiving emails.

Replication Method

CDC

Primary Key

email

Replication Key

end_time

Useful links

SendGrid API reference

bounces

The bounces table contains information about email addresses that have bounced.

Replication Method

CDC

Primary Key

email

Replication Key

end_time

Useful links

SendGrid API reference

campaigns

The campaigns table contains information about email campaigns in your SendGrid account.

Replication Method

Full Table

Primary Key

id

Useful links

SendGrid API reference

contacts

The contacts table contains information about recipients in your SendGrid contact database.

Replication Method

CDC

Primary Key

id

Replication Key

created_at, updated_at

Useful links

SendGrid API reference

global_suppressions

The global_suppressions table contains email addresses that have globally unsubscribed from all emails.

Replication Method

CDC

Primary Key

email

Replication Key

end_time

Useful links

SendGrid API reference

groups_all

The groups_all table contains information about unsubscribe groups in your SendGrid account.

Replication Method

Full Table

Primary Key

id

Useful links

SendGrid API reference

groups_members

The groups_members table contains suppressed (unsubscribed) email addresses for each unsubscribe group.

Replication Method

CDC

Primary Key

email

Replication Key

member_count

Useful links

SendGrid API reference

invalids

The invalids table contains invalid email addresses that cannot receive mail.

Replication Method

CDC

Primary Key

email

Replication Key

end_time

Useful links

SendGrid API reference

lists_all

The lists_all table contains information about contact lists in your SendGrid account.

Replication Method

Full Table

Primary Key

id

Useful links

SendGrid API reference

lists_members

The lists_members table contains contact recipients that belong to a contact list.

Replication Method

CDC

Primary Key

id

Replication Key

member_count

Useful links

SendGrid API reference

segments_all

The segments_all table contains information about contact segments in your SendGrid account.

Replication Method

Full Table

Primary Key

id

Useful links

SendGrid API reference

segments_members

The segments_members table contains contact recipients that belong to a contact segment.

Replication Method

CDC

Primary Key

id

Replication Key

member_count

Useful links

SendGrid API reference

spam_reports

The spam_reports table contains email addresses that have marked your emails as spam.

Replication Method

CDC

Primary Key

email

Replication Key

end_time

Useful links

SendGrid API reference

templates_all

The templates_all table contains information about email templates in your SendGrid account.

Replication Method

Full Table

Primary Key

id

Useful links

SendGrid API reference

Bu sayfa size yardımcı oldu mu?

Bu sayfa veya içeriği ile ilgili bir sorun; bir yazım hatası, eksik bir adım veya teknik bir hata bulursanız lütfen bize bildirin!