Sendwithus
Sendwithus is a transactional email management platform that allows teams to design, manage, and send email templates.
Sendwithus integration replicates data using the Sendwithus API.
See the Schema section for a list of objects available for replication.Preparing for authentication
To access your data, you need to authenticate the connection with a Sendwithus API key.
To create an API key:
- Log into your Sendwithus account.
- Navigate to Technical > API Settings.
- Click Create New API Key.
- Enter a description for the key.
- Copy and paste your API key into a secured file.
Creating the connection
For more information, see Connecting to SaaS applications.
- Fill in the required connection properties.
Provide a name for the connection in Connection name.
Select Open connection metadata to define metadata for the connection when it has been created.
Click Create.
| Setting | Description |
|---|---|
| Data gateway | Select a Data Movement gateway if required by your use case. Information note This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None. For information on the benefits of Data Movement gateway and use cases that require it, see Qlik Data Gateway - Data Movement. |
| Start Date | Enter the date, in the format |
| API Key | API key. |
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.
drip_campaigns
The drip_campaigns table contains information about drip campaigns configured in your Sendwithus account.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
log_events
The log_events table contains events associated with a specific email log entry.
Replication Method | CDC |
Primary Key | log_id, status, created |
| Useful links |
logs
The logs table contains email send log entries for your Sendwithus account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
snippets
The snippets table contains reusable content snippets defined in your Sendwithus account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
templates
The templates table contains email templates defined in your Sendwithus account.
Replication Method | CDC |
Primary Key | id |
| Useful links |