Import Subscriptions via Azure Data Factory

The following guide will show you how to import email subscriptions via the CleverPush Sync Subscription endpoint using Azure Data Factory (ADF). If a given subscription already exists at CleverPush, it will just be updated with the given data. You can also modify the columns/fields which are sent to the CleverPush API, check out our API docs for more information.

1. Create new Dataset for the Source, e.g. CSV (if not already there)
2. Create new Dataset for the Target with type REST
   
3. Configure the REST Service
   
4. Set the following Relative URL in the REST Dataset (replace CHANNEL_ID with your CleverPush Channel ID)
   
5. Create a new Data flow and add your existing Dataset as the Source
   
   
6. Add a new Derived column step in the Data flow
   
7. Add the columns as required for your CleverPush API Sync Subscription call
   1. emailConfirmed can be set to true using the expression toBoolean("true")
   2. customAttributes can be set with a similar expression like (depending on your column names):
      @(user_id=ssoID, firstname=VORNAME, lastname=NAME, gender=ANREDE)
8. Add a Sink to your Data flow and select the previously created REST Dataset
   
   
9. Under Mapping in the Sink settings configure your columns so they look like this:
   
10. Create a new Pipeline with a Data flow action, there select your previously created Data flow