Iterable
Send data from Iterable to your destinations through Freshpaint
- An Iterable account
With the Iterable source, Freshpaint can sync customer data from your Iterable account into Freshpaint's SQL Engine. All of this data will be made available as SQL tables.
With that data, you can:
- Send to your destinations on a schedule with our Scheduled Events, keeping them in sync with Iterable
- Combine your Iterable data with that of any other source
You'll need to create an API key in order to bring your Iterable data into Freshpaint. To do that, head to the Insights menu and click API keys:

Click API keys to enter the screen where you can create a new key
Once you have an API key, you'll need to go to the Iterable source in Freshpaint. To configure it, you'll enter your API key, and the time from which point we'll pull your data:

Enter your API key and Start Time
Then, configure your tables and trigger your first sync.
Below are some common objects you can sync with Freshpaint:
- Campaigns
- Catalogs
- Channels
- Commerce
- Email
- Lists
- Users
This SQL query can be used as a
Scheduled Identify
query to push your customers to your destinations.SELECT
*,
userid AS insert_id,
email AS user_id,
signupdate AS time
FROM
iterable_users
Last modified 6mo ago