CleverReach
CleverReach is an email marketing tool that makes sending newsletters fast and easy.
Data integration: Skyvia supports importing data to and from CleverReach, exporting CleverReach data to CSV files, replicating CleverReach data to relational databases.
Backup: Skyvia Backup does not support CleverReach.
Query: Skyvia Query supports CleverReach.
Establishing Connection
To create a connection, log in with CleverReach account. Skyvia stores only the OAuth authentication token. Skyvia does not store your credentials.
Creating Connection
-
In the Connection Editor click Sign In with CleverReach.
-
Click Log in with my existing CleverReach account and connect if you already have an account.
-
Enter your CleverReach credentials and click Log in now and connect Skyvia!
-
Use the Test Connection button to make sure that the connection is successful and then click Create Connection.
Additional Connection Parameters
Suppressing Extended Requests
CleverReach API returns only part of the fields for some objects when querying multiple records. To query the values of additional fields, Skyvia performs additional extended requests for each record of such an object. However, this can decrease performance and significantly increase the number of API calls.
To reduce the number of API calls, 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 CleverReach because its API does not return them without extended requests.
Connector Specifics
Object Peculiarities
-
The ReceiverOrders object displays the Orders related to the specific receiver regardless of the list this receiver belongs to.
If one receiver belongs to two lists, there will be two records with the different GroupId values and equal values of all other fields in the ReceiverOrders table.
-
The GroupReceiverOrders object displays the orders related to the specific receiver and specific list, which this receiver belongs to.
Stored Procedures
A part of the CleverReach functionality is supported in Skyvia as stored procedures:
call ActivateReceiver(:group_id,:Id)
— updates the value in the Activated field. The value in the Deactivated field will be nulled if it was not null.
call DeactivateReceiver(:group_id,:Id)
— updates the value in the Deactivated field.
call RemoveReceiverTags(:Id,:Tags)
— deletes specific tags in the Tags field.
For example, if the specific record contains the array of tags [“Tag1”,”Tag2”,”Tag3”] and you need to delete Tag2 and Tag3, then the Tags value should look like ‘Tag2, Tag3’ when you call the procedure.
You can use a call to the stored procedure, for example as a text of the command in the ExecuteCommand action in a Target component of a Data Flow or in Query.
DML Operations Support
Skyvia supports DML operations for such CleverReach objects:
Operation | Object |
---|---|
INSERT, UPDATE, DELETE | Blacklists, GlobalAttributes, Groups, GroupAttributes, GroupReceivers, GroupReceiverOrders, ReceiverOrders |
UPDATE | GroupReceiverAttributes |
Incremental Replication and Synchronization
Skyvia supports Replication with Incremental Updates only for the Blacklists table. This table has the CreatedDate field only, there is no UpdatedDate field, it means that only newly created records could be replicated incrementally. Updated and deleted records do not take part in Incremental Replication.
Skyvia does not support Synchronization for CleverReach.
Supported Actions
Skyvia supports all the common actions for CleverReach.