Chargebee

Prerequisites

To set up the Chargebee source connector, you'll need the Chargebee API key and the Product Catalog version.

Tables in the Chargebee connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	gift	12	id	Full Refresh, Incremental	updated_at
2	item	25	id	Full Refresh, Incremental	updated_at
3	virtual_bank_account	15
4	coupon	25	id	Full Refresh, Incremental	updated_at
5	addon	40
6	item_price	37	id	Full Refresh, Incremental	updated_at
7	hosted_page	14	id	Full Refresh, Incremental	updated_at
8	subscription	74	id	Full Refresh, Incremental	updated_at
9	promotional_credit	13	id	Full Refresh, Incremental	updated_at
10	credit_note	39	id	Full Refresh, Incremental	updated_at
11	quote	38	id	Full Refresh, Incremental	updated_at
12	contact	10	id	Full Refresh, Incremental	updated_at
13	unbilled_charge	24	id	Full Refresh, Incremental	updated_at
14	payment_source	21	id	Full Refresh, Incremental	updated_at
15	invoice	59	id	Full Refresh, Incremental	updated_at
16	event	10	id	Full Refresh, Incremental	occurred_at
17	plan	52
18	transaction	49	id	Full Refresh, Incremental	updated_at
19	attached_item	14	id	Full Refresh, Incremental	updated_at
20	quote_line_group	15	id	Full Refresh, Incremental	updated_at
21	customer	57	id	Full Refresh, Incremental	updated_at
22	order	56	id	Full Refresh, Incremental	updated_at

Table: gift

No	Column Name	Type	Notes
1	no_expiry	BOOLEAN
2	gift_receiver	VARCHAR
3	auto_claim	BOOLEAN
4	updated_at	INTEGER	Incremental sync key
5	gift_timelines	VARCHAR
6	custom_fields	VARCHAR
7	gifter	VARCHAR
8	scheduled_at	INTEGER
9	id	VARCHAR	Primary Key
10	resource_version	INTEGER
11	claim_expiry_date	INTEGER
12	status	VARCHAR

Table: item

No	Column Name	Type	Notes
1	metadata	VARCHAR
2	channel	VARCHAR
3	description	VARCHAR
4	type	VARCHAR
5	resource_version	INTEGER
6	item_applicability	VARCHAR
7	is_shippable	BOOLEAN
8	updated_at	INTEGER	Incremental sync key
9	enabled_for_checkout	BOOLEAN
10	metered	BOOLEAN
11	id	VARCHAR	Primary Key
12	usage_calculation	VARCHAR
13	included_in_mrr	BOOLEAN
14	archived_at	INTEGER
15	custom_fields	VARCHAR
16	item_family_id	VARCHAR
17	is_giftable	BOOLEAN
18	enabled_in_portal	BOOLEAN
19	unit	VARCHAR
20	applicable_items	VARCHAR
21	gift_claim_redirect_url	VARCHAR
22	name	VARCHAR
23	redirect_url	VARCHAR
24	status	VARCHAR
25	object	VARCHAR

Table: virtual_bank_account

No	Column Name	Type	Notes
1	account_number	VARCHAR
2	scheme	VARCHAR
3	reference_id	VARCHAR
4	swift_code	VARCHAR
5	custom_fields	VARCHAR
6	created_at	INTEGER
7	routing_number	VARCHAR
8	resource_version	INTEGER
9	deleted	BOOLEAN
10	updated_at	INTEGER
11	bank_name	VARCHAR
12	id	VARCHAR
13	customer_id	VARCHAR
14	email	VARCHAR
15	gateway	VARCHAR

Table: coupon

No	Column Name	Type	Notes
1	invoice_notes	VARCHAR
2	period_unit	VARCHAR
3	apply_on	VARCHAR
4	discount_amount	INTEGER
5	created_at	INTEGER
6	discount_percentage	DOUBLE
7	resource_version	INTEGER
8	invoice_name	VARCHAR
9	currency_code	VARCHAR
10	apply_discount_on	VARCHAR
11	valid_till	INTEGER
12	duration_month	INTEGER
13	updated_at	INTEGER	Incremental sync key
14	id	VARCHAR	Primary Key
15	item_constraint_criteria	VARCHAR
16	period	INTEGER
17	archived_at	INTEGER
18	custom_fields	VARCHAR
19	duration_type	VARCHAR
20	max_redemptions	INTEGER
21	discount_type	VARCHAR
22	redemptions	INTEGER
23	name	VARCHAR
24	item_constraints	VARCHAR
25	status	VARCHAR

