This integration is powered by Singer's Chargebee tap. For support, visit the GitHub repo or join the Singer Slack.
Chargebee is in Open Beta
Chargebee is currently in Open Beta. The info in this article is subject to change.
Chargebee integration summary
Stitch’s Chargebee integration replicates data using the Chargebee API . Refer to the Schema section for a list of objects available for replication.
Chargebee feature snapshot
A high-level look at Stitch's Chargebee integration, including release status, useful links, and the features supported in Stitch.
STITCH | |||
Release Status |
Open Beta |
Supported By | |
Stitch Plan |
Free |
Singer GitHub Repository | |
DATA SELECTION | |||
Table Selection |
Supported |
Column Selection |
Supported |
REPLICATION SETTINGS | |||
Anchor Scheduling |
Supported |
Advanced Scheduling |
Unsupported |
Table-level Reset |
Unsupported |
Configurable Replication Methods |
Unsupported |
TRANSPARENCY | |||
Extraction Logs |
Supported |
Loading Reports |
Supported |
Connecting Chargebee
Step 1: Generate an API Key
First, you’ll generate a Chargebee API Key for Stitch. This will allow Stitch to read data from your Chargebee account using the Chargebee API.
- Sign into your Chargebee account.
- In the left sidenav, click Settings > Configure Chargebee.
- Click the API keys and webhooks button.
- On the API Keys page, click the + Add API Key button. The Create an API Key modal will display.
- Select Read-Only Key as the API key type.
- Select All to define the API key’s access. This will grant read-only access to your Chargebee site.
- In the Name the API key field, enter
Stitch
. - Click Create Key.
Chargebee will create the API key and redirect you back to the API Keys page:
Copy the API key somwhere handy - you’ll need it to complete the setup in Stitch.
Step 2: Add Chargebee as a Stitch data source
- Sign into your Stitch account.
-
On the Stitch Dashboard page, click the Add Integration button.
-
Click the Chargebee icon.
-
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.
For example, the name “Stitch Chargebee” would create a schema called
stitch_chargebee
in the destination. Note: Schema names cannot be changed after you save the integration. - In the API Key field, paste the API key you generated in Step 1.
- In the Site field, enter the name of your Chargebee site. This can be found in the URL of your Chargebee site. For example: If the URL was
https://stitch.chargebee.com
, onlystitch
would be entered into this field.
Step 3: Define the historical sync
The Sync Historical Data setting will define the starting date for your Chargebee integration. This means that data equal to or newer than this date will be replicated to your data warehouse.
Change this setting if you want to replicate data beyond Chargebee’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.
Step 4: Create a replication schedule
In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.
Chargebee integrations support the following replication scheduling methods:
To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.
Step 5: Set tables and columns to replicate
To complete the setup, you’ll need to select the tables and columns you want to replicate to your data warehouse.
Check out the Schema section to learn more about the available tables in Chargebee and how they replicate.
- In the list of tables that displays - or in the Tables to Replicate tab, if you skipped this step during setup - locate a table you want to replicate.
-
To track a table, click the checkbox next to the table’s name. A green checkmark means the table is set to replicate.
-
To track a column, click the checkbox next to the column’s name. A green checkmark means the column is set to replicate.
- Repeat this process for all the tables and columns you want to replicate.
- When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
Note: If you change these settings while a replication job is still in progress, they will not be used until the next job starts.
Initial and historical replication jobs
After you finish setting up Chargebee, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.
For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.
Initial replication jobs with Anchor Scheduling
If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.
Free historical data loads
The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.
Chargebee table schemas
Table and column names in your destination
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (CusTomERs
> customers
), while case is maintained in PostgreSQL destinations (CusTomERs
> CusTomERs
). Refer to the Loading Guide for your destination for more info.
addons
Replication Method : |
Key-based Incremental |
Replication Key |
updated_at |
Primary Key |
id |
API endpoint : |
The addons
table contains info about the addons in your Chargebee account. Addons are additional charges applied to subscriptions apart from base charges.
id
The addon ID. Reference: |
|||
updated_at
The time the addon was last updated. Note: This attribute will be present only if the resource has been updated after 2016-09-28. |
|||
accounting_code
The accounting code used by the addon. |
|||
accouting_category1
The name of the category of your product in Xero. If you’ve integrated with QuickBooks, this will be the |
|||
accouting_category2
The name of the category of your product in Xero. |
|||
archived_at
The time at which the plan was moved to archived status. |
|||
charge_type
The type of charge. Possible values are:
|
|||
currency_code
The currency code (ISO 4217 format) of the addon. |
|||
description
Description about the addon to show in the hosted pages and customer portal. |
|||
enabled_in_portal
Indicates if the addon is available to customers to add in the ‘Change Subscription’ option in the customer portal. |
|||
invoice_name
The display name used in invoices. |
|||
invoice_notes
The invoice notes for the addon. |
|||
is_shippable
Indicates whether the addon can be added to orders. |
|||
meta_data
Additional info about the addon. |
|||
name
The display name used in web interface for identifying the addon. |
|||
object
|
|||
period
Applicable only for |
|||
period_unit
Applicable only for
|
|||
price
The addon price. Addon price is calculated based on the addon type and charge type. |
|||
pricing_model
Indicates how the charges for the addon are calculated. Possible values are:
|
|||
resource_version
The version number of the addon. Each update of the addon results in an incremental change of this value. Note: This attribute will be present only if the resource has been updated after 2016-09-28. |
|||
shipping_frequency_period
Defines the shipping frequency in conjunction with |
|||
shipping_frequency_period_unit
Defines the shipping frequency in conjunction with
|
|||
sku
The field is used as Product name/code in your third party accounting application. Chargebee will use it as an alternate name in your accounting application |
|||
status
The status of the addon. Possible values are:
|
|||
tax_code
The Avalara tax codes to which items are mapped to should be provided here. Applicable only if you use Chargebee’s AvaTax for Sales integration. |
|||
tax_profile_id
The tax profile of the addon. |
|||
taxable
Indicates whether the addon is taxable or not. |
|||
tiers
Applicable only if the addon uses tiered, volume, or stairstep pricing. The list of tiers for the addon.
|
|||
type
|
|||
unit
Applicable only for quantity type addons. This specifies the type of quantity. For example: If the addon price is |
coupons
Replication Method : |
Key-based Incremental |
Replication Key |
updated_at |
Primary Key |
id |
API endpoint : |
The coupons
table contains info about the coupons in your Chargebee account.
id
The coupon ID. Reference:
|
updated_at
The time the coupon was last updated. |
addon_constraint
The addons the coupon can be applied to. Possible values are:
|
apply_discount_on
|
apply_on
The invoice items for which this coupon needs to be applied. Possible values are:
|
archived_at
The time when the coupon was archived. |
created_at
The time when the coupon was created. |
discount_amount
When |
discount_percentage
When |
discount_type
The type of discount. Possible values are:
|
duration_month
When |
duration_type
The duration the coupon is applicable. Possible values are:
|
max_redemptions
The maximum number of times the coupon can be redeemed. |
name
The display name used in web interface for identifying the coupon. |
object
|
plan_constraint
The plans the coupon can be applied to. Possible values are:
|
redemptions
The number of times the coupon has been redeemed. |
resource_version
The version number of the coupon. Each update of the coupon results in an incremental change of this value. Note: This attribute will be present only if the coupon has been updated after 2016-09-28. |
status
The status of the coupon. Possible values are:
|
credit_notes
Replication Method : |
Key-based Incremental |
Replication Key |
updated_at |
Primary Key |
id |
API endpoint : |
The credit_notes
table contains info about the credit notes in your Chargebee account. A credit note is a document that specifies the money owed by a business to a customer.
id
The credit note ID. Reference: |
|||||||||||||||||
updated_at
The time the credit note was last updated. |
|||||||||||||||||
allocations
Details about invoice allocations made from the credit note.
|
|||||||||||||||||
amount_allocated
The amount allocated to invoices. |
|||||||||||||||||
amount_available
The yet to be used credits of this credit note. |
|||||||||||||||||
amount_refunded
The refunds issued from this credit note. |
|||||||||||||||||
currency_code
The currency code (ISO 4217 format) for the credit note. |
|||||||||||||||||
customer_id
The ID of the customer associated with the credit note. Reference:
|
|||||||||||||||||
date
The date the credit note was issued. |
|||||||||||||||||
deleted
Indicates whether the credit note was deleted or not. |
|||||||||||||||||
discounts
Details about the discounts applied to the credit note.
|
|||||||||||||||||
line_item_discounts
The list of discount(s) applied for each line item of the invoice.
|
|||||||||||||||||
line_item_taxes
The list of taxes applied on line items.
|
|||||||||||||||||
line_item_tiers
The list of tiers applicable for the line item.
|
|||||||||||||||||
line_items
The line items in the credit note.
|
|||||||||||||||||
linked_refunds
Details about refunds issued from the credit note.
|
|||||||||||||||||
price_type
The price type of the credit note. Possible values are:
|
|||||||||||||||||
reason_code
The reason for issuing the credit note. Possible values include:
|
|||||||||||||||||
reference_invoice_id
The ID of the invoice against which the credit note is issued. Reference: |
|||||||||||||||||
refunded_at
The time when the credit note was fully used. |
|||||||||||||||||
resource_version
The version number of the credit note. Each update of the credit note results in an incremental change of this value. Note: This attribute will be present only if the credit note has been updated after 2016-09-28. |
|||||||||||||||||
round_off_amount
The credit note rounded-off amount, in cents. |
|||||||||||||||||
status
The status of the credit note. Possible values include:
|
|||||||||||||||||
sub_total
The credit note subtotal, in cents. |
|||||||||||||||||
subscription_id
The ID of the subscription associated with the credit note. Reference: |
|||||||||||||||||
taxes
The tax lines of the credit note.
|
|||||||||||||||||
total
The total credit amount in cents. |
|||||||||||||||||
type
The credit note type. Possible values are:
|
|||||||||||||||||
vat_number
The VAT number of the customer for whom the credit note is raised. |
|||||||||||||||||
voided_at
The time when the credit note was voided. |
customers
Replication Method : |
Key-based Incremental |
Replication Key |
updated_at |
Primary Key |
id |
API endpoint : |
The customers
table contains info about the customers in your Chargebee account.
id
The customer ID. Reference:
|
||||||||||||||
updated_at
The time the customer was last updated. |
||||||||||||||
allow_direct_debit
Indicates whether the customer can pay via direct debit or not. |
||||||||||||||
auto_collection
Indicates whether payments need to be automatically collected for the customer. Possible values are:
|
||||||||||||||
balances
The list of balances for the customer.
|
||||||||||||||
billing_address
The billing address for the customer.
|
||||||||||||||
billing_date
Applicable when calendar billing (with customer specific billing date support) is enabled. When set, renewals of all the monthly and yearly subscriptions of this customer will be aligned to this date. |
||||||||||||||
billing_date_mode
Indicates whether this customer’s Possible values are:
|
||||||||||||||
billing_day_of_week
Applicable when calendar billing (with customer specific billing date support) is enabled. When set, renewals of all the weekly subscriptions of this customer will be aligned to this week day. Possible values are:
|
||||||||||||||
billing_day_of_week_mode
Indicates whether this customer’s Possible values are:
|
||||||||||||||
card_status
|
||||||||||||||
cf_company_id
|
||||||||||||||
company
The name of the company associated with the customer. |
||||||||||||||
consolidated_invoicing
Applicable when consolidated invoicing is enabled. Indicates whether invoice consolidation should happen during subscription renewals. Needs to be set only if this value is different from the defaults configured. |
||||||||||||||
contacts
A list of contacts associated with the customer.
|
||||||||||||||
created_at
The time the customer was created. |
||||||||||||||
deleted
Indicates whether the customer has been deleted or not. |
||||||||||||||
email
The customer’s email address. |
||||||||||||||
excess_payments
The total unused payments associated with the customer. |
||||||||||||||
first_name
The first name of the customer. |
||||||||||||||
invoice_notes
Invoice notes associated with the customer. |
||||||||||||||
last_name
The last name of the customer. |
||||||||||||||
locale
Determines which region-specific language Chargebee uses to communicate with the customer. |
||||||||||||||
net_term_days
The number of days within which the customer has to make payment for invoices. |
||||||||||||||
object
|
||||||||||||||
payment_method
The primary payment source for the customer.
|
||||||||||||||
phone
The customer’s phone number. |
||||||||||||||
pii_cleared
Indicates whether the customer’s personal info has been cleared. Possible values are:
|
||||||||||||||
preferred_currency_code
Applicable if the Chargebee Multicurrency feature is enabled. The currency code of the customer’s preferred currency (ISO 4217 format). |
||||||||||||||
primary_payment_source_id
The ID of the primary payment source for the customer. Reference: |
||||||||||||||
promotional_credits
The promotional credits balance of the customer. |
||||||||||||||
referral_urls
A list of referral URLs for the customer.
|
||||||||||||||
refundable_credits
The refundable credits balance of the customer. |
||||||||||||||
resource_version
The version number of the customer. Each update of the customer results in an incremental change of this value. Note: This attribute will be present only if the customer has been updated after 2016-09-28. |
||||||||||||||
taxability
Indicates if the customer is liable for tax. Possible values are:
|
||||||||||||||
unbilled_charges
The total unbilled charges for the customer. |
||||||||||||||
vat_number
The VAT number for the customer. |
events
Replication Method : |
Key-based Incremental |
Replication Key |
occurred_at |
Primary Key |
id |
API endpoint : |
The events
table contains info about the events that have occurred on your Chargebee site. Event records contain data about affected resources and additional details, such as when the change occurred. This can be used to create a log of events for a record and analyze how it has changed over time.
id
The event ID. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
occurred_at
The time the event occurred. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
api_version
The Chargebee API Version used for rendering this event content. Possible values are |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
content
The data associated with the event. The attributes in this object will vary depending on the event type. Refer to Chargebee’s documentation for a list of possible event types.
|