GetResponse
GetResponse is an email marketing tool that helps managing contacts, planning marketing campaigns and analyzing results and planning new marketing strategies.
Data integration: Skyvia supports importing data to and from GetResponse, exporting GetResponse data to CSV files, replicating GetResponse data to relational databases, and synchronizing GetResponse data with other cloud apps and relational databases.
Backup: Skyvia Backup does not support GetResponse backup.
Query: Skyvia Query supports GetResponse.
Establishing Connection
To create a connection to GetResponse, you need to enter your API Key.
Getting Credentials
- Go to https://app.getresponse.com/ and sign in to your Account.
- Click Tools -> Integrations and API.
- Select the API tab and click Generate.
- Name your API Key and copy it into Clipboard
Creating Connection
Paste the API Key you generated in the GetResponse UI into the API Key field in Skyvia.
Additional Connection Parameters
Suppressing Extended Requests
For some objects, GetResponse API returns only part of the fields when querying multiple records. In order to query values of additional fields, Skyvia performs additional extended requests. Such API requests can be performed for each record of such object. However, this can decrease performance and significantly increase the number of API calls used.
To reduce the number of API calls, you can 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 GetResponse because its API does not return them without extended requests.
Connector Specifics
Skyvia has the following GetResponse connector specifics:
Contacts
Use one of the following stored procedures to add new record to the Contacts table
call CreateNewContactWithParameters(:Name, :Email, :CampaignId, :DayOfCycle, :Scoring, :IpAddress, :Tags, :CustomFieldValues)
call CreateNewContact(:Email, :CampaignId)
Email and CampaignId values are required to create a new contact record.
If you need to create a record with minimal set of parameters, it is more convenient to use the CreateNewContact procedure.
If you need to create a record with full set of parameters, you can use the CreateNewContactWithParameters procedure. For example:
call CreateNewContact('NewContact', '[email protected]', 'r3yDN', '4',8,'1.2.3.4', '[{"tagId": "wAS4"}]', '[{"customFieldId": "pr814L","value": ["option 1"]}]')
After the procedure execution is completed, a new contact may not be displayed in the Contacts table. This behavior is related to the GetResponse API specifics. It may take a few minutes to process the queue and add the contact to the list. According to GetResponce API documentation, If your contact didn’t appear on the list, there’s a possibility that it was rejected at a later stage of processing.
Campaigns can be set to double opt-in. This means that the contact has to click a link in a confirmation message before they can be added to your list. Unconfirmed contacts are not returned by the API and can only be found using Search Contacts.
AccountBadge
Use the stored procedure call OnOffAccountBadge(:status) to change the Status. The possible values for the Status field is enabled or disabled
Newsletters
If you select the data from this table, the query returns the records of type Broadcast by default. To retrieve the records of types: Draft, Splittest, Automation, use the filter by the Type field.
Autoresponders
To insert data into the Autoresponders table, you must map either the Content_Html or the Content_Plain field, additionally to other required fields.
NewsLetterStatistics and AutoresponderStatistis
When you select data from these tables, by default GetResponse API returns data for the period from 2000-01-01 to the query execution date and time value and grouping the results of the Total type (Group results by time interval). You can add filters by the From, To or Group columns.
From and To columns have the Date data type. Use them to redetermine the time interval for the selected data.
Group column has the String data type and possible values total, hour, day, month.
You can use the
=(equal to) operator when filtering by these fields.
DML Operations Support
| Operations | Objects |
|---|---|
| INSERT, UPDATE, DELETE | Addresses, Autoresponders, Categories, MetaFields, Orders, PredefinedFields, Products, Shops, Suppressions |
| INSERT, UPDATE | Campaigns |
| UPDATE, DELETE | Contacts, CustomFields |
| INSERT, DELETE | Files, Folders, NewsLetters, Taxes |
| INSERT | TransactionalEmails |
Synchronization and Incremental Replication
Synchronization is Supported for the following objects:
Addresses, Carts, Categories, MetaFields, Products, Shops, Taxes.
Incremental Replication is NOT supported for the following objects:
Accounts, AccountBilling, AccountLoginHistory, AccountBadge, AccountIndustryTags, AccountTimezones, Multimedia, StorageSpace, ContactCustomFields, CustomFields, PredefinedFields, NewsLetterStatistics, AutoresponderStatistics, Orders, TransactionalEmails, ClickTracks
Supported Actions
Execute Command in Source, Lookup, and Target Data Flow components and in Import and Export tasks in the Advanced mode.
Execute Query in Source Data Flow components and in Import and Export tasks in the Advanced mode.
Lookup in Lookup Data Flow components.
Insert in Target Data Flow components.
Update in Target Data Flow components.
Delete in Target Data Flow components.