Chargify

Tables in the Chargify connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	subscriptions	50		Full Refresh		API Reference
2	customers	27		Full Refresh		API Reference

Table: subscriptions

No	Column Name	Type	Notes
1	next_assessment_at	VARCHAR
2	trial_ended_at	VARCHAR
3	canceled_at	VARCHAR
4	payment_collection_method	VARCHAR
5	current_billing_amount_in_cents	INTEGER
6	reference	VARCHAR
7	cancellation_message	VARCHAR
8	cancel_at_end_of_period	BOOLEAN
9	total_revenue_in_cents	INTEGER
10	next_product_price_point_id	INTEGER
11	id	INTEGER
12	state	VARCHAR
13	group	VARCHAR
14	bank_account	VARCHAR
15	product_price_point_id	INTEGER
16	coupon_uses_allowed	INTEGER
17	signup_payment_id	INTEGER
18	activated_at	VARCHAR
19	cancellation_method	VARCHAR
20	coupon_use_count	INTEGER
21	on_hold_at	VARCHAR
22	payment_type	VARCHAR
23	product_version_number	INTEGER
24	trial_started_at	VARCHAR
25	next_product_id	INTEGER
26	payer_id	INTEGER
27	created_at	VARCHAR
28	signup_revenue	VARCHAR
29	current_period_ends_at	VARCHAR
30	current_period_started_at	VARCHAR
31	reason_code	VARCHAR
32	expires_at	VARCHAR
33	updated_at	VARCHAR
34	snap_day	VARCHAR
35	net_terms	INTEGER
36	product	VARCHAR
37	previous_state	VARCHAR
38	coupon_code	VARCHAR
39	stored_credential_transaction_id	INTEGER
40	automatically_resume_at	VARCHAR
41	product_price_in_cents	INTEGER
42	balance_in_cents	INTEGER
43	next_product_handle	VARCHAR
44	offer_id	VARCHAR
45	credit_card	VARCHAR
46	referral_code	VARCHAR
47	prepaid_dunning	BOOLEAN
48	coupon_codes	VARCHAR
49	delayed_cancel_at	VARCHAR
50	customer	VARCHAR

Table: customers

No	Column Name	Type	Notes
1	country	VARCHAR
2	city	VARCHAR
3	vat_number	VARCHAR
4	address_2	VARCHAR
5	created_at	VARCHAR
6	locale	VARCHAR
7	reference	VARCHAR
8	portal_customer_created_at	VARCHAR
9	updated_at	VARCHAR
10	cc_emails	VARCHAR
11	state_name	VARCHAR
12	portal_invite_last_sent_at	VARCHAR
13	country_name	VARCHAR
14	state	VARCHAR
15	id	INTEGER
16	first_name	VARCHAR
17	email	VARCHAR
18	zip	VARCHAR
19	default_subscription_group_uid	VARCHAR
20	address	VARCHAR
21	tax_exempt	BOOLEAN
22	verified	VARCHAR
23	last_name	VARCHAR
24	portal_invite_last_accepted_at	VARCHAR
25	phone	VARCHAR
26	parent_id	INTEGER
27	organization	VARCHAR

External Resources

• Chargify Documentation For Generating An Api Key

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.