Chargebee

Chargebee ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	v2
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Chargebee API Key Site Name on ChargeBee
Replication Type	Key Based Replication
Replication Key	Date
Suggested Replication Frequency	24 hrs

Tables/APIs Supported
Customers	Subscription

Pre-requisites

1. Generate Chargebee API Key for Daton

2. Read more on How to create Chargebee API Keys here

Integrate ChargeBee with Daton

1. Signin to Daton

2. Select ChargeBee from Integrations page

3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide API Key and Site Name to authorize Daton to periodically extract data from ChargeBee

5. Post successful authentication, you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

ChargeBee Data

Customers

Purpose: Retrieve details of a customer subscriptions, card and billing address.

Source API Documentation https://apidocs.chargebee.com/docs/api/customers

Replication: Key-Based Replication

Replication Key: createdAt

Fields

Name	Target Datatype
id	STRING
email	STRING
auto_collection	STRING
net_term_days	INTEGER
allow_direct_debit	BOOLEAN
created_at	INTEGER
taxability	STRING
updated_at	INTEGER
pii_cleared	STRING
resource_version	NUMERIC
vatNumberStatus	STRING
deleted	BOOLEAN
object	STRING
card_status	STRING
contacts	RECORD

Subscription

Purpose: Retrieve details of subcription and billing close date or payment due date

Source API Documentation https://apidocs.chargebee.com/docs/api/subscriptions

Replication: Key-Based Replication

Replication Key: createdAt

Fields

Name	Target Datatype
id	STRING
customer_id	STRING
plan_id	STRING
plan_quantity	NUMERIC
plan_unit_price	NUMERIC
plan_amount	NUMERIC
billing_period	INTEGER
billing_period_unit	STRING
plan_free_quantity	INTEGER
status	STRING
trial_start	NUMERIC
trial_end	NUMERIC
next_billing_at	NUMERIC
created_at	NUMERIC
started_at	NUMERIC
updated_at	NUMERIC
has_scheduled_changes	BOOLEAN
resource_version	NUMERIC
deleted	BOOLEAN
currency_code	STRING
object	STRING
due_invoices_count	NUMERIC