Connecting to SendPulse

SendPulse is a cloud-based multi-channel marketing platform for sending marketing messages via email, SMS, Viber, etc..

Data integration: Skyvia supports importing data to and from SendPulse, exporting SendPulse data to CSV files, and replicating SendPulse data to relational databases.

Backup: Skyvia Backup supports SendPulse backup.

Query: Skyvia Query supports SendPulse.

 

SendPulse-Specific Features and Limitations

Skyvia has the following limitations for SendPulse:

Skyvia does not support incremental updates when replicating SendPulse data and SendPulse data synchronization with other sources.
When loading data to the ListEmails object, you should provide values for the Email field in the format of JSON array of emails. An example of a valid value for this field looks like the following:
 
[{"email": "[email protected]"}, {"email": "[email protected]"}]
 
The array may contain just one value. Each of the array values is actually inserted as a separate record. If you import data from a data source with a column that stores just email addresses without any JSON, you can map the SendPulse Email field using the expression mapping with the following expression:
 
"[{\"email\": \""+Email+"\"}]"
 
where Email highlighted with bold italic is a name of the corresponding source column with email address.
 
If you also want to add variables for imported contacts, you need to add the JSON for variables (like name) to the expression for the Email field. In this case, the expression may look like the following:
 
"[{\"email\": \"" + Email + "\" , \"variables\": {\"name\": \"" + [First Name] +" "+[Last Name]+ "\"}}]"
 
where the corresponding source column names are highlighted with bold.
When performing import to the ListEmails object with the DELETE operation, you should provide values for the Email field in the format of JSON array of emails, but in this case the JSON array format is different:
 
[ "[email protected]", "[email protected]", "[email protected]", [email protected]]
The SMS_PhoneNumberInfo object allows retrieving data only by a phoneNumber. You must specify a value for the phoneNumber field in filters in order to query records from this object. Otherwise, Skyvia returns 0 records.
Not all objects support all the DML operations for data import:
oOnly MailingLists object supports all the DML operations.
oThe following objects support INSERT and DELETE operations: Campaigns, ListEmails, Senders, SMS_Campaigns.
oSMTPEmails and Templates objects support only INSERT operation.
oEmails object supports only DELETE operation.

 

SendPulse Connections

To connect to SendPulse, you need to specify the Client Id and Client Secret.

sendpulse-connection-new

You need to specify the following parameters for a SendPulse connection:

Name - connection name that will be used to identify the connection on the Connections page and when selecting a connection for a package.
Client ID - your ID for SendPulse REST API.
Client Secret - your secret for SendPulse REST API.
 
To get your ID and Secret for SendPulse REST API, perform the following steps:
oSign in to SendPulse
oClick your Account icon in the top right column.
 
sendpulse-connection-api-1
oIn the opened menu click Account Settings.
oClick API.
oActivate your REST API if it is not activated yet. The ID and Secret values will be generated, and you will be able to copy them and paste into Skyvia connection editor
 
sendpulse-connection-api-2