Table: addon

No	Column Name	Type	Notes
1	invoice_notes	VARCHAR
2	show_description_in_invoices	BOOLEAN
3	charge_type	VARCHAR
4	tiers	VARCHAR
5	period_unit	VARCHAR
6	description	VARCHAR
7	tax_profile_id	VARCHAR
8	price_in_decimal	VARCHAR
9	resource_version	INTEGER
10	invoice_name	VARCHAR
11	currency_code	VARCHAR
12	is_shippable	BOOLEAN
13	avalara_sale_type	VARCHAR
14	shipping_frequency_period_unit	VARCHAR
15	updated_at	INTEGER
16	price	INTEGER
17	avalara_service_type	INTEGER
18	pricing_model	VARCHAR
19	meta_data	VARCHAR
20	id	VARCHAR
21	sku	VARCHAR
22	included_in_mrr	BOOLEAN
23	period	INTEGER
24	taxable	BOOLEAN
25	archived_at	INTEGER
26	custom_fields	VARCHAR
27	accounting_category4	VARCHAR
28	show_description_in_quotes	BOOLEAN
29	avalara_transaction_type	INTEGER
30	enabled_in_portal	BOOLEAN
31	accounting_category1	VARCHAR
32	accounting_category3	VARCHAR
33	accounting_category2	VARCHAR
34	accounting_code	VARCHAR
35	unit	VARCHAR
36	tax_code	VARCHAR
37	taxjar_product_code	VARCHAR
38	name	VARCHAR
39	shipping_frequency_period	INTEGER
40	status	VARCHAR

Table: item_price

No	Column Name	Type	Notes
1	invoice_notes	VARCHAR
2	show_description_in_invoices	BOOLEAN
3	metadata	VARCHAR
4	tiers	VARCHAR
5	period_unit	VARCHAR
6	item_type	VARCHAR
7	channel	VARCHAR
8	description	VARCHAR
9	created_at	INTEGER
10	price_in_decimal	VARCHAR
11	resource_version	INTEGER
12	currency_code	VARCHAR
13	shipping_period	INTEGER
14	trial_end_action	VARCHAR
15	updated_at	INTEGER	Incremental sync key
16	price	INTEGER
17	pricing_model	VARCHAR
18	id	VARCHAR	Primary Key
19	period	INTEGER
20	item_id	VARCHAR
21	archived_at	INTEGER
22	custom_fields	VARCHAR
23	accounting_detail	VARCHAR
24	item_family_id	VARCHAR
25	shipping_period_unit	VARCHAR
26	show_description_in_quotes	BOOLEAN
27	free_quantity	INTEGER
28	trial_period_unit	VARCHAR
29	name	VARCHAR
30	billing_cycles	INTEGER
31	tax_detail	VARCHAR
32	trial_period	INTEGER
33	external_name	VARCHAR
34	is_taxable	BOOLEAN
35	status	VARCHAR
36	free_quantity_in_decimal	VARCHAR
37	object	VARCHAR

Table: hosted_page

No	Column Name	Type	Notes
1	custom_fields	VARCHAR
2	created_at	INTEGER
3	checkout_info	VARCHAR
4	type	VARCHAR
5	resource_version	INTEGER
6	url	VARCHAR
7	pass_thru_content	VARCHAR
8	content	VARCHAR
9	expires_at	INTEGER
10	updated_at	INTEGER	Incremental sync key
11	id	VARCHAR	Primary Key
12	state	VARCHAR
13	embed	BOOLEAN
14	business_entity_id	VARCHAR

Table: subscription

