Recurly

Setting up the Recurly connector

No	Item	Required	Example	Notes
1	API Key	Yes		Recurly API Key. See the docs for more information on how to generate this key.
2	begin_time	No	2021-12-01T00:00:00	ISO8601 timestamp from which the replication from Recurly API will start from.
3	end_time	No	2021-12-01T00:00:00	ISO8601 timestamp to which the replication from Recurly API will stop. Records after that date won't be imported.

Tables in the Recurly connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	export_dates	1		Full Refresh
2	subscriptions	43	id	Full Refresh, Incremental	updated_at	API Reference
3	credit_payments	13	id	Full Refresh, Incremental	updated_at
4	account_coupon_redemptions	10	id	Full Refresh, Incremental	updated_at
5	billing_infos	14	id	Full Refresh, Incremental	updated_at
6	measured_units	8	id	Full Refresh, Incremental	updated_at
7	line_items	44	id	Full Refresh, Incremental	updated_at
8	shipping_addresses	17	id	Full Refresh, Incremental	updated_at
9	transactions	37	id	Full Refresh, Incremental	updated_at	API Reference
10	unique_coupons	9	id	Full Refresh, Incremental	updated_at
11	invoices	35	id	Full Refresh, Incremental	updated_at	API Reference
12	shipping_methods	8	id	Full Refresh, Incremental	updated_at
13	account_notes	5	id	Full Refresh, Incremental	created_at
14	coupons	27	id	Full Refresh, Incremental	updated_at	API Reference
15	plans	27	id	Full Refresh, Incremental	updated_at	API Reference
16	add_ons	22	id	Full Refresh, Incremental	updated_at
17	accounts	27	id	Full Refresh, Incremental	updated_at	API Reference

Table: export_dates

No	Column Name	Type	Notes
1	dates	VARCHAR

Table: subscriptions

No	Column Name	Type	Notes
1	canceled_at	VARCHAR
2	created_at	VARCHAR
3	current_period_ends_at	VARCHAR
4	uuid	VARCHAR
5	renewal_billing_cycles	DOUBLE
6	current_period_started_at	VARCHAR
7	total	DOUBLE
8	po_number	VARCHAR
9	pending_change	VARCHAR
10	current_term_started_at	VARCHAR
11	paused_at	VARCHAR
12	expires_at	VARCHAR
13	shipping	VARCHAR
14	updated_at	VARCHAR	Incremental sync key
15	bank_account_authorized_at	VARCHAR
16	add_ons	VARCHAR
17	currency	VARCHAR
18	net_terms	DOUBLE
19	id	VARCHAR	Primary Key
20	state	VARCHAR
21	plan	VARCHAR
22	billing_info_id	VARCHAR
23	total_billing_cycles	DOUBLE
24	remaining_billing_cycles	DOUBLE
25	quantity	DOUBLE
26	current_term_ends_at	VARCHAR
27	revenue_schedule_type	VARCHAR
28	tax	DOUBLE
29	unit_amount	DOUBLE
30	customer_notes	VARCHAR
31	terms_and_conditions	VARCHAR
32	activated_at	VARCHAR
33	expiration_reason	VARCHAR
34	auto_renew	BOOLEAN
35	tax_info	VARCHAR
36	add_ons_total	DOUBLE
37	subtotal	DOUBLE
38	collection_method	VARCHAR
39	trial_started_at	VARCHAR
40	trial_ends_at	VARCHAR
41	remaining_pause_cycles	DOUBLE
42	gateway_code	VARCHAR
43	account	VARCHAR

Table: credit_payments

No	Column Name	Type	Notes
1	original_invoice	VARCHAR
2	voided_at	VARCHAR
3	amount	DOUBLE
4	created_at	VARCHAR
5	uuid	VARCHAR
6	applied_to_invoice	VARCHAR
7	updated_at	VARCHAR	Incremental sync key
8	action	VARCHAR
9	currency	VARCHAR
10	original_credit_payment_id	VARCHAR
11	id	VARCHAR	Primary Key
12	account	VARCHAR
13	refund_transaction	VARCHAR

