Recurly

Last updated on Jun 15, 2023

Prerequisites

An active Recurly account with Admin permissions. Read Roles and Permissions for information on granting admin privileges to a user.
You are assigned the Team Administrator, Team Collaborator, or Pipeline Administrator role in Hevo to create the Pipeline.
The Recurly private API Key is available, to allow Hevo to connect to your Recurly account.

Creating the Recurly API Key

Perform the following steps to create an API key:

Log in to your Recurly account.
In the Home page, in the left navigation pane, click Integrations, and then click API Credentials.
In the API Credentials page, click Add Private API Key.
In the Add Private API Key page, in the API Key Information section, specify the following:
- KEY NAME: A unique name for your API key.
- Read-Only: Select the check box to grant read-only permission to your Recurly data.
Click Save Changes.
You have successfully created your API key. You can view the API key that you created in the API Credentials page. Use this API key for creating Hevo Pipelines.

Configuring Recurly as a Source

Perform the following steps to configure Recurly as the Source in your Pipeline:

Click PIPELINES in the Asset Palette.
Click + CREATE in the Pipelines List View.
In the Select Source Type page, select Recurly.
In the Configure your Recurly Source page, specify the following:
- Pipeline Name: A unique name for the Pipeline, not exceeding 255 characters.
- API Key: The private key that you created in your Recurly account, to enable Hevo to read data.
- EU Environment (only visible to users in the Europe region of Hevo): Enable this if your Recurly account is in the European Union (EU) region. Read Data Hosting in Recurly to know about all the regions that Recurly supports.
- Historical Sync Duration: The duration for which the existing data in the Source must be ingested. Default duration: 3 Months.
Click TEST & CONTINUE.
Proceed to configuring the data ingestion and setting up the Destination.

Data Replication

Default Pipeline Frequency	Minimum Pipeline Frequency	Maximum Pipeline Frequency	Custom Frequency Range (Hrs)
3 Hrs	15 Mins	24 Hrs	1-24

Note: The custom frequency must be set in hours, as an integer value. For example, 1, 2, 3 but not 1.5 or 1.75.

Historical Data: In the first run of the Pipeline, Hevo ingests the historical data for all the objects using the Recent Data First approach. The data is ingested on the basis of the historical sync duration selected at the time of creating the Pipeline and loaded to the Destination. Default duration: 3 Months.
Incremental Data: Once the historical load is complete, all new and updated records are synchronized with your Destination as per the ingestion frequency.

Schema and Primary Keys

Hevo uses the following schema to upload the records to the Destination database:

Data Model

The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:

Object	Description
Account	Contains the details of all your customers.
Account Acquisition	Contains the details of an account’s acquisition data, such as the marketing channel and campaign through which the account was acquired.
Add on	Contains the details of all the add-ons associated with a subscription plan. An add-on is a charge billed through each billing period in addition to a subscription’s base charge.
Coupon	Contains the details of the coupons available for the customers on your site.
Credit Payment	Contains the details of the credit payments made to the customers.
Invoice	Contains the details of the invoices of all the billing events in your Recurly account.
Item	Contains the details about the items available for purchase by the customers. Item is the term used to refer to all your physical, digital, or service-oriented offerings collectively in Recurly.
Line Item	Contains the details about line items. Line items are the charges and credits on your customer’s invoices.
Measured Unit	Contains the details about the measured units of a site. Measured units provide a display name for the quantity of a usage-based add-on. For example, Gigabytes (GB) for an add-on offering additional data.
Plan	Contains the details about all the plans available for your customers.
Shipping Method	Contains the details of the methods used to ship products to customers.
Subscription	Contains the details of subscriptions of a customer. Subscriptions are created when your customers subscribe to one of the plans.
Transaction	Contains the details about the transactions made by the customers. Transactions refer to the process of sending the purchasing information to your payment gateway. The purchasing information includes the customer’s billing information and the amount of money to be charged, voided, or refunded.

Revision History

Refer to the following table for the list of key updates made to this page:

Date	Release	Description of Change
Sep-05-2022	NA	Updated section, Data Replication to reorganize the content for better understanding and coherence.
Jun-09-2022	1.90	New document.