No	Column Name	Type	Notes
1	cancelled_at	INTEGER
2	invoice_notes	VARCHAR
3	subscription_items	VARCHAR
4	billing_period	INTEGER
5	metadata	VARCHAR
6	addons	VARCHAR
7	override_relationship	BOOLEAN
8	billing_period_unit	VARCHAR
9	next_billing_at	INTEGER
10	free_period	INTEGER
11	item_tiers	VARCHAR
12	contract_term	VARCHAR
13	created_from_ip	VARCHAR
14	discounts	VARCHAR
15	coupons	VARCHAR
16	cancel_reason_code	VARCHAR
17	meta_data	VARCHAR
18	id	VARCHAR	Primary Key
19	has_scheduled_advance_invoices	BOOLEAN
20	payment_source_id	VARCHAR
21	setup_fee	INTEGER
22	auto_close_invoices	BOOLEAN
23	plan_unit_price_in_decimal	VARCHAR
24	due_invoices_count	INTEGER
25	exchange_rate	DOUBLE
26	custom_fields	VARCHAR
27	gift_id	VARCHAR
28	plan_quantity	INTEGER
29	referral_info	VARCHAR
30	affiliate_token	VARCHAR
31	offline_payment_method	VARCHAR
32	plan_unit_price	INTEGER
33	activated_at	INTEGER
34	cancel_schedule_created_at	INTEGER
35	plan_amount_in_decimal	VARCHAR
36	due_since	INTEGER
37	charged_event_based_addons	VARCHAR
38	started_at	INTEGER
39	status	VARCHAR
40	object	VARCHAR
41	plan_free_quantity	INTEGER
42	resume_date	INTEGER
43	plan_quantity_in_decimal	VARCHAR
44	current_term_start	INTEGER
45	created_at	INTEGER
46	resource_version	INTEGER
47	plan_amount	INTEGER
48	currency_code	VARCHAR
49	po_number	VARCHAR
50	trial_end_action	VARCHAR
51	updated_at	INTEGER	Incremental sync key
52	auto_collection	VARCHAR
53	event_based_addons	VARCHAR
54	free_period_unit	VARCHAR
55	shipping_address	VARCHAR
56	base_currency_code	VARCHAR
57	start_date	INTEGER
58	plan_free_quantity_in_decimal	VARCHAR
59	remaining_billing_cycles	INTEGER
60	has_scheduled_changes	BOOLEAN
61	coupon	VARCHAR
62	create_pending_invoices	BOOLEAN
63	trial_end	INTEGER
64	current_term_end	INTEGER
65	charged_items	VARCHAR
66	mrr	INTEGER
67	cancel_reason	VARCHAR
68	deleted	BOOLEAN
69	contract_term_billing_cycle_on_renewal	INTEGER
70	total_dues	INTEGER
71	trial_start	INTEGER
72	customer_id	VARCHAR
73	plan_id	VARCHAR
74	pause_date	INTEGER

Table: promotional_credit

No	Column Name	Type	Notes
1	amount	INTEGER
2	done_by	VARCHAR
3	custom_fields	VARCHAR
4	description	VARCHAR
5	created_at	INTEGER
6	type	VARCHAR
7	credit_type	VARCHAR
8	currency_code	VARCHAR
9	reference	VARCHAR
10	closing_balance	INTEGER
11	amount_in_decimal	VARCHAR
12	id	VARCHAR	Primary Key
13	customer_id	VARCHAR

Table: credit_note

No	Column Name	Type	Notes
1	date	INTEGER
2	voided_at	INTEGER
3	vat_number	VARCHAR
4	taxes	VARCHAR
5	local_currency_code	VARCHAR
6	line_items	VARCHAR
7	type	VARCHAR
8	resource_version	INTEGER
9	total_in_local_currency	INTEGER
10	currency_code	VARCHAR
11	amount_refunded	INTEGER
12	subscription_id	VARCHAR
13	reason_code	VARCHAR
14	line_item_discounts	VARCHAR
15	total	INTEGER
16	amount_available	INTEGER
17	refunded_at	INTEGER
18	updated_at	INTEGER	Incremental sync key
19	discounts	VARCHAR
20	allocations	VARCHAR
21	generated_at	INTEGER
22	id	VARCHAR	Primary Key
23	sub_total_in_local_currency	INTEGER
24	fractional_correction	INTEGER
25	vat_number_prefix	VARCHAR
26	linked_refunds	VARCHAR
27	custom_fields	VARCHAR
28	line_item_tiers	VARCHAR
29	amount_allocated	INTEGER
30	line_item_taxes	VARCHAR
31	create_reason_code	VARCHAR
32	deleted	BOOLEAN
33	reference_invoice_id	VARCHAR
34	linked_tax_withheld_refunds	VARCHAR
35	sub_total	INTEGER
36	price_type	VARCHAR
37	round_off_amount	INTEGER
38	customer_id	VARCHAR
39	status	VARCHAR