Table: account_coupon_redemptions

No	Column Name	Type	Notes
1	subscription_id	VARCHAR
2	discounted	DOUBLE
3	removed_at	VARCHAR
4	coupon	VARCHAR
5	updated_at	VARCHAR	Incremental sync key
6	created_at	VARCHAR
7	currency	VARCHAR
8	id	VARCHAR	Primary Key
9	state	VARCHAR
10	account	VARCHAR

Table: billing_infos

No	Column Name	Type	Notes
1	address	VARCHAR
2	vat_number	VARCHAR
3	last_name	VARCHAR
4	created_at	VARCHAR
5	primary_payment_method	BOOLEAN
6	valid	BOOLEAN
7	account_id	VARCHAR
8	updated_at	VARCHAR	Incremental sync key
9	fraud	VARCHAR
10	backup_payment_method	BOOLEAN
11	company	VARCHAR
12	id	VARCHAR	Primary Key
13	first_name	VARCHAR
14	payment_method	VARCHAR

Table: measured_units

No	Column Name	Type	Notes
1	updated_at	VARCHAR	Incremental sync key
2	name	VARCHAR
3	description	VARCHAR
4	created_at	VARCHAR
5	id	VARCHAR	Primary Key
6	state	VARCHAR
7	display_name	VARCHAR
8	deleted_at	VARCHAR

Table: line_items

No	Column Name	Type	Notes
1	external_sku	VARCHAR
2	end_date	VARCHAR
3	item_code	VARCHAR
4	credit_applied	DOUBLE
5	origin	VARCHAR
6	plan_code	VARCHAR
7	description	VARCHAR
8	discount	DOUBLE
9	created_at	VARCHAR
10	type	VARCHAR
11	product_code	VARCHAR
12	uuid	VARCHAR
13	subscription_id	VARCHAR
14	updated_at	VARCHAR	Incremental sync key
15	refunded_quantity	INTEGER
16	invoice_id	VARCHAR
17	currency	VARCHAR
18	id	VARCHAR	Primary Key
19	state	VARCHAR
20	shipping_address	VARCHAR
21	legacy_category	VARCHAR
22	invoice_number	VARCHAR
23	start_date	VARCHAR
24	amount	DOUBLE
25	add_on_id	VARCHAR
26	previous_line_item_id	VARCHAR
27	quantity	INTEGER
28	taxable	BOOLEAN
29	item_id	VARCHAR
30	tax_exempt	BOOLEAN
31	proration_rate	DOUBLE
32	revenue_schedule_type	VARCHAR
33	unit_amount_decimal	VARCHAR
34	tax	DOUBLE
35	unit_amount	DOUBLE
36	bill_for_account_id	VARCHAR
37	credit_reason_code	VARCHAR
38	accounting_code	VARCHAR
39	tax_code	VARCHAR
40	subtotal	DOUBLE
41	add_on_code	VARCHAR
42	original_line_item_invoice_id	VARCHAR
43	plan_id	VARCHAR
44	refund	BOOLEAN

Table: shipping_addresses

No	Column Name	Type	Notes
1	country	VARCHAR
2	city	VARCHAR
3	vat_number	VARCHAR
4	last_name	VARCHAR
5	created_at	VARCHAR
6	account_id	VARCHAR
7	updated_at	VARCHAR	Incremental sync key
8	phone	VARCHAR
9	nickname	VARCHAR
10	company	VARCHAR
11	street1	VARCHAR
12	id	VARCHAR	Primary Key
13	street2	VARCHAR
14	region	VARCHAR
15	postal_code	VARCHAR
16	first_name	VARCHAR
17	email	VARCHAR

Table: transactions

