GetResponse

The Lyftron Provider for GetResponse offers the most natural way to access GetResponse data from Lyftron with ease and also enables to connect with BI, MDM & ML tools, Data warehouses, Databases and other SAAS based applications with zero code and zero infrastructure requirements. The provider wraps the complexity of accessing GetResponse data into easy-to-integrate relational fully managed ANSI Sql format. Make faster and better business decisions with Lyftron’s GetResponse data provider and automatically build your data migration pipelines in minutes, not months

The provider hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

Key Features

• Comprehensive Delta load mechanism.
• Real-time access to GetResponse.
• Comprehensive full support of ANSI Sql to query data with ease.
• Collaborative query processing.

Prerequisites

The user must have credentials for GetResponse, Lyftron and your destination data warehouse, lake or database to perform the data pipeline operation with Lyftron

Establishing a Connection with Lyftron's Quickstart Steps

Create your GetResponse connection with Lyftron by following the 5 easy steps show below:

Step1. Add your connection

Click on Connect section on the left panel →  Click on Add Connection button

Step2. Select your connector

In the connector selection panel, search and click GetResponse for your connection 

Step3. Enter your connection details

In the Connection String section enter the values of the below parameters. The following connection string is required to establish GetResponse connection with Lyftron.

Profile=C:\profiles\GetResponse.apip;ProfileSettings='APIKey=[your_apikey];'

Key	Value	Field
Connection Name	Enter your connection details	Required
Profile	C:\profiles\GetResponse.apip	Required
APIKey	your GetResponse < X-Auth-Token >	Required
Logfile**	Use the logfile option to debug your job and provide your connection name to generate the log file.  [ConnectionConfigurationPath]\Connection_name_log.tx	Optional
Verbosity**	Choose verbosity 1-5 based on the severity of debugging	Optional

** For more information, check the Lyftron logging and debugging section.

If you want more detailed information about how to establish a connection with Lyftron, click on Lyftron Connection Quick Start guide.

Step4. Test your connection

Once you are done entering your connection details, simply click on the Test Connection button to test the connectivity. In case your connection fails, add Logfile and Verbosity parameters and check the Lyftron logging and debugging section, to debug the error.

Step5. Save your connection

Hurray! Now you have successfully connected with the Lyftron GetResponse connector and can utilize the connector to Extract, Warehouse, Analyze, Visualize and Share your data.

Data Model

The provider models the data in APIs into a list of tables that can be queried using standard SQL statements.

Generally, querying APIs tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. 

Name	Type	Description
AccountBilling	Tables	Retruns the billing information.
AccountBlacklist	Tables	This table will fetch global blacklist
AccountLoginHistory	Tables	Returns history of login's for this account
Accounts	Tables	Returns the collection of Accounts.
AccountsBadge	Tables	Returns current status of your GetResponse badge.
AccountsCallbacks	Tables	Returns current callback configuration or 404 response if the callbacks are not enabled.
AccountsIndustries	Tables	This method returns an useful list of industryTags that can be used in other calls.
AccountTimezones	Tables	Returns an list of all different timezones.
Addresses	Tables	Returns collection of ADDRESSES resources.
Autoresponders	Tables	Generates the single and collection of Autoresponders.
AutorespondersStatistics	Tables	Generates the statistics of particular autoresponderId.
AutoresponderStatistics	Tables	Generates the statistics of particular autoresponderId.
CampaignBlacklist	Tables	Returns campaign blacklist masks.
CampaignContacts	Tables	Allows to retrieve all contacts from given campaigns.
Campaigns	Tables	Returns collection of Campaigns resources.
CampaignsStatisticBalance	Tables	Returns the balance and source of subscriptions, stringd from specified campaigns, for each day in which any changes were made.
CampaignsStatisticListsize	Tables	Returns the number of all, added, and removed subscribers, grouped by default or by time period.
CampaignsStatisticLocations	Tables	Returns subscriber locations.
CampaignsStatisticOrigin	Tables	Returns the number and origins of subscriptions, stringd from specified campaigns, for each day in which any changes were made.
CampaignsStatisticRemovals	Tables	Returns the number of and reasons for removals.
CampaignsStatisticSubscriptions	Tables	Returns the number and origins of subscriptions, grouped by specified campaigns, for each day in which any changes were made.
CampaignsStatisticSummary	Tables	Returns current basic statistics for campaigns.
Carts	Tables	Returns collection of CART resources that belong to given shop.
Categories	Tables	Returns collection of CATEGORIES resources that belong to given shop.
ContactActivites	Tables	By default, only activities from the last 14 days are returned.
Contacts	Tables	Generates Single or Collection of Contacts
CustomFields	Tables	Generates list of all Custom fields that are defined for this account.
Forms	Tables	Generates Single or Collection of Forms.
FormsFields	Tables	This method returns list of all from fields that are defined for this account.
FormVariants	Tables	Generates the variants of from for particulater FormId
GoalProfiles	Tables	Generates Single or collection of GoalProfiles.
GoalprofilesIdGoals	Tables	Generates the Collections of Goals of particular GoalId.
GoalsprofilesIdGoalsId	Tables	Generates Single Goal Profiles of Single GoalID.
Imports	Tables	Generates the Single or Collection of Import Details.
LandingPages	Tables	Generates the Singleor Collection of Landing Pages.
MetaFields	Tables	Returns collection of META FIELD resources that belong to given shop.
Multimedia	Tables	Generates the Collecction of Multimedia.
NewsletterIdStatistics	Tables	Allows to easily fetch statistics for a single newsletter.
Newsletters	Tables	Allows to fetch the collection of Newsletters
NewsLetterStatistics	Tables	Generated schema file.
Orders	Tables	Returns collection of ORDERS resources that belong to given shop.
Pipelines	Tables	Generates the Single or Collections of Pipelines.
PipelinesIdStages	Tables	Generates the stages of single pipeline.
Products	Tables	Returns collection of PRODUCTS resources that belong to given shop.
ProductVariants	Tables	Returns collection of PRODUCT VARIANTS resources that belong to given shop and product.
RssNewsLetters	Tables	Generates single or collection of Rss-Newsletters
RssNewsLetterStatistics	Tables	Generated schema file.
SearchContact	Tables	Searches for single contact using contactId.
SearchContacts	Tables	Searches the conatcts with name.
SearchContactsIdContacts	Tables	Searches contacts with searchcontactid.
Shops	Tables	Returns collection of SHOPS resources.
SubscriptionConfirmationBody	Tables	Returns collection of SUBSCRIPTION CONFIRMATIONS bodies..
SubscriptionConfirmationSubject	Tables	returns collection of SUBSCRIPTION CONFIRMATIONS subjects.
Suppressions	Tables	Generates the Single or Collection of Suppressions.
Tags	Tables	Generated single or collection of tags.
Taxes	Tables	Generated schema file.
WebForms	Tables	Lists the single or collection of webforms.
Webinars	Tables	Returns single and collection of WEBINARS resources.
WorkFlow	Tables	Generated schema file.