Table: quote

No	Column Name	Type	Notes
1	date	INTEGER
2	amount_paid	INTEGER
3	charge_on_acceptance	INTEGER
4	notes	VARCHAR
5	operation_type	VARCHAR
6	contract_term_termination_fee	INTEGER
7	contract_term_end	INTEGER
8	vat_number	VARCHAR
9	taxes	VARCHAR
10	billing_address	VARCHAR
11	line_items	VARCHAR
12	resource_version	INTEGER
13	currency_code	VARCHAR
14	subscription_id	VARCHAR
15	line_item_discounts	VARCHAR
16	po_number	VARCHAR
17	total	INTEGER
18	valid_till	INTEGER
19	updated_at	INTEGER	Incremental sync key
20	discounts	VARCHAR
21	credits_applied	INTEGER
22	total_payable	INTEGER
23	invoice_id	VARCHAR
24	amount_due	INTEGER
25	id	VARCHAR	Primary Key
26	shipping_address	VARCHAR
27	business_entity_id	VARCHAR
28	contract_term_start	INTEGER
29	vat_number_prefix	VARCHAR
30	custom_fields	VARCHAR
31	line_item_tiers	VARCHAR
32	version	INTEGER
33	line_item_taxes	VARCHAR
34	name	VARCHAR
35	sub_total	INTEGER
36	price_type	VARCHAR
37	customer_id	VARCHAR
38	status	VARCHAR

Table: contact

No	Column Name	Type	Notes
1	custom_fields	VARCHAR
2	last_name	VARCHAR
3	id	VARCHAR	Primary Key
4	label	VARCHAR
5	send_account_email	BOOLEAN
6	send_billing_email	BOOLEAN
7	first_name	VARCHAR
8	email	VARCHAR
9	enabled	BOOLEAN
10	object	VARCHAR

Table: unbilled_charge

No	Column Name	Type	Notes
1	voided_at	INTEGER
2	amount	INTEGER
3	is_advance_charge	BOOLEAN
4	tiers	VARCHAR
5	quantity	INTEGER
6	quantity_in_decimal	VARCHAR
7	discount_amount	INTEGER
8	custom_fields	VARCHAR
9	description	VARCHAR
10	date_to	INTEGER
11	unit_amount	INTEGER
12	entity_id	VARCHAR
13	currency_code	VARCHAR
14	subscription_id	VARCHAR
15	entity_type	VARCHAR
16	deleted	BOOLEAN
17	updated_at	INTEGER	Incremental sync key
18	unit_amount_in_decimal	VARCHAR
19	pricing_model	VARCHAR
20	amount_in_decimal	VARCHAR
21	is_voided	BOOLEAN
22	id	VARCHAR	Primary Key
23	customer_id	VARCHAR
24	date_from	INTEGER

Table: payment_source

No	Column Name	Type	Notes
1	amazon_payment	VARCHAR
2	gateway_account_id	VARCHAR
3	reference_id	VARCHAR
4	custom_fields	VARCHAR
5	created_at	INTEGER
6	ip_address	VARCHAR
7	mandates	VARCHAR
8	type	VARCHAR
9	resource_version	INTEGER
10	upi	VARCHAR
11	deleted	BOOLEAN
12	updated_at	INTEGER	Incremental sync key
13	issuing_country	VARCHAR
14	id	VARCHAR	Primary Key
15	customer_id	VARCHAR
16	business_entity_id	VARCHAR
17	paypal	VARCHAR
18	gateway	VARCHAR
19	card	VARCHAR
20	status	VARCHAR
21	bank_account	VARCHAR