No	Column Name	Type	Notes
1	status_message	VARCHAR
2	voided_at	VARCHAR
3	ip_address_v4	VARCHAR
4	avs_check	VARCHAR
5	original_transaction_id	VARCHAR
6	status_code	VARCHAR
7	ip_address_country	VARCHAR
8	origin	VARCHAR
9	gateway_approval_code	VARCHAR
10	created_at	VARCHAR
11	billing_address	VARCHAR
12	type	VARCHAR
13	uuid	VARCHAR
14	customer_message_locale	VARCHAR
15	cvv_check	VARCHAR
16	subscription_ids	VARCHAR
17	updated_at	VARCHAR	Incremental sync key
18	currency	VARCHAR
19	refunded	BOOLEAN
20	id	VARCHAR	Primary Key
21	payment_method	VARCHAR
22	gateway_response_time	DOUBLE
23	amount	DOUBLE
24	customer_message	VARCHAR
25	payment_gateway	VARCHAR
26	gateway_reference	VARCHAR
27	backup_payment_method_used	BOOLEAN
28	voided_by_invoice	VARCHAR
29	collected_at	VARCHAR
30	gateway_message	VARCHAR
31	success	BOOLEAN
32	gateway_response_code	VARCHAR
33	collection_method	VARCHAR
34	invoice	VARCHAR
35	account	VARCHAR
36	status	VARCHAR
37	gateway_response_values	VARCHAR

Table: unique_coupons

No	Column Name	Type	Notes
1	redeemed_at	VARCHAR
2	code	VARCHAR
3	bulk_coupon_id	VARCHAR
4	updated_at	VARCHAR	Incremental sync key
5	created_at	VARCHAR
6	id	VARCHAR	Primary Key
7	state	VARCHAR
8	expired_at	VARCHAR
9	bulk_coupon_code	VARCHAR

Table: invoices

No	Column Name	Type	Notes
1	vat_number	VARCHAR
2	origin	VARCHAR
3	discount	DOUBLE
4	created_at	VARCHAR
5	line_items	VARCHAR
6	type	VARCHAR
7	vat_reverse_charge_notes	VARCHAR
8	subscription_ids	VARCHAR
9	number	VARCHAR
10	po_number	VARCHAR
11	total	DOUBLE
12	balance	DOUBLE
13	updated_at	VARCHAR	Incremental sync key
14	dunning_campaign_id	VARCHAR
15	previous_invoice_id	VARCHAR
16	net_terms	INTEGER
17	currency	VARCHAR
18	due_at	VARCHAR
19	id	VARCHAR	Primary Key
20	state	VARCHAR
21	shipping_address	VARCHAR
22	billing_info_id	VARCHAR
23	address	VARCHAR
24	closed_at	VARCHAR
25	credit_payments	VARCHAR
26	tax	DOUBLE
27	customer_notes	VARCHAR
28	transactions	VARCHAR
29	terms_and_conditions	VARCHAR
30	refundable_amount	DOUBLE
31	tax_info	VARCHAR
32	subtotal	DOUBLE
33	collection_method	VARCHAR
34	paid	DOUBLE
35	account	VARCHAR

Table: shipping_methods

No	Column Name	Type	Notes
1	accounting_code	VARCHAR
2	tax_code	VARCHAR
3	code	VARCHAR
4	updated_at	VARCHAR	Incremental sync key
5	name	VARCHAR
6	created_at	VARCHAR
7	id	VARCHAR	Primary Key
8	deleted_at	VARCHAR

Table: account_notes

No	Column Name	Type	Notes
1	account_id	VARCHAR
2	created_at	VARCHAR	Incremental sync key
3	id	VARCHAR	Primary Key
4	message	VARCHAR
5	user	VARCHAR

Table: coupons

