The Paystack source supports both Full Refresh and Incremental syncs. You can choose if this connector will copy only the new or updated data, or all rows in the tables and columns you set up for replication, every time a sync is run.
This Source is capable of syncing the following core streams:
The Paystack API does not allow querying objects which were updated since the last sync. Therefore, this connector uses the createdAt field to query for new data in your Paystack account.
If your data is updated after creation, you can use the Loockback Window option when configuring the connector to always reload data from the past N days. This will allow you to pick up updates to the data.
Data type mapping
The Paystack API is compatible with the JSONSchema types that Airbyte uses internally (string, date-time, object, array, boolean, integer, and number), so no type conversions happen as part of this source.
Full Refresh Sync
Incremental - Append Sync
Incremental - Dedupe Sync
The Paystack connector should not run into Paystack API limitations under normal usage. Please create an issue if you see any rate limit issues that are not automatically retried successfully.
Paystack API Secret Key
Visit the Paystack dashboard settings page with developer level access or more to see the secret key for your account. Secret keys for the live Paystack environment will be prefixed with sk_live_.
Unfortunately Paystack does not yet support restricted permission levels on secret keys. This means that you will have to use the same secret key here that you use for charging customers. Use at your own risk. In the future Paystack might support restricted access levels and in that case Airbyte only requires a read-only access level key.
If you would like to test Airbyte using test data on Paystack, sk_test_ API keys are also supported.