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": "test1@test.com"}, {"email": "test2@test.com"}]
    

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

    [ "test@test.com", "test2@test.com", "test3@test.com", test4@test.com]
    
  • 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.

Connection Editor window

You need to specify the following parameters for SendPulse connection:

  • Name — connection name that will be used to identify the connection in the objects list 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:

    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