Release Status Released Availability Premium
Status Page Recurly Status Page Default Historical Sync 1 year
Whitelist Tables/Columns Unsupported/Unsupported Default Replication Frequency 30 minutes
Full Table Endpoints 1 Incremental Endpoints 8
Destination Incompatibilities None

Connecting Recurly

Connecting your Recurly data to Stitch is a four-step process:

  1. Generate a Recurly API Key
  2. Add Recurly as a Stitch data source
  3. Define the Historical Sync
  4. Define the Replication Frequency

Generating a Recurly API Key

Note that to generate an API key, you’ll need Admin permissions in your Recurly account.

  1. Sign into your Recurly account.
  2. From the Recurly dashboard, click the Developers option in the sidebar.
  3. Click API credentials.
  4. Click the Add Private API Key button.
  5. Enter a name for the key. We recommend something that will tell you, at a glance, who or what is using the key - for example, ‘Stitch.’

  6. The last section - Will this key be used with a third-party application? - is optional.

    If you want to enter something here, you can select Other from the dropdown menu and then type Stitch into the Application Name field.

  7. When finished, click the Save Changes button to generate the key.

Leave this page open for now - you’ll need it to complete the setup in Stitch.

Add Recurly as a Stitch Data Source

  1. On the Stitch Dashboard page, click the Add an Integration button.

  2. Click the Recurly icon.

  3. Enter a name for the integration. This is the name that will display on the for the integration; it’ll also be used to create the schema in your data warehouse.

    For example, the name “Stitch Recurly” would create a schema called stitch_recurly in the data warehouse. This schema is where all the tables for this integration will be stored.

  4. Enter the subdomain for your Recurly site. For example, if our subdomain were stitch.recurly.com, we would just enter stitch into this field.
  5. Paste the Recurly API key you generated into the API Key field.

Defining the Historical Sync

The Sync Historical Data setting will define the starting date for your Recurly integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to sync data beyond Recurly’s default setting of 1 year. For a detailed look at historical syncs, check out the Syncing Historical SaaS Data article.

Define the Replication Frequency

The Replication Frequency controls how often Stitch will attempt to replicate data from your Recurly integration. By default the frequency is set to 30 minutes, but you can change it to better suit your needs.

Before setting the Replication Frequency, note that:

  • The more often Recurly is set to replicate, the higher the number of replicated rows.

  • The number of rows in the source may not equal the number of rows replicated by Stitch. Tables that use Full Table Replication will result in a higher number of replicated rows.

  • If you’re using a data warehouses that doesn’t natively support nested structures, you’ll see a higher number of replicated rows due to the de-nesting Stitch performs.

To help prevent overages, we recommend setting the Replication Frequency to something less frequent - like 6 hours instead of 30 minutes. For tips on reducing your row count, check out the Reducing Your Row Count section of our Billing Guide.

After selecting a Replication Frequency, click Save Integration.

Recurly’s Intial Sync

After you finish setting up Recurly, you might see its Sync Status show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial sync for the integration. This may take some time to complete.

Recurly Schema

Stitch's Recurly integration includes these tables:


recurly_accounts

Replication Method: Incremental
Primary Key: account_code
Contains Nested Structures?: No

The recurly_accounts table contains comprehensive customer account information.

Table Info & Attributes

recurly_accounts Attributes

While we try to include everything Recurly has here, this may not be a full list of attributes. Refer to Recurly's documentation for a full list and description of each attribute.

  • account_code

  • adjustments

  • account_balance

  • billing_info

  • invoices

  • redemption

  • subscriptions

  • transactions

  • state

  • username

  • email

  • cc_emails

  • first_name

  • last_name

  • company_name

  • vat_number

  • tax_exempt

  • address__address1

  • address__address2

  • address__city

  • address__state

  • address__zip

  • address__country

  • address__phone

  • shipping__address

  • shipping__first_name

  • shipping__last_name

  • shipping__company_name

  • shipping__email

  • shipping__phone

  • shipping__vat_number

  • shipping__address1

  • shipping__address2

  • shipping__city

  • shipping__state

  • shipping__zip

  • shipping__country

  • shipping__nickname

  • accept_language

  • hosted_login_token

  • created_at

  • updated_at

  • closed_at

recurly_add_ons

Replication Method: Incremental
Primary Key: add_on_code
Contains Nested Structures?: Yes

The recurly_add_ons table contains info about plan add-ons, which are additional products in your plan that recur.

Table Info & Attributes

recurly_add_ons & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

recurly_add_ons Attributes

While we try to include everything Recurly has here, this may not be a full list of attributes. Refer to Recurly's documentation for a full list and description of each attribute.

  • add_on_code

  • plan_code

  • name

  • uuid

  • state

  • unit_amount_in_cents*

  • currency

  • quantity

  • activated_at

  • canceled_at

  • expires_at

  • updated_at

  • total_billing_cycles

  • remaining_billing_cycles

  • current_period_started_at

  • current_period_ends_at

  • trial_started_at

  • trial_ends_at

  • terms_and_conditions

  • customer_notes

  • tax_in_cents

  • tax_type

  • tax_region

  • tax_rate

  • po_number

  • net_terms

  • collection_method

  • subscription_add_ons*

recurly_billing_info

Replication Method: Incremental
Primary Key: account_href
Contains Nested Structures?: No

The recurly_billing_info table contains info about your customers' billing details. Note that while there isn't sensitive info (e.g. credit card numbers) in this table, you should still work to keep this data private as there are columns containing bank information.

Table Info & Attributes

recurly_billing_info Attributes

While we try to include everything Recurly has here, this may not be a full list of attributes.

  • account_href

  • first_name

  • last_name

  • company

  • address1

  • address2

  • city

  • state

  • zip

  • country

  • phone

  • vat_number

  • ip_address

  • ip_address_country

  • card_type

  • year

  • month

  • first_six

  • last_four

recurly_coupons

Replication Method: Incremental
Primary Key: coupon_code
Contains Nested Structures?: Yes

The recurly_coupons table contains info on active coupons.

Table Info & Attributes

recurly_coupons & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

recurly_coupons Attributes

While we try to include everything Recurly has here, this may not be a full list of attributes. Refer to Recurly's documentation for a full list and description of each attribute.

  • coupon_code

  • name

  • state

  • description

  • discount_type

  • discount_percent

  • invoice_description

  • redeem_by_date

  • single_use

  • applies_for_months

  • max_redemptions

  • applies_to_all_plans

  • created_at

  • updated_at

  • deleted_at

  • duration

  • temporal_unit

  • temporal_amount

  • applies_to_non_plan_charges

  • redemption_resource

  • max_redemption_per_account

  • coupon_type

  • plan_codes*

recurly_invoices

Replication Method: Incremental
Primary Key: invoice_number
Contains Nested Structures?: Yes

The recurly_invoices table contains info about the invoices in your Recurly account.

Table Info & Attributes

recurly_invoices & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

recurly_invoices Attributes

While we try to include everything Recurly has here, this may not be a full list of attributes. Refer to Recurly's documentation for a full list and description of each attribute.

  • invoice_number

  • address__address1

  • address__address2

  • address__city

  • address__state

  • address__zip

  • address__country

  • address__phone

  • shipping_address__address1

  • shipping_address__address2

  • shipping_address__city

  • shipping_address__state

  • shipping_address__zip

  • shipping_address__country

  • shipping_address__phone

  • uuid

  • state

  • po_number

  • vat_number

  • subtotal_in_cents

  • tax_in_cents

  • total_in_cents

  • currency

  • created_at

  • updated_at

  • closed_at

  • terms_and_conditions

  • customer_notes

  • tax_type

  • tax_region

  • tax_rate

  • net_terms

  • collection_method

  • line_items*

