Export resource represents an export job and contains the status of the job and the download URL, if the job is successfully completed.
Export operations are asynchronous and will return "Export" resource in response . The export resource will contain the status of the export job (like in-process, completed...) . If the status is completed, it will contain the download url pointing to the zip/pdf containing the exported data.
Note: At any given point, only 5 export jobs can be processed. Beyond that, an error stating that the API request limit has been reached will be returned.
{
"created_at": 1527791400,
"id": "__test__KyVnHhSBWTF7H8v",
"mime_type": "zip",
"object": "export",
"operation_type": "Deferred Revenue Report",
"status": "failed"
}Returns the download_url for the export. The download URL is valid upto a specific date.
This API gets the status of the export job initiated by the Exports API. If the export job is completed, the downloads resource will also be obtained in the API response. The returned URL in the downloads resource is secure and can be downloaded. The URL expires after 4 hours. Please note that this is a public URL, and can be downloaded by anyone with whom it's shared.
Note: In case the export is in Failed or In-process state, then the downloads resource will not be available.
Important: This report is deprecated. Therefore, the endpoint is also deprecated.
This API triggers export for the revenue recognition report.
Note: This API call is asynchronous. You need to check if this operation has completed by checking if the export status is completed . You can do this by retrieving the export in a loop with a minimum delay of 10 secs between two retrieve requests. In case you are using any of the client libraries, use the wait for export completion function provided as an instance method in the library.
Value must be in ISO 4217 format. Generates the report based on the value specified. If no currency_code value is specified, then consolidated report based on base currency is returned.
optional, string filter
Payment owner of an invoice. Supported operators : is, is_not, starts_with, in, not_in
Example → payment_owner[is] = "payment_customer"
optional, string filter
The plan item price code. Supported operators : is, is_not, starts_with, in, not_in
Example → item_price_id[is] = "silver-USD-monthly"
optional, string filter
Reason code for canceling the subscription. Must be one from a list of reason codes set in the Chargebee app in Settings > Configure Chargebee > Reason Codes > Subscriptions > Subscription Cancellation. Must be passed if set as mandatory in the app. The codes are case-sensitive. Supported operators : is, is_not, starts_with, in, not_in
Example → cancel_reason_code[is] = "Not Paid"
optional, string filter
The unique ID of the business entity of this subscription. This is always the same as the business entity of the customer.
Supported operators : is, is_not, starts_with
Example → business_entity_id[is_not] = "business_entity_id"
Parameters for invoice
Invoiced amount displayed in cents; that is, a decimal point is not present between the whole number and the decimal part. For example, $499.99 is displayed as 49999, and so on.
Payments collected successfully for the invoice. This is the sum of linked_payments[].txn_amount
for all linked_payments[]
that have txn_status
as success.
The unpaid amount that is due on the invoice. This is calculated as: total
amount_paid
applied_credits.applied_amountadjustment_credit_notes.cn_totallinked_taxes_withheld.amount.To filter based on updated_at.
This attribute will be present only if the resource has been updated after 2016-09-28. It is advisable when using this filter, to pass the sort_by
input parameter as updated_at
for a faster response.
Parameters for subscription
The reason for canceling the subscription. Set by Chargebee automatically.
Possible values are : not_paid, no_card, fraud_review_failed, non_compliant_eu_customer, tax_calculation_failed, currency_incompatible_with_gateway, non_compliant_customerTime at which the subscription status
last changed to
active.
For example, this value is updated when an in_trial
or
cancelled
subscription activates.
The date/time at which the next billing for the subscription happens. This is usually right after current_term_end
unless multiple subscription terms were invoiced in advance using the terms_to_charge
parameter.
To filter based on updated_at.
This attribute will be present only if the resource has been updated after 2016-09-28. It is advisable when using this filter, to pass the sort_by
input parameter as updated_at
for a faster response.
The preferred offline payment method for the subscription.
Possible values are : no_preference, cash, check, bank_transfer, ach_credit, sepa_credit, boleto, us_automated_bank_transfer, eu_automated_bank_transfer, uk_automated_bank_transfer, jp_automated_bank_transfer, mx_automated_bank_transfer, customSet to false
to override for this subscription, the site-level setting
for auto-closing invoices. Only applicable when auto-closing invoices has been enabled for the site. This attribute has a higher precedence than the same attribute at the customer level
.
Parameters for customer
To filter based on updated_at.
This attribute will be present only if the resource has been updated after 2016-09-28. It is advisable when using this filter, to pass the sort_by
input parameter as updated_at
for a faster response.
The preferred offline payment method for the customer.
Possible values are : no_preference, cash, check, bank_transfer, ach_credit, sepa_credit, boleto, us_automated_bank_transfer, eu_automated_bank_transfer, uk_automated_bank_transfer, jp_automated_bank_transfer, mx_automated_bank_transfer, customOverride for this customer, the site-level setting for auto-closing invoices. Only applicable when auto-closing invoices has been enabled for the site. This attribute is also available at the subscription level which takes precedence.
Possible values are : true, falseParameters for relationship
Important: This report is deprecated. Therefore, the endpoint is also deprecated.
This API triggers export for the Deferred Revenue Report.
Note: This API call is asynchronous. You need to check if this operation has completed by checking if the export status is completed . You can do this by retrieving the export in a loop with a minimum delay of 10 secs between two retrieve requests. In case you are using any of the client libraries, use the wait for export completion function provided as an instance method in the library.
optional, string filter
Payment owner of an invoice. Supported operators : is, is_not, starts_with, in, not_in
Example → payment_owner[is] = "payment_customer"
optional, string filter
The plan item price code. Supported operators : is, is_not, starts_with, in, not_in
Example → item_price_id[is] = "silver-USD-monthly"
optional, string filter
Reason code for canceling the subscription. Must be one from a list of reason codes set in the Chargebee app in Settings > Configure Chargebee > Reason Codes > Subscriptions > Subscription Cancellation. Must be passed if set as mandatory in the app. The codes are case-sensitive. Supported operators : is, is_not, starts_with, in, not_in
Example → cancel_reason_code[is] = "Not Paid"
optional, string filter
The unique ID of the business entity of this subscription. This is always the same as the business entity of the customer.
Supported operators : is, is_not, starts_with
Example → business_entity_id[is_not] = "business_entity_id"
Parameters for invoice
Invoiced amount displayed in cents; that is, a decimal point is not present between the whole number and the decimal part. For example, $499.99 is displayed as 49999, and so on.
Payments collected successfully for the invoice. This is the sum of linked_payments[].txn_amount
for all linked_payments[]
that have txn_status
as success.
The unpaid amount that is due on the invoice. This is calculated as: total
amount_paid
applied_credits.applied_amountadjustment_credit_notes.cn_totallinked_taxes_withheld.amount.To filter based on updated_at.
This attribute will be present only if the resource has been updated after 2016-09-28. It is advisable when using this filter, to pass the sort_by
input parameter as updated_at
for a faster response.
Parameters for subscription
The reason for canceling the subscription. Set by Chargebee automatically.
Possible values are : not_paid, no_card, fraud_review_failed, non_compliant_eu_customer, tax_calculation_failed, currency_incompatible_with_gateway, non_compliant_customerTime at which the subscription status
last changed to
active.
For example, this value is updated when an in_trial
or
cancelled
subscription activates.
The date/time at which the next billing for the subscription happens. This is usually right after current_term_end
unless multiple subscription terms were invoiced in advance using the terms_to_charge
parameter.
To filter based on updated_at.
This attribute will be present only if the resource has been updated after 2016-09-28. It is advisable when using this filter, to pass the sort_by
input parameter as updated_at
for a faster response.
The preferred offline payment method for the subscription.
Possible values are : no_preference, cash, check, bank_transfer, ach_credit, sepa_credit, boleto, us_automated_bank_transfer, eu_automated_bank_transfer, uk_automated_bank_transfer, jp_automated_bank_transfer, mx_automated_bank_transfer, customSet to false
to override for this subscription, the site-level setting
for auto-closing invoices. Only applicable when auto-closing invoices has been enabled for the site. This attribute has a higher precedence than the same attribute at the customer level
.
Parameters for customer
To filter based on updated_at.
This attribute will be present only if the resource has been updated after 2016-09-28. It is advisable when using this filter, to pass the sort_by
input parameter as updated_at
for a faster response.
The preferred offline payment method for the customer.
Possible values are : no_preference, cash, check, bank_transfer, ach_credit, sepa_credit, boleto, us_automated_bank_transfer, eu_automated_bank_transfer, uk_automated_bank_transfer, jp_automated_bank_transfer, mx_automated_bank_transfer, customOverride for this customer, the site-level setting for auto-closing invoices. Only applicable when auto-closing invoices has been enabled for the site. This attribute is also available at the subscription level which takes precedence.
Possible values are : true, falseParameters for relationship
This API triggers export of coupon data. The exported zip file contains CSV files with coupon-related data.
optional, string filter
The currency code (ISO 4217 format ) of the coupon. Applicable for fixed_amount coupons alone. Supported operators : is, is_not, starts_with, in, not_in
Example → currency_code[is] = "USD"
Parameters for coupon
Used to uniquely identify the coupon in your website/application and to integrate with Chargebee.
Note:
When the coupon ID contains a special character; for example: #, the API returns an error. Make sure that you encode the coupon ID in the path parameter before making an API call.
The display name used in web interface for identifying the coupon.
Note:
When the name of the coupon set contains a special character; for example: #, the API returns an error. Make sure that you encode the name of the coupon set in the path parameter before making an API call.
This API triggers export of customer data. The exported zip file contains CSV files with customer-related data.
optional, string filter
The unique ID of the business entity of this subscription. This is always the same as the business entity of the customer.
Supported operators : is, is_not, starts_with
Example → business_entity_id[is] = "business_entity_id"
Parameters for customer
To filter based on updated_at.
This attribute will be present only if the resource has been updated after 2016-09-28. It is advisable when using this filter, to pass the sort_by
input parameter as updated_at
for a faster response.
The preferred offline payment method for the customer.
Possible values are : no_preference, cash, check, bank_transfer, ach_credit, sepa_credit, boleto, us_automated_bank_transfer, eu_automated_bank_transfer, uk_automated_bank_transfer, jp_automated_bank_transfer, mx_automated_bank_transfer, customOverride for this customer, the site-level setting for auto-closing invoices. Only applicable when auto-closing invoices has been enabled for the site. This attribute is also available at the subscription level which takes precedence.
Possible values are : true, falseParameters for relationship
This API triggers export of subscription data. The exported zip file contains CSV files with subscription-related data.
optional, string filter
The plan item price code. Supported operators : is, is_not, starts_with, in, not_in
Example → item_price_id[is] = "silver-USD-monthly"
optional, string filter
Reason code for canceling the subscription. Must be one from a list of reason codes set in the Chargebee app in Settings > Configure Chargebee > Reason Codes > Subscriptions > Subscription Cancellation. Must be passed if set as mandatory in the app. The codes are case-sensitive. Supported operators : is, is_not, starts_with, in, not_in
Example → cancel_reason_code[is] = "Not Paid"
Parameters for subscription
The reason for canceling the subscription. Set by Chargebee automatically.
Possible values are : not_paid, no_card, fraud_review_failed, non_compliant_eu_customer, tax_calculation_failed, currency_incompatible_with_gateway, non_compliant_customerTime at which the subscription status
last changed to
active.
For example, this value is updated when an in_trial
or
cancelled
subscription activates.
The date/time at which the next billing for the subscription happens. This is usually right after current_term_end
unless multiple subscription terms were invoiced in advance using the terms_to_charge
parameter.
To filter based on updated_at.
This attribute will be present only if the resource has been updated after 2016-09-28. It is advisable when using this filter, to pass the sort_by
input parameter as updated_at
for a faster response.
The preferred offline payment method for the subscription.
Possible values are : no_preference, cash, check, bank_transfer, ach_credit, sepa_credit, boleto, us_automated_bank_transfer, eu_automated_bank_transfer, uk_automated_bank_transfer, jp_automated_bank_transfer, mx_automated_bank_transfer, customSet to false
to override for this subscription, the site-level setting
for auto-closing invoices. Only applicable when auto-closing invoices has been enabled for the site. This attribute has a higher precedence than the same attribute at the customer level
.
This API triggers export of invoice data. The exported zip file contains CSV files with invoice-related data.
For a full export, Chargebee recommends exporting data in batches by using date filters. The table below provides examples of how to set the filters:
| Scenario | Filter Example | Description |
|---|---|---|
| Export invoices updated after January 1, 2024 | invoice[updated_at][after] = "1704067200" | Export invoices from January 1, 2024 onwards. |
| Export invoices for 2023 | invoice[updated_at][between] = "[1672531200,1704067199]" | Export all invoices for the year 2023. |
| Export invoices for 2022 | invoice[updated_at][between] = "[1640995200,1672531199]" | Export all invoices for the year 2022. |
If the export still fails, further reduce the date range, for example:
| Scenario | Filter Example | Description |
|---|---|---|
| Export for the second half of 2024 | invoice[updated_at][after] = "1717200000" | Export invoices are updated after June 1, 2024. |
| Export for the first half of 2024 | invoice[updated_at][between] = "[1704067200,1717199999]" | Export invoices updated between January 1, 2024, and May 31, 2024. |
| Export for the second half of 2023 | invoice[updated_at][between] = "[1685577600,1704067199]" | Export invoices updated between June 1, 2023, and December 31, 2023. |
| Export for the first half of 2023 | invoice[updated_at][between] = "[1672531200,1685577599]" | Export invoices updated between January 1, 2023, and May 31, 2023. |
Note
The date ranges in the examples above are just suggestions; you can adjust the date window to fit your specific needs. If an export fails due to large data volume, reduce the date window further and retry the export.
optional, string filter
Payment owner of an invoice. Supported operators : is, is_not, starts_with, in, not_in
Example → payment_owner[is] = "payment_customer"
Parameters for invoice
Invoiced amount displayed in cents; that is, a decimal point is not present between the whole number and the decimal part. For example, $499.99 is displayed as 49999, and so on.
Payments collected successfully for the invoice. This is the sum of linked_payments[].txn_amount
for all linked_payments[]
that have txn_status
as success.
The unpaid amount that is due on the invoice. This is calculated as: total
amount_paid
applied_credits.applied_amountadjustment_credit_notes.cn_totallinked_taxes_withheld.amount.To filter based on updated_at.
This attribute will be present only if the resource has been updated after 2016-09-28. It is advisable when using this filter, to pass the sort_by
input parameter as updated_at
for a faster response. Learn more about the best practice before performing full export.
This API triggers export of credit note data. The exported zip file contains CSV files with credit note-related data.
Parameters for credit_note
The credit note type. Learn more about credit note types.
Possible values are : adjustment, refundable, storeThe reason for issuing this Credit Note. The following reason codes are supported now[Deprecated; use the create_reason_code parameter instead]
Possible values are : write_off, subscription_change, subscription_cancellation, subscription_pause, chargeback, product_unsatisfactory, service_unsatisfactory, order_change, order_cancellation, waiver, other, fraudulentReason code for creating the credit note. Must be one from a list of reason codes set in the Chargebee app in Settings > Configure Chargebee > Reason Codes > Credit Notes > Create Credit Note. Must be passed if set as mandatory in the app. The codes are case-sensitive
This API triggers export of transaction data. The exported zip file contains CSV files with transaction-related data.
Parameters for transaction
The payment method of this transaction
Possible values are : card, cash, check, chargeback, bank_transfer, amazon_payments, paypal_express_checkout, direct_debit, alipay, unionpay, apple_pay, wechat_pay, ach_credit, sepa_credit, ideal, google_pay, sofort, bancontact, giropay, dotpay, other, upi, netbanking_emandates, custom, boleto, venmo, pay_to, faster_payments, sepa_instant_transfer, automated_bank_transfer, klarna_pay_now, online_banking_poland, payconiq_by_bancontactGateway through which this transaction was done. Applicable only for 'Card' Payment Method
Possible values are : chargebee, chargebee_payments, adyen, stripe, wepay, braintree, authorize_net, paypal_pro, pin, eway, eway_rapid, worldpay, balanced_payments, beanstream, bluepay, elavon, first_data_global, hdfc, migs, nmi, ogone, paymill, paypal_payflow_pro, sage_pay, tco, wirecard, amazon_payments, paypal_express_checkout, gocardless, orbital, moneris_us, moneris, bluesnap, cybersource, vantiv, checkout_com, paypal, ingenico_direct, exact, mollie, quickbooks, razorpay, global_payments, bank_of_america, ecentric, metrics_global, windcave, pay_com, ebanx, dlocal, nuvei, solidgate, paystack, jp_morgan, deutsche_bank, ezidebit, not_applicableThe reference number for this transaction. For example, the check number when payment_method
= check
.
To filter based on updated_at.
This attribute will be present only if the resource has been updated after 2016-09-28. It is advisable when using this filter, to pass the sort_by
input parameter as updated_at
for a faster response.
This API triggers export of order data. The exported zip file contains CSV files with order-related data.
Parameters for order
The status of this order.
Possible values are : new, processing, complete, cancelled, voided, queued, awaiting_shipment, on_hold, delivered, shipped, partially_delivered, returnedThis API triggers export of item family data. The exported zip file contains CSV files with item family-related data.
optional, string filter
The unique ID of the
business entity
of this item_family.
Learn more
about all the scenarios before using this filter.
Supported operators : is, is_present
Example → business_entity_id[is_present] = "true"
optional, boolean filter
Default value is true . To exclude site-level resources in specific cases, set this parameter to false.
Possible values are : true, false
Supported operators : is
Example → include_site_level_resources[is] = "null"
Possible values are : true, falseParameters for item_family
This API triggers export of item data. The exported zip file contains CSV files with item-related data.
optional, string filter
The unique ID of the
business entity
of this item.
Learn more
about all the scenarios before using this filter.
Supported operators : is, is_present
Example → business_entity_id[is_present] = "true"
optional, boolean filter
Default value is true . To exclude site-level resources in specific cases, set this parameter to false.
Possible values are : true, false
Supported operators : is
Example → include_site_level_resources[is] = "null"
Possible values are : true, falseParameters for item
Allow the plan to subscribed to via Checkout. Applies only for plan-items. Note: Only the in-app version of Checkout is supported for Product Catalog v2.
Possible values are : true, falseAllow customers to change their subscription to this plan via the Self-Serve Portal. Applies only for plan-items. This requires the Portal configuration to allow changing subscriptions .
Possible values are : true, falseSpecifies whether the item undergoes metered billing. When true
, the quantity is calculated from usage records.
When false
, the quantity
is as determined while adding an item price to the subscription. Applicable only for items of type
plan
or addon
and when Metered Billing
is enabled. The value of this attribute cannot be changed.
How the quantity is calculated from usage data for the item prices belonging to this item. Only applicable when the item is metered.
This value overrides the one set at the site level
.
This API triggers export of item price data. The exported zip file contains CSV files with item price-related data.
optional, string filter
Filter item prices based on item_family_id
.
Supported operators :
is, is_not, starts_with, in, not_in
Example → item_family_id[is] = "Acme"
optional, enumerated string filter
Filter item prices based on item_type.
Possible values are : plan, addon, charge.
Supported operators : is, is_not, in, not_in
Example → item_type[is_not] = "plan"
Possible values are : plan, addon, chargeoptional, string filter
Filter item prices based on their currency_code
.
Supported operators :
is, is_not, starts_with, in, not_in
Example → currency_code[is] = "USD"
optional, string filter
The unique ID of the
business entity
of this item_price.
Learn more
about all the scenarios before using this filter.
Supported operators : is, is_present
Example → business_entity_id[is_present] = "true"
optional, boolean filter
Default value is true . To exclude site-level resources in specific cases, set this parameter to false.
Possible values are : true, false
Supported operators : is
Example → include_site_level_resources[is] = "null"
Possible values are : true, falseParameters for item_price
Filter item prices based on their id .
Filter item prices based on their price_variant_id
.
This API triggers export of attached item data. The exported zip file contains CSV files with attached item-related data.
optional, enumerated string filter
To filter based on the type of of the attached item. Possible values are : addon
, charge.
Possible values are : plan, addon, charge.
Supported operators : is, is_not, in, not_in
Example → item_type[is_not] = "plan"
Possible values are : plan, addon, chargeParameters for attached_item
Filter attached items based on the type
of attached item. Possible values are : recommended
, mandatory
, optional
.
Indicates when the item is charged. This attribute only applies to charge-items.
Possible values are : subscription_creation, subscription_trial_start, plan_activation, subscription_activation, contract_termination, on_demandThis API triggers export of differential price data. The exported zip file contains CSV files with differential price-related data.
optional, string filter
Item Id of Addon / Charge item price for which differential pricing is applied to. Supported operators : is, is_not, starts_with, in, not_in
Example → item_id[is] = "day-pass"
Parameters for differential_price
The id of the item price (addon
or charge
) whose price should change according to the plan-item it is applied to.
A unique and immutable id for the differential price. It is auto-generated when the differential price is created.
The id of the plan-item, in relation to which, the differential pricing for the addon or charge is defined. For example, this would be the id of the Standard or Enterprise plans-items mentioned in the examples above .
This API triggers export of price variant data. The exported zip file contains CSV files with price variant-related data.
optional, string filter
The unique ID of the
business entity
of this price_variant.
Learn more
about all the scenarios before using this filter.
Supported operators : is, is_present
Example → business_entity_id[is_present] = "true"
optional, boolean filter
Default value is true . To exclude site-level resources in specific cases, set this parameter to false.
Possible values are : true, false
Supported operators : is
Example → include_site_level_resources[is] = "null"
Possible values are : true, falseParameters for price_variant
Filter variant based on their id .