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 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:

    1
    
    [{"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 (for old runtime):

    1
    
    "[{\"email\": \""+Email+"\"}]"
    

    Here is the corresponding expression for the new runtime:

    1
    
    '[{"email": "'+Email+'"}]'
    

    where Email 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 (for old runtime):

    1
    
    "[{\"email\": \"" + Email + "\" , \"variables\": {\"name\": \"" + [First Name] +" "+[Last Name]+ "\"}}]"
    

    Here is the corresponding expression for the new runtime:

    1
    
    '[{"email": "' + Email + '" , "variables": {"name": "' + "First Name" +' '+"Last Name"+ '"}}]'
    

    where the corresponding source column names are First Name and Last Name.

  • 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:

  • 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:

    • Only MailingLists object supports all the DML operations.
    • The following objects support INSERT and DELETE operations: Campaigns, ListEmails, Senders, SMS_Campaigns.
    • SMTPEmails and Templates objects support only INSERT operation.
    • Emails object supports only DELETE operation.

SendPulse Connections

To connect to SendPulse, you need to specify the Client ID and Client Secret. Optionally, you can also select the Suppress Extended Requests checkbox to reduce the number of API calls. Read more about this option here.

Connection Editor window

  • Client ID — your ID for SendPulse REST API.
  • Client Secret — your secret for SendPulse REST API.

How to Find Client ID and Client Secret

To get your ID and Secret for SendPulse REST API, perform the following steps:

  1. Sign in to SendPulse.
  2. Click your Account icon in the top right column.

    SendPulse Account settings

  3. In the opened menu, click Account Settings.
  4. Click API.
  5. Activate 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 Account settings 2

Suppressing Extended Requests

For some objects, SendPulse API returns only part of the fields when querying multiple records. In order to query values of additional fields, Skyvia performs additional extended requests. Such API requests can be performed for each record of such object. However, this can decrease performance and significantly increase the number of API calls used.

To reduce the number of API calls, you can select the Suppress Extended Requests checkbox. However, please note that some of the fields in such objects will not be available in Skyvia (will return empty values) even if they have values in SendPulse because SendPulse API does not return them without extended requests.

Supported Actions and Actions Specifics

SendPulse connector supports the following actions: