Now that Recurly is successfully connected to your Stitch account, what comes next? In this article, we'll cover:
By default, a historical sync of Recurly data goes back one year from the Stitch connection date.
Stitch will replicate Recurly data based on the frequency you define. The default setting is every half hour, but you can change it to more or less frequent based on your needs.
The majority of Recurly tables are replicated using Incremental Table replication.This means that every time Recurly data is queued for replication, only new and updated rows will be replicated.
The only exception to this is the
plans table, which uses Full Table Replication. This means that during every replication attempt, all the rows in this table - including existing, new, and updated - will be replicated.
Due to the potentially high number of rows for each replication attempt, we recommend choosing a less often replication frequency setting to keep your row count down.
Below is a list of the main and subtables that will be created in your data warehouse. Because Recurly uses nested arrays to structure data in some of its API's endpoints, Stitch will de-nest these arrays and create subtables. Refer to the Handling of nested data structures doc for more info.
Click the table name to see a full list of attributes for that table in Recurly's API documentation.
accounts table contains comprehensive customer account information.
Attributes include the account code, billing info URL, subscription URL, state (status), username, email, contact information, tax info, creation info, and more.
add_ons table contains information about plan add-ons, which are additional products in your plan that recur.
Attributes include the add-on code, name, tax code, unit amount, accounting code, and created at date.
add_ons__unit_amount_in_cents- This subtable is created from the unit amount in cents array, which contains unit amounts and currency codes.
billing_info table contains information about your customers' billing details.
Attributes include the account code, contact info, card type, bank info, and more.
Note that while there is not sensitive info (e.g. credit card numbers) in this table, but you should still work to keep this data private as there are columns containing bank information.
coupons table includes information on active coupons.
Attributes include the coupon code, name, state, discount type, redeem by date, max # of redemptions, plan application, duration, and more.
invoices table contains invoice data.
Attributes include the invoice ID (
invoice_number), state (ex:
failed), account info, contact info, tax info, address info, collection method, currency, customer notes, net terms, PO number, subscription URL, subtotal in cents, terms and conditions, vat number, and closed and created at dates.
invoices__line_items- This subtable is created from the line items array, which can contain adjustment, transaction, invoice, and subscription info.
plans table houses the data relating to each of your plans.
Attributes include the plan code, name, description, interval length and unit, trial interval length and unit, total billing cycles, accounting code, tax info, setup fee, and creation info.
redemptions table contains data on coupon redemptions at the account level.
Attributes include the redemption ID (
uuid), total discount, currency, state, and creation information.
subscriptions table is a record of all your subscriptions.
Attributes include the subscription ID (
uuid), plan code, name, ID, state (status), currency, activation date, cancellation and expiration info, trial info, tax info, and add-on info.
transactions table includes account transaction information.
Attributes include the transaction ID (
uuid), account and account details, invoice, and subscription info, transaction amount, currency, status, payment method, source, refundable, IP address, and creation info.