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.

Consulte la sección Esquema para ver una lista de objetos disponibles para replicación.

Una visión detallada de este conector, incluye enlaces útiles y funcionalidad compatible.

Función/Capacidad	Detalles de compatibilidad
Compatibilidad con proyectos de Qlik Talend Data Integration	Solo proyectos de replicación. No se admiten proyectos de canalización de datos.
Métodos de actualización de destinos	Tareas de replicación: Aplicar los cambios Guardar cambios Tareas de aterrizaje de datos en un lago de datos: Captura de datos de cambios (CDC)
Administrar los metadatos	No es necesario generar metadatos manualmente.
Evolución del esquema	Solo se admite la operación Cambiar tipo de datos de columna.
Replicación de columnas LOB (NCLOB, CLOB y BLOB)	No admitido.
CDC programado	Obligatorio. Así es como el destino se mantiene actualizado con los cambios en la fuente. Para tareas de replicación, vea Programar tareas Para tareas de aterrizaje en un lago de datos, vea Programación de CDC para tareas de destino/aterrizaje en un lago de datos
Notificaciones	Parcialmente compatible Configuración de notificaciones sobre cambios
Supervisión	Solo CDC, ya que la carga completa no es relevante para este conector. Supervisar una tarea individual de datos
Descarte automático de cargas útiles de columnas JSON	No admitido. Las cargas útiles de columnas JSON en los conjuntos de datos de origen no se deniegan automáticamente en el destino.

Preparing for authentication

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

Asegúrese de que la cuenta que utiliza tenga acceso de lectura a las tablas que desea recuperar.

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:

Log into your SendGrid account.
Navigate to Settings > API Keys > Create API Key.
Enter a name for the key, for example QlikDataIntegration.
Select Restricted Access to limit the key to only the required permissions.
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.
Click Create & View.
Copy and paste your API key into a secured file.

Creating the connection

Para más información, vea Conectar con aplicaciones SaaS.

Rellene las propiedades de conexión necesarias.
Proporcione un nombre para la conexión en Nombre de la conexión.
Seleccione Abrir metadatos de conexión para definir metadatos para la conexión cuando se haya creado.
Haga clic en Crear.

Connection settings
Setting	Description
Data gateway	Seleccione una Data Movement gateway si su caso de uso así lo requiere. Nota informativa Este campo no está disponible con la suscripción Qlik Talend Cloud Starter porque Data Movement gateway no se admite. Si tiene otro nivel de suscripción y no desea utilizar Data Movement gateway, seleccione Ninguna. Para obtener información sobre las ventajas de Data Movement gateway y los casos de uso que lo requieren, consulte Pasarela de movimiento de datos de Qlik.
Start Date	Indique la fecha, en el formato `MM/DD/YYYY`, a partir de la cual deben replicarse los datos de su fuente a su destino.
API Key	API 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

¿Esta página le ha sido útil?

Si encuentra algún problema con esta página o su contenido (errores tipográficos, pasos que faltan o errores técnicos), no dude en ponerse en contacto con nosotros.

Deje aquí sus comentarios