Table: invoice

No	Column Name	Type	Notes
1	date	INTEGER
2	amount_paid	INTEGER
3	notes	VARCHAR
4	vat_number	VARCHAR
5	adjustment_credit_notes	VARCHAR
6	taxes	VARCHAR
7	applied_credits	VARCHAR
8	billing_address	VARCHAR
9	local_currency_code	VARCHAR
10	line_items	VARCHAR
11	issued_credit_notes	VARCHAR
12	subscription_id	VARCHAR
13	amount_to_collect	INTEGER
14	new_sales_amount	INTEGER
15	discounts	VARCHAR
16	linked_orders	VARCHAR
17	credits_applied	INTEGER
18	generated_at	INTEGER
19	void_reason_code	VARCHAR
20	amount_due	INTEGER
21	id	VARCHAR	Primary Key
22	sub_total_in_local_currency	INTEGER
23	vat_number_prefix	VARCHAR
24	exchange_rate	DOUBLE
25	recurring	BOOLEAN
26	net_term_days	INTEGER
27	custom_fields	VARCHAR
28	line_item_tiers	VARCHAR
29	tax	INTEGER
30	expected_payment_date	INTEGER
31	paid_at	INTEGER
32	amount_adjusted	INTEGER
33	price_type	VARCHAR
34	next_retry_at	INTEGER
35	dunning_status	VARCHAR
36	payment_owner	VARCHAR
37	status	VARCHAR
38	voided_at	INTEGER
39	write_off_amount	INTEGER
40	resource_version	INTEGER
41	total_in_local_currency	INTEGER
42	currency_code	VARCHAR
43	line_item_discounts	VARCHAR
44	first_invoice	BOOLEAN
45	po_number	VARCHAR
46	total	INTEGER
47	updated_at	INTEGER	Incremental sync key
48	term_finalized	BOOLEAN
49	shipping_address	VARCHAR
50	linked_payments	VARCHAR
51	dunning_attempts	VARCHAR
52	is_gifted	BOOLEAN
53	due_date	INTEGER
54	has_advance_charges	BOOLEAN
55	line_item_taxes	VARCHAR
56	deleted	BOOLEAN
57	sub_total	INTEGER
58	round_off_amount	INTEGER
59	customer_id	VARCHAR

Table: event

No	Column Name	Type	Notes
1	occurred_at	INTEGER	Incremental sync key
2	event_type	VARCHAR
3	webhooks	VARCHAR
4	custom_fields	VARCHAR
5	webhook_status	VARCHAR
6	id	VARCHAR	Primary Key
7	source	VARCHAR
8	api_version	VARCHAR
9	user	VARCHAR
10	content	VARCHAR

Table: plan

No	Column Name	Type	Notes
1	invoice_notes	VARCHAR
2	show_description_in_invoices	BOOLEAN
3	period_unit	VARCHAR
4	setup_cost	INTEGER
5	tax_profile_id	VARCHAR
6	invoice_name	VARCHAR
7	avalara_sale_type	VARCHAR
8	price	INTEGER
9	pricing_model	VARCHAR
10	meta_data	VARCHAR
11	attached_addons	VARCHAR
12	id	VARCHAR
13	sku	VARCHAR
14	applicable_addons	VARCHAR
15	period	INTEGER
16	taxable	BOOLEAN
17	custom_fields	VARCHAR
18	accounting_category4	VARCHAR
19	show_description_in_quotes	BOOLEAN
20	avalara_transaction_type	INTEGER
21	enabled_in_portal	BOOLEAN
22	accounting_category1	VARCHAR
23	accounting_category3	VARCHAR
24	free_quantity	INTEGER
25	accounting_category2	VARCHAR
26	giftable	BOOLEAN
27	name	VARCHAR
28	trial_period	INTEGER
29	addon_applicability	VARCHAR
30	shipping_frequency_period	INTEGER
31	redirect_url	VARCHAR
32	status	VARCHAR
33	tiers	VARCHAR
34	description	VARCHAR
35	price_in_decimal	VARCHAR
36	resource_version	INTEGER
37	currency_code	VARCHAR
38	is_shippable	BOOLEAN
39	trial_end_action	VARCHAR
40	shipping_frequency_period_unit	VARCHAR
41	updated_at	INTEGER
42	event_based_addons	VARCHAR
43	avalara_service_type	INTEGER
44	claim_url	VARCHAR
45	archived_at	INTEGER
46	accounting_code	VARCHAR
47	tax_code	VARCHAR
48	taxjar_product_code	VARCHAR
49	trial_period_unit	VARCHAR
50	billing_cycles	INTEGER
51	enabled_in_hosted_pages	BOOLEAN
52	free_quantity_in_decimal	VARCHAR

