Paystack

Prerequisites

• Secret Key
• Start Day
• Lookback Window

Tables in the Paystack connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	settlements	14		Full Refresh, Incremental		API Reference
2	subscriptions	20		Full Refresh, Incremental		API Reference
3	invoices	21		Full Refresh, Incremental		API Reference
4	transfers	12		Full Refresh, Incremental		API Reference
5	customers	12		Full Refresh, Incremental		API Reference
6	transactions	26		Full Refresh, Incremental		API Reference
7	disputes	21		Full Refresh, Incremental		API Reference
8	refunds	16		Full Refresh, Incremental		API Reference

Table: settlements

No	Column Name	Type	Notes
1	settlement_date	VARCHAR
2	subaccount	VARCHAR
3	total_fees	INTEGER
4	deductions	INTEGER
5	createdAt	VARCHAR
6	total_processed	INTEGER
7	total_amount	INTEGER
8	domain	VARCHAR
9	integration	INTEGER
10	effective_amount	INTEGER
11	id	INTEGER
12	settled_by	VARCHAR
13	status	VARCHAR
14	updatedAt	VARCHAR

Table: subscriptions

No	Column Name	Type	Notes
1	amount	INTEGER
2	quantity	INTEGER
3	payments_count	INTEGER
4	open_invoice	VARCHAR
5	split_code	VARCHAR
6	start	INTEGER
7	email_token	VARCHAR
8	next_payment_date	VARCHAR
9	subscription_code	VARCHAR
10	authorization	VARCHAR
11	createdAt	VARCHAR
12	cron_expression	VARCHAR
13	domain	VARCHAR
14	integration	INTEGER
15	invoice_limit	INTEGER
16	id	INTEGER
17	plan	VARCHAR
18	status	VARCHAR
19	customer	VARCHAR
20	most_recent_invoice	VARCHAR

Table: invoices

No	Column Name	Type	Notes
1	amount	INTEGER
2	metadata	VARCHAR
3	offline_reference	VARCHAR
4	due_date	VARCHAR
5	has_invoice	BOOLEAN
6	description	VARCHAR
7	created_at	VARCHAR
8	pdf_url	VARCHAR
9	tax	VARCHAR
10	line_items	VARCHAR
11	paid_at	VARCHAR
12	domain	VARCHAR
13	integration	INTEGER
14	paid	BOOLEAN
15	currency	VARCHAR
16	id	INTEGER
17	request_code	VARCHAR
18	invoice_number	INTEGER
19	notifications	VARCHAR
20	status	VARCHAR
21	customer	VARCHAR

Table: transfers

No	Column Name	Type	Notes
1	reason	VARCHAR
2	createdAt	VARCHAR
3	amount	INTEGER
4	domain	VARCHAR
5	integration	INTEGER
6	recipient	VARCHAR
7	currency	VARCHAR
8	source	VARCHAR
9	id	INTEGER
10	transfer_code	VARCHAR
11	status	VARCHAR
12	updatedAt	VARCHAR

Table: customers

No	Column Name	Type	Notes
1	createdAt	VARCHAR
2	metadata	VARCHAR
3	risk_action	VARCHAR
4	phone	VARCHAR
5	domain	VARCHAR
6	integration	INTEGER
7	last_name	VARCHAR
8	id	INTEGER
9	first_name	VARCHAR
10	customer_code	VARCHAR
11	email	VARCHAR
12	updatedAt	VARCHAR

Table: transactions

No	Column Name	Type	Notes
1	metadata	VARCHAR
2	fees	INTEGER
3	log	VARCHAR
4	channel	VARCHAR
5	created_at	VARCHAR
6	source	VARCHAR
7	gateway_response	VARCHAR
8	requested_amount	INTEGER
9	reference	VARCHAR
10	authorization	VARCHAR
11	createdAt	VARCHAR
12	split	VARCHAR
13	currency	VARCHAR
14	id	INTEGER
15	plan	VARCHAR
16	amount	INTEGER
17	fees_split	VARCHAR
18	subaccount	VARCHAR
19	ip_address	VARCHAR
20	message	VARCHAR
21	paid_at	VARCHAR
22	domain	VARCHAR
23	paidAt	VARCHAR
24	order_id	INTEGER
25	status	VARCHAR
26	customer	VARCHAR

Table: disputes

No	Column Name	Type	Notes
1	last4	VARCHAR
2	note	VARCHAR
3	resolvedAt	VARCHAR
4	attachments	VARCHAR
5	evidence	VARCHAR
6	bin	VARCHAR
7	history	VARCHAR
8	resolution	VARCHAR
9	dueAt	VARCHAR
10	createdAt	VARCHAR
11	domain	VARCHAR
12	refund_amount	INTEGER
13	messages	VARCHAR
14	currency	VARCHAR
15	id	INTEGER
16	transaction_reference	VARCHAR
17	category	VARCHAR
18	transaction	VARCHAR
19	status	VARCHAR
20	customer	VARCHAR
21	updatedAt	VARCHAR

Table: refunds

No	Column Name	Type	Notes
1	dispute	VARCHAR
2	amount	INTEGER
3	merchant_note	VARCHAR
4	customer_note	VARCHAR
5	settlement	VARCHAR
6	fully_deducted	BOOLEAN
7	refunded_by	VARCHAR
8	createdAt	VARCHAR
9	refunded_at	VARCHAR
10	domain	VARCHAR
11	integration	INTEGER
12	deducted_amount	INTEGER
13	currency	VARCHAR
14	id	INTEGER
15	transaction	INTEGER
16	status	VARCHAR

External Resources

• Here
• Paystack Api
• Jsonschema

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.