recurly_plans

Replication Method: Full Table
Primary Key: plan_code
Contains Nested Structures?: Yes

The recurly_plans table contains the data relating to each of your plans.

Table Info & Attributes

recurly_plans & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

recurly_plans Attributes

While we try to include everything Recurly has here, this may not be a full list of attributes.

  • plan_code

  • name

  • description

  • success_url

  • cancel_url

  • display_donation_amounts

  • display_quantity

  • display_phone_number

  • display_hosted_confirmation

  • unit_name

  • payment_page_tos_link

  • plan_interval_length

  • plan_interval_unit

  • trial_interval_length

  • trial_interval_unit

  • total_billing_cycles

  • accounting_code

  • setup_fee_accounting_code

  • created_at

  • updated_at

  • revenue_schedule_type

  • setup_fee_schedule_type

  • tax_exempt

  • tax_code

  • unit_amount_in_cents*

  • setup_fee_in_cents*

recurly_redemptions

Replication Method: Incremental
Primary Key: uuid
Contains Nested Structures?: No

The recurly_redemptions table contains data on coupon redemptions at the account level.

Table Info & Attributes

recurly_redemptions Attributes

While we try to include everything Recurly has here, this may not be a full list of attributes. Refer to Recurly's documentation for a full list and description of each attribute.

  • uuid

  • single_use

  • total_discounted_in_cents

  • currency

  • state

  • coupon_code

  • created_at

  • updated_at

recurly_subscriptions

Replication Method: Incremental
Primary Key: uuid
Contains Nested Structures?: Yes

The recurly_subscriptions table contains a record of all your subscriptions.

Table Info & Attributes

recurly_subscriptions & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

recurly_subscriptions Attributes

While we try to include everything Recurly has here, this may not be a full list of attributes. Refer to Recurly's documentation for a full list and description of each attribute.

  • uuid

  • plan_code

  • state

  • currency

  • quantity

  • activated_at

  • canceled_at

  • expires_at

  • updated_at

  • total_billing_cycles

  • remaining_billing_cycles

  • current_period_started_at

  • current_period_ends_at

  • trial_started_at

  • trial_ends_at

  • terms_and_conditions

  • customer_notes

  • tax_in_cents

  • tax_type

  • tax_region

  • tax_rate

  • po_number

  • net_terms

  • collection_method

  • subscription_add_ons*

  • revenue_schedule_type

  • unit_amount_in_cents

recurly_transactions

Replication Method: Incremental
Primary Key: uuid
Contains Nested Structures?: No

The recurly_transactions table contains account transaction info.

Table Info & Attributes

recurly_transactions Attributes

While we try to include everything Recurly has here, this may not be a full list of attributes. Refer to Recurly's documentation for a full list and description of each attribute.

  • uuid

  • action

  • amount_in_cents

  • tax_in_cents

  • currency

  • status

  • payment_method

  • reference

  • source

  • recurring

  • test

  • voidable

  • refundable

  • ip_address

  • cvv_result

  • avs_result

  • avs_result_street

  • avs_result_postal

  • created_at

  • updated_at

  • details__account__account_code

  • details__account__first_name

  • details__account__last_name

  • details__account__company

  • details__account__email

  • details__account__billing_info__first_name

  • details__account__billing_info__last_name

  • details__account__billing_info__address1

  • details__account__billing_info__address2

  • details__account__billing_info__city

  • details__account__billing_info__state

  • details__account__billing_info__zip

  • details__account__billing_info__country

  • details__account__billing_info__phone

  • details__account__billing_info__vat_number

  • details__account__billing_info__card_type

  • details__account__billing_info__year

  • details__account__billing_info__month

  • details__account__billing_info__first_six

  • details__account__billing_info__last_four

Related Troubleshooting
Questions? Feedback?

Did this article help? If you have questions or feedback, please reach out to us.

Tags: saas integrations