No	Column Name	Type	Notes
1	redeem_by	VARCHAR
2	code	VARCHAR
3	unique_coupon_codes_count	DOUBLE
4	discount	VARCHAR
5	created_at	VARCHAR
6	expired_at	VARCHAR
7	duration	VARCHAR
8	applies_to_non_plan_charges	BOOLEAN
9	updated_at	VARCHAR	Incremental sync key
10	max_redemptions_per_account	DOUBLE
11	invoice_description	VARCHAR
12	id	VARCHAR	Primary Key
13	state	VARCHAR
14	applies_to_all_items	BOOLEAN
15	temporal_unit	VARCHAR
16	max_redemptions	DOUBLE
17	free_trial_unit	VARCHAR
18	applies_to_all_plans	BOOLEAN
19	hosted_page_description	VARCHAR
20	redemption_resource	VARCHAR
21	free_trial_amount	DOUBLE
22	unique_code_template	VARCHAR
23	temporal_amount	DOUBLE
24	plans	VARCHAR
25	name	VARCHAR
26	items	VARCHAR
27	coupon_type	VARCHAR

Table: plans

No	Column Name	Type	Notes
1	hosted_pages	VARCHAR
2	code	VARCHAR
3	setup_fee_accounting_code	VARCHAR
4	allow_any_item_on_subscriptions	BOOLEAN
5	description	VARCHAR
6	created_at	VARCHAR
7	trial_length	DOUBLE
8	interval_unit	VARCHAR
9	dunning_campaign_id	VARCHAR
10	updated_at	VARCHAR	Incremental sync key
11	avalara_service_type	DOUBLE
12	trial_unit	VARCHAR
13	trial_requires_billing_info	BOOLEAN
14	id	VARCHAR	Primary Key
15	state	VARCHAR
16	total_billing_cycles	DOUBLE
17	tax_exempt	BOOLEAN
18	revenue_schedule_type	VARCHAR
19	setup_fee_revenue_schedule_type	VARCHAR
20	avalara_transaction_type	DOUBLE
21	deleted_at	VARCHAR
22	accounting_code	VARCHAR
23	tax_code	VARCHAR
24	auto_renew	BOOLEAN
25	name	VARCHAR
26	interval_length	DOUBLE
27	currencies	VARCHAR

Table: add_ons

No	Column Name	Type	Notes
1	add_on_type	VARCHAR
2	code	VARCHAR
3	display_quantity	BOOLEAN
4	usage_percentage	DOUBLE
5	revenue_schedule_type	VARCHAR
6	created_at	VARCHAR
7	avalara_transaction_type	VARCHAR
8	optional	BOOLEAN
9	deleted_at	VARCHAR
10	accounting_code	VARCHAR
11	tax_code	VARCHAR
12	updated_at	VARCHAR	Incremental sync key
13	usage_type	VARCHAR
14	avalara_service_type	VARCHAR
15	measured_unit_id	VARCHAR
16	name	VARCHAR
17	default_quantity	INTEGER
18	id	VARCHAR	Primary Key
19	state	VARCHAR
20	tier_type	VARCHAR
21	plan_id	VARCHAR
22	currencies	VARCHAR

Table: accounts

No	Column Name	Type	Notes
1	bill_to	VARCHAR
2	has_future_subscription	BOOLEAN
3	preferred_locale	VARCHAR
4	code	VARCHAR
5	vat_number	VARCHAR
6	created_at	VARCHAR
7	has_live_subscription	BOOLEAN
8	has_paused_subscription	BOOLEAN
9	cc_emails	VARCHAR
10	dunning_campaign_id	VARCHAR
11	updated_at	VARCHAR	Incremental sync key
12	exemption_certificate	VARCHAR
13	company	VARCHAR
14	id	VARCHAR	Primary Key
15	state	VARCHAR
16	first_name	VARCHAR
17	email	VARCHAR
18	address	VARCHAR
19	tax_exempt	BOOLEAN
20	custom_fields	VARCHAR
21	has_active_subscription	BOOLEAN
22	last_name	VARCHAR
23	deleted_at	VARCHAR
24	has_canceled_subscription	BOOLEAN
25	parent_account_id	VARCHAR
26	has_past_due_invoice	BOOLEAN
27	username	VARCHAR

External Resources

• Account Notes
• Account Coupon Redemptions
• Add Ons
• Billing Infos
• Unique Coupons
• Credit Payments
• Automated Exports
• Measured Units
• Line Items
• Shipping Addresses
• Shipping Methods
• Subscription Changes
• Recurly Documentation

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.