Table: transaction

No	Column Name	Type	Notes
1	date	INTEGER
2	reversal_transaction_id	VARCHAR
3	cn_reference_invoice_id	VARCHAR
4	txn_amount	INTEGER
5	type	VARCHAR
6	refunded_txn_id	VARCHAR
7	subscription_id	VARCHAR
8	authorization_reason	VARCHAR
9	error-text	VARCHAR
10	fraud_reason	VARCHAR
11	id	VARCHAR	Primary Key
12	linked_invoices	VARCHAR
13	payment_method	VARCHAR
14	payment_source_id	VARCHAR
15	gateway_account_id	VARCHAR
16	exchange_rate	DOUBLE
17	cn_date	INTEGER
18	custom_fields	VARCHAR
19	linked_credit_notes	VARCHAR
20	cn_status	VARCHAR
21	fraud_flag	VARCHAR
22	three_d_source	BOOLEAN
23	cn_create_reason_code	VARCHAR
24	error_code	VARCHAR
25	status	VARCHAR
26	voided_at	INTEGER
27	last4	VARCHAR
28	cn_total	INTEGER
29	amount_capturable	INTEGER
30	resource_version	INTEGER
31	currency_code	VARCHAR
32	iin	VARCHAR
33	amount_unused	INTEGER
34	reference_transaction_id	VARCHAR
35	updated_at	INTEGER	Incremental sync key
36	settled_at	INTEGER
37	merchant_reference_id	VARCHAR
38	linked_payments	VARCHAR
39	amount	INTEGER
40	reference_authorization_id	VARCHAR
41	linked_refunds	VARCHAR
42	masked_card_number	VARCHAR
43	initiator_type	VARCHAR
44	txn_date	INTEGER
45	deleted	BOOLEAN
46	refrence_number	VARCHAR
47	customer_id	VARCHAR
48	id_at_gateway	VARCHAR
49	gateway	VARCHAR

Table: attached_item

No	Column Name	Type	Notes
1	quantity	INTEGER
2	quantity_in_decimal	VARCHAR
3	item_id	VARCHAR
4	charge_once	BOOLEAN
5	created_at	INTEGER
6	type	VARCHAR
7	resource_version	INTEGER
8	charge_on_event	VARCHAR
9	updated_at	INTEGER	Incremental sync key
10	parent_item_id	VARCHAR
11	billing_cycles	INTEGER
12	id	VARCHAR	Primary Key
13	status	VARCHAR
14	object	VARCHAR

Table: quote_line_group

No	Column Name	Type	Notes
1	amount_paid	INTEGER
2	custom_fields	VARCHAR
3	taxes	VARCHAR
4	line_items	VARCHAR
5	version	INTEGER
6	line_item_taxes	VARCHAR
7	line_item_discounts	VARCHAR
8	total	INTEGER
9	billing_cycle_number	INTEGER
10	discounts	VARCHAR
11	charge_event	VARCHAR
12	credits_applied	INTEGER
13	sub_total	INTEGER
14	amount_due	INTEGER
15	id	VARCHAR	Primary Key

Table: customer

