AWeber
AWeber is a cloud sales email automation software for small teams with templates for any occasion, drag-n-drop email designer, dynamic content, and more.
Data integration: Skyvia supports importing data to and from AWeber, exporting AWeber data to CSV files, and replicating AWeber data to relational databases.
Backup: Skyvia Backup does not support AWeber backup.
Query: Skyvia Query supports AWeber.
Establishing Connection
When creating a connection to AWeber, you have to log in with AWeber. Skyvia stores only the OAuth authentication token. Your AWeber credentials are not stored on the Skyvia side.
Creating Connection
To create AWeber connection, perform the following steps:
- In Skyvia Connection Editor, click Sign In with AWeber.
-
In the opened window, enter your AWeber credentials, select the I’m not a robot checkbox, and click Allow access.
- Save the connection.
Connector Specifics
Object Peculiarities
Subscribers
When you add a new record to the Subscribers table, map the Tags field to create Tags. When you add new tags to the existing record or remove the tags inside the record, map the TagsAdd or TagsRemove fields. These fields are used only for the UPDATE operation and return no data when queried.
When updating the Statuses field, the valid values for mapping are subscribed or unsubscribed.
Broadcasts
The Broadcasts data is split into three objects: DraftBroadcasts, SentBroadcasts, and ScheduledBroadcasts. When performing the INSERT operation into the DraftBroadcasts table, you must map BodyHtml or BodyText fields in addition to the required AccountId, ListId, and Subject fields.
Incremental Replication and Synchronization
AWeber is not supported in the synchronization packages.
Skyvia supports Replication with Incremental Updates only for the LandingPages object.
DML Operations Support
Operation | Object |
---|---|
INSERT, UPDATE, DELETE | DraftBroadcasts |
UPDATE, DELETE | Subscribers |
Stored Procedures
call AddSubscribers(:accountId, :listId, :email, :ad_tracking, :ip_address, :last_followup_message_number_sent, :misc_notes, :name, :tags, :update_existing)
creates new subscribers.
For example, call AddSubscribers(1934349,6302150, '[email protected]', 'website', '', 1001, 'misc notes', 'Subscriber_MO_2007', '["tag1","tag2","tag3"]', false)
.
call ScheduleBroadcast(:accountId,:listId,:broadcastId,:scheduled_for)
assigns a schedule to a DraftBroadcasts record and moves it to the ScheduledBroadcasts object. You must pass the date and time to which the broadcast will be scheduled in the scheduled_for parameter.
call CancelScheduleBroadcast(:accountId,:listId,:broadcastId)
unschedules a ScheduledBroadcasts record.
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.
Supported Actions
Skyvia supports all the common actions for Aweber.