MSPBots WIKI : Chargebee Public Datasets
Here are the published or Alpha version Chargebee datasets that you can use to create the widgets and dashboards
In total, there are 9 publish/alpha Datasets
| Name | Description | Created Date | Last updated | Fields |
|---|---|---|---|---|
| Chargebee Customers - API | ODS Dataset which generated from Chargebee Customers | Mar 10, 2022 | Mar 10, 2022 | ["id", "tenant_code", "other_id", "sync_time", "first_name", "last_name", "email", "phone", "company", "auto_collection", "net_term_days", "allow_direct_debit", "taxability", "created_at", "updated_at", "pii_cleared", "channel", "resource_version", "deleted", "promotional_credits", "refundable_credits", "excess_payments", "unbilled_charges", "preferred_currency_code", "primary_payment_source_id", "payment_method_type", "reference_id", "gateway", "gateway_account_id"] |
| Chargebee Invoices - API | ODS Dataset which generated from Chagebee Invoices | May 15, 2022 | Aug 01, 2022 | ["id", "tenant_code", "sync_time", "other_id", "customer_id", "subscription_id", "recurring", "status", "price_type", "date", "due_date", "net_term_days", "exchange_rate", "total", "amount_paid", "amount_adjusted", "write_off_amount", "credits_applied", "amount_due", "paid_at", "updated_at", "resource_version", "deleted", "object", "first_invoice", "amount_to_collect", "round_off_amount", "new_sales_amount", "has_advance_charges", "currency_code", "base_currency_code", "generated_at", "gifted", "term_finalized", "channel", "tax", "sub_total", "billing_address_first_name", "billing_address_last_name", "billing_address_company", "billing_address_validation_status", "billing_address_object"] |
| Chargebee ItemPrices - API | ODS Dataset which generated from Chargebee ItemPrices | May 16, 2022 | May 16, 2022 | ["id", "tenant_code", "sync_time", "other_id", "name", "item_family_id", "item_id", "status", "external_name", "pricing_model", "price", "period", "currency_code", "period_unit", "trial_period", "trial_period_unit", "free_quantity", "channel", "resource_version", "created_at", "updated_at", "is_taxable", "item_type", "show_description_in_invoices", "show_description_in_quotes", "object", "tiers"] |
| Chargebee ItemFamilies - API | ODS Dataset which generated from Chargebee ItemFamilies | May 16, 2022 | May 16, 2022 | ["id", "tenant_code", "sync_time", "other_id", "name", "description", "status", "resource_version", "object", "updated_at"] |
| Chargebee Subscriptions - API | ODS Dataset which generated from Chargebee Subscriptions | Jun 14, 2022 | Jun 14, 2022 | ["id", "tenant_code", "sync_time", "other_id", "subscription_id", "subscription_billing_period", "subscription_billing_period_unit", "subscription_customer_id", "subscription_status", "subscription_current_term_start", "subscription_current_term_start_time", "subscription_current_term_end", "subscription_current_term_end_time", "subscription_next_billing_at", "subscription_next_billing_at_time", "subscription_created_at", "subscription_created_at_time", "subscription_started_at", "subscription_started_at_time", "subscription_activated_at", "subscription_activated_at_time", "subscription_created_from_ip", "subscription_updated_at", "subscription_updated_at_time", "subscription_has_scheduled_changes", "subscription_channel", "subscription_resource_version", "subscription_deleted", "subscription_object", "subscription_currency_code", "subscription_subscription_items", "subscription_item_tiers", "subscription_shipping_address_first_name", "subscription_shipping_address_last_name", "subscription_shipping_address_line1", "subscription_shipping_address_line2", "subscription_shipping_address_city", "subscription_shipping_address_state_code", "subscription_shipping_address_state", "subscription_shipping_address_country", "subscription_shipping_address_zip", "subscription_shipping_address_validation_status", "subscription_shipping_address_object", "subscription_due_invoices_count", "subscription_mrr", "subscription_exchange_rate", "subscription_base_currency_code", "customer_id", "customer_first_name", "customer_last_name", "customer_email", "customer_phone", "customer_company", "customer_auto_collection", "customer_net_term_days", "customer_allow_direct_debit", "customer_created_at", "customer_created_at_time", "customer_taxability", "customer_updated_at", "customer_updated_at_time", "customer_locale", "customer_pii_cleared", "customer_channel", "customer_resource_version", "customer_deleted", "customer_object", "customer_billing_address_first_name", "customer_billing_address_last_name", "customer_billing_address_line1", "customer_billing_address_line2", "customer_billing_address_city", "customer_billing_address_state", "customer_billing_address_country", "customer_billing_address_validation_status", "customer_billing_address_object", "customer_card_status", "customer_promotional_credits", "customer_refundable_credits", "customer_excess_payments", "customer_unbilled_charges", "customer_preferred_currency_code", "customer_primary_payment_source_id", "customer_payment_method_object", "customer_payment_method_type", "customer_payment_method_reference_id", "customer_payment_method_gateway", "customer_payment_method_gateway_account_id", "customer_payment_method_status", "card_status", "card_gateway", "card_gateway_account_id", "card_iin", "card_last4", "card_card_type", "card_funding_type", "card_expiry_month", "card_expiry_year", "card_created_at", "card_created_at_time", "card_updated_at", "card_updated_at_time", "card_ip_address", "card_resource_version", "card_object", "card_masked_number", "card_customer_id", "card_payment_source_id"] |
| Chargebee Transactions - API | ODS Dataset which generated from Chargebee Transactions | Jun 14, 2022 | Jun 14, 2022 | ["id", "tenant_code", "sync_time", "other_id", "transaction_id", "transaction_customer_id", "transaction_subscription_id", "transaction_gateway_account_id", "transaction_payment_source_id", "transaction_payment_method", "transaction_gateway", "transaction_type", "transaction_date", "transaction_date_time", "transaction_exchange_rate", "transaction_amount", "transaction_id_at_gateway", "transaction_status", "transaction_updated_at", "transaction_updated_at_time", "transaction_resource_version", "transaction_deleted", "transaction_object", "transaction_masked_card_number", "transaction_currency_code", "transaction_base_currency_code", "transaction_amount_unused", "transaction_linked_invoices", "transaction_linked_refunds", "transaction_payment_method_details"] |
| Chargebee Events - API | ODS Dataset which generated from Chargebee Events | Jun 14, 2022 | Jun 14, 2022 | ["id", "tenant_code", "sync_time", "other_id", "event_id", "event_occurred_at", "event_occurred_at_time", "event_source", "event_user", "event_object", "event_api_version", "event_content", "event_event_type", "event_webhook_status", "event_webhooks"] |
| Chargebee CreditNote - API | ODS Dataset which generated from Chargebee CreditNote | Jun 15, 2022 | Jun 15, 2022 | ["id", "tenant_code", "sync_time", "other_id", "customer_id", "subscription_id", "reference_invoice_id", "type", "reason_code", "status", "date", "price_type", "exchange_rate", "total", "amount_allocated", "amount_refunded", "amount_available", "refunded_at", "generated_at", "updated_at", "channel", "resource_version", "deleted", "object", "create_reason_code", "currency_code", "round_off_amount", "fractional_correction", "base_currency_code", "sub_total", "line_items", "taxes", "line_item_taxes", "line_item_discounts", "linked_refunds", "allocations"] |
| Chargebee Coupons | ODS Dataset which generated from Chargebee Coupons | Jan 12, 2023 | Jan 12, 2023 | ["id", "tenant_code", "sync_time", "other_id", "name", "invoice_name", "discount_type", "duration_type", "status", "apply_discount_on", "apply_on", "updated_at", "updated_at_time", "created_at", "created_at_time", "resource_version", "object", "redemptions", "currency_code", "item_constraints", "discount_percentage"] |