No	Column Name	Type	Notes
1	billing_day_of_week_mode	VARCHAR
2	invoice_notes	VARCHAR
3	vat_number	VARCHAR
4	referral_urls	VARCHAR
5	billing_address	VARCHAR
6	exempt_number	VARCHAR
7	created_from_ip	VARCHAR
8	preferred_currency_code	VARCHAR
9	entity_code	VARCHAR
10	meta_data	VARCHAR
11	id	VARCHAR	Primary Key
12	backup_payment_source_id	VARCHAR
13	pii_cleared	VARCHAR
14	payment_method	VARCHAR
15	consolidated_invoicing	BOOLEAN
16	registered_for_gst	BOOLEAN
17	auto_close_invoices	BOOLEAN
18	vat_number_prefix	VARCHAR
19	allow_direct_debit	BOOLEAN
20	net_term_days	INTEGER
21	custom_fields	VARCHAR
22	is_location_valid	BOOLEAN
23	taxability	VARCHAR
24	offline_payment_method	VARCHAR
25	billing_date_mode	VARCHAR
26	fraud_flag	VARCHAR
27	phone	VARCHAR
28	parent_account_access	VARCHAR
29	refundable_credits	INTEGER
30	customer_type	VARCHAR
31	created_at	INTEGER
32	locale	VARCHAR
33	resource_version	INTEGER
34	client_profile_id	VARCHAR
35	balances	VARCHAR
36	auto_collection	VARCHAR
37	updated_at	INTEGER	Incremental sync key
38	use_default_hierarchy_settings	BOOLEAN
39	company	VARCHAR
40	vat_number_status	VARCHAR
41	relationship	VARCHAR
42	first_name	VARCHAR
43	email	VARCHAR
44	vat_number_validated_time	INTEGER
45	billing_day_of_week	VARCHAR
46	child_account_access	VARCHAR
47	excess_payments	INTEGER
48	exemption_details	VARCHAR
49	promotional_credits	INTEGER
50	last_name	VARCHAR
51	unbilled_charges	INTEGER
52	billing_date	INTEGER
53	card_status	VARCHAR
54	deleted	BOOLEAN
55	business_customer_without_vat_number	BOOLEAN
56	primary_payment_source_id	VARCHAR
57	contacts	VARCHAR

Table: order

No	Column Name	Type	Notes
1	cancelled_at	INTEGER
2	invoice_round_off_amount	INTEGER
3	amount_paid	INTEGER
4	fulfillment_status	VARCHAR
5	reference_id	VARCHAR
6	paid_on	INTEGER
7	status_update_at	INTEGER
8	discount	INTEGER
9	billing_address	VARCHAR
10	refundable_credits_issued	INTEGER
11	subscription_id	VARCHAR
12	invoice_id	VARCHAR
13	id	VARCHAR	Primary Key
14	order_type	VARCHAR
15	gift_note	VARCHAR
16	shipped_at	INTEGER
17	document_number	VARCHAR
18	custom_fields	VARCHAR
19	gift_id	VARCHAR
20	tax	INTEGER
21	linked_credit_notes	VARCHAR
22	cancellation_reason	VARCHAR
23	created_by	VARCHAR
24	shipment_carrier	VARCHAR
25	resent_status	VARCHAR
26	amount_adjusted	INTEGER
27	price_type	VARCHAR
28	resent_orders	VARCHAR
29	refundable_credits	INTEGER
30	status	VARCHAR
31	note	VARCHAR
32	shipping_date	INTEGER
33	batch_id	VARCHAR
34	order_line_items	VARCHAR
35	created_at	INTEGER
36	resource_version	INTEGER
37	currency_code	VARCHAR
38	line_item_discounts	VARCHAR
39	total	INTEGER
40	rounding_adjustement	INTEGER
41	updated_at	INTEGER	Incremental sync key
42	shipping_address	VARCHAR
43	tracking_url	VARCHAR
44	delivered_at	INTEGER
45	tracking_id	VARCHAR
46	original_order_id	VARCHAR
47	shipping_cut_off_date	INTEGER
48	payment_status	VARCHAR
49	is_gifted	BOOLEAN
50	line_item_taxes	VARCHAR
51	order_date	INTEGER
52	deleted	BOOLEAN
53	is_resent	BOOLEAN
54	sub_total	INTEGER
55	customer_id	VARCHAR
56	resend_reason	VARCHAR

External Resources

• Chargebee Api Key
• Product Catalog Version
• Subscriptions
• Customers
• Invoices
• Orders
• Plans
• Addons
• Items
• Item Prices
• Attached Items
• Chargebee Api

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.