Chargify Connector Reference

44 metrics136 dimensions

Fields

The Chargify connector exposes 180 fields (44 metrics, 136 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Chargify Fields

Chargify coupons fields

The coupons report of the Chargify connector includes 29 fields.

ID	Type	Name	Description
coupons__allow_negative_balance	BOOLEAN	coupons.allow_negative_balance	coupons.allow_negative_balance
coupons__amount	NUMERIC	coupons.amount	coupons.amount
coupons__amount_in_cents	NUMERIC	coupons.amount_in_cents	coupons.amount_in_cents
coupons__apply_on_cancel_at_end_of_period	BOOLEAN	coupons.apply_on_cancel_at_end_of_period	coupons.apply_on_cancel_at_end_of_period
coupons__archived_at	TIMESTAMP	coupons.archived_at	coupons.archived_at
coupons__code	TEXT	coupons.code	coupons.code
coupons__compounding_strategy	TEXT	coupons.compounding_strategy	coupons.compounding_strategy
coupons__conversion_limit	TEXT	coupons.conversion_limit	coupons.conversion_limit
coupons__coupon_restrictions	OBJECT	coupons.coupon_restrictions	coupons.coupon_restrictions
coupons__created_at	TIMESTAMP	coupons.created_at	coupons.created_at
coupons__description	TEXT	coupons.description	coupons.description
coupons__discount_type	TEXT	coupons.discount_type	coupons.discount_type
coupons__duration_interval	NUMERIC	coupons.duration_interval	coupons.duration_interval
coupons__duration_interval_span	TEXT	coupons.duration_interval_span	coupons.duration_interval_span
coupons__duration_interval_unit	TEXT	coupons.duration_interval_unit	coupons.duration_interval_unit
coupons__duration_period_count	NUMERIC	coupons.duration_period_count	coupons.duration_period_count
coupons__end_date	TEXT	coupons.end_date	coupons.end_date
coupons__exclude_mid_period_allocations	BOOLEAN	coupons.exclude_mid_period_allocations	coupons.exclude_mid_period_allocations
coupons__id	TEXT	coupons.id	coupons.id
coupons__name	TEXT	coupons.name	coupons.name
coupons__percentage	NUMERIC	coupons.percentage	coupons.percentage
coupons__product_family_id	NUMERIC	coupons.product_family_id	coupons.product_family_id
coupons__product_family_name	TEXT	coupons.product_family_name	coupons.product_family_name
coupons__recurring	BOOLEAN	coupons.recurring	coupons.recurring
coupons__recurring_scheme	TEXT	coupons.recurring_scheme	coupons.recurring_scheme
coupons__stackable	BOOLEAN	coupons.stackable	coupons.stackable
coupons__start_date	TEXT	coupons.start_date	coupons.start_date
coupons__updated_at	TIMESTAMP	coupons.updated_at	coupons.updated_at
coupons__use_site_exchange_rate	BOOLEAN	coupons.use_site_exchange_rate	coupons.use_site_exchange_rate

Chargify customers fields

The customers report of the Chargify connector includes 27 fields.

ID	Type	Name	Description
customers__address	TEXT	customers.address	customers.address
customers__address_2	TEXT	customers.address_2	customers.address_2
customers__cc_emails	TEXT	customers.cc_emails	customers.cc_emails
customers__city	CITY	customers.city	customers.city
customers__country	TEXT	customers.country	customers.country
customers__country_name	COUNTRY	customers.country_name	customers.country_name
customers__created_at	TIMESTAMP	customers.created_at	customers.created_at
customers__default_subscription_group_uid	TEXT	customers.default_subscription_group_uid	customers.default_subscription_group_uid
customers__email	TEXT	customers.email	customers.email
customers__first_name	TEXT	customers.first_name	customers.first_name
customers__id	TEXT	customers.id	customers.id
customers__last_name	TEXT	customers.last_name	customers.last_name
customers__locale	TEXT	customers.locale	customers.locale
customers__organization	TEXT	customers.organization	customers.organization
customers__parent_id	NUMERIC	customers.parent_id	customers.parent_id
customers__phone	TEXT	customers.phone	customers.phone
customers__portal_customer_created_at	TIMESTAMP	customers.portal_customer_created_at	customers.portal_customer_created_at
customers__portal_invite_last_accepted_at	TIMESTAMP	customers.portal_invite_last_accepted_at	customers.portal_invite_last_accepted_at
customers__portal_invite_last_sent_at	TIMESTAMP	customers.portal_invite_last_sent_at	customers.portal_invite_last_sent_at
customers__reference	TEXT	customers.reference	customers.reference
customers__state	TEXT	customers.state	customers.state
customers__state_name	TEXT	customers.state_name	customers.state_name
customers__tax_exempt	BOOLEAN	customers.tax_exempt	customers.tax_exempt
customers__updated_at	TIMESTAMP	customers.updated_at	customers.updated_at
customers__vat_number	TEXT	customers.vat_number	customers.vat_number
customers__verified	TEXT	customers.verified	customers.verified
customers__zip	TEXT	customers.zip	customers.zip

Chargify invoices fields

The invoices report of the Chargify connector includes 32 fields.

ID	Type	Name	Description
invoices__billing_address	OBJECT	invoices.billing_address	invoices.billing_address
invoices__collection_method	TEXT	invoices.collection_method	invoices.collection_method
invoices__consolidation_level	TEXT	invoices.consolidation_level	invoices.consolidation_level
invoices__credit_amount	TEXT	invoices.credit_amount	invoices.credit_amount
invoices__currency	TEXT	invoices.currency	invoices.currency
invoices__customer	OBJECT	invoices.customer	invoices.customer
invoices__customer_id	NUMERIC	invoices.customer_id	invoices.customer_id
invoices__discount_amount	TEXT	invoices.discount_amount	invoices.discount_amount
invoices__due_amount	TEXT	invoices.due_amount	invoices.due_amount
invoices__due_date	TEXT	invoices.due_date	invoices.due_date
invoices__group_primary_subscription_id	NUMERIC	invoices.group_primary_subscription_id	invoices.group_primary_subscription_id
invoices__issue_date	TEXT	invoices.issue_date	invoices.issue_date
invoices__memo	TEXT	invoices.memo	invoices.memo
invoices__number	TEXT	invoices.number	invoices.number
invoices__paid_amount	TEXT	invoices.paid_amount	invoices.paid_amount
invoices__paid_date	TEXT	invoices.paid_date	invoices.paid_date
invoices__parent_invoice_number	NUMERIC	invoices.parent_invoice_number	invoices.parent_invoice_number
invoices__parent_invoice_uid	NUMERIC	invoices.parent_invoice_uid	invoices.parent_invoice_uid
invoices__payment_instructions	TEXT	invoices.payment_instructions	invoices.payment_instructions
invoices__product_family_name	TEXT	invoices.product_family_name	invoices.product_family_name
invoices__product_name	TEXT	invoices.product_name	invoices.product_name
invoices__refund_amount	TEXT	invoices.refund_amount	invoices.refund_amount
invoices__seller	OBJECT	invoices.seller	invoices.seller
invoices__sequence_number	NUMERIC	invoices.sequence_number	invoices.sequence_number
invoices__shipping_address	OBJECT	invoices.shipping_address	invoices.shipping_address
invoices__site_id	NUMERIC	invoices.site_id	invoices.site_id
invoices__status	TEXT	invoices.status	invoices.status
invoices__subscription_id	NUMERIC	invoices.subscription_id	invoices.subscription_id
invoices__subtotal_amount	TEXT	invoices.subtotal_amount	invoices.subtotal_amount
invoices__tax_amount	TEXT	invoices.tax_amount	invoices.tax_amount
invoices__total_amount	TEXT	invoices.total_amount	invoices.total_amount
invoices__uid	TEXT	invoices.uid	invoices.uid

Chargify subscriptions fields

The subscriptions report of the Chargify connector includes 60 fields.

Chargify subscriptions fields (subscriptions__activated_at to subscriptions__prepayment_balance_in_cents)

ID	Type	Name	Description
subscriptions__activated_at	TIMESTAMP	subscriptions.activated_at	subscriptions.activated_at
subscriptions__automatically_resume_at	TIMESTAMP	subscriptions.automatically_resume_at	subscriptions.automatically_resume_at
subscriptions__balance_in_cents	NUMERIC	subscriptions.balance_in_cents	subscriptions.balance_in_cents
subscriptions__bank_account	OBJECT	subscriptions.bank_account	subscriptions.bank_account
subscriptions__cancel_at_end_of_period	BOOLEAN	subscriptions.cancel_at_end_of_period	subscriptions.cancel_at_end_of_period
subscriptions__canceled_at	TIMESTAMP	subscriptions.canceled_at	subscriptions.canceled_at
subscriptions__cancellation_message	TEXT	subscriptions.cancellation_message	subscriptions.cancellation_message
subscriptions__cancellation_method	TEXT	subscriptions.cancellation_method	subscriptions.cancellation_method
subscriptions__coupon_code	TEXT	subscriptions.coupon_code	subscriptions.coupon_code
subscriptions__coupon_codes	OBJECT	subscriptions.coupon_codes	subscriptions.coupon_codes
subscriptions__coupon_use_count	NUMERIC	subscriptions.coupon_use_count	subscriptions.coupon_use_count
subscriptions__coupon_uses_allowed	NUMERIC	subscriptions.coupon_uses_allowed	subscriptions.coupon_uses_allowed
subscriptions__coupons	OBJECT	subscriptions.coupons	subscriptions.coupons
subscriptions__created_at	TIMESTAMP	subscriptions.created_at	subscriptions.created_at
subscriptions__credit_balance_in_cents	NUMERIC	subscriptions.credit_balance_in_cents	subscriptions.credit_balance_in_cents
subscriptions__credit_card	OBJECT	subscriptions.credit_card	subscriptions.credit_card
subscriptions__currency	TEXT	subscriptions.currency	subscriptions.currency
subscriptions__current_billing_amount_in_cents	NUMERIC	subscriptions.current_billing_amount_in_cents	subscriptions.current_billing_amount_in_cents
subscriptions__current_period_ends_at	TIMESTAMP	subscriptions.current_period_ends_at	subscriptions.current_period_ends_at
subscriptions__current_period_started_at	TIMESTAMP	subscriptions.current_period_started_at	subscriptions.current_period_started_at
subscriptions__customer	OBJECT	subscriptions.customer	subscriptions.customer
subscriptions__delayed_cancel_at	TIMESTAMP	subscriptions.delayed_cancel_at	subscriptions.delayed_cancel_at
subscriptions__dunning_communication_delay_enabled	BOOLEAN	subscriptions.dunning_communication_delay_enabled	subscriptions.dunning_communication_delay_enabled
subscriptions__dunning_communication_delay_time_zone	TEXT	subscriptions.dunning_communication_delay_time_zone	subscriptions.dunning_communication_delay_time_zone
subscriptions__expires_at	TIMESTAMP	subscriptions.expires_at	subscriptions.expires_at
subscriptions__group	OBJECT	subscriptions.group	subscriptions.group
subscriptions__id	TEXT	subscriptions.id	subscriptions.id
subscriptions__locale	TEXT	subscriptions.locale	subscriptions.locale
subscriptions__net_terms	NUMERIC	subscriptions.net_terms	subscriptions.net_terms
subscriptions__next_assessment_at	TIMESTAMP	subscriptions.next_assessment_at	subscriptions.next_assessment_at
subscriptions__next_product_handle	TEXT	subscriptions.next_product_handle	subscriptions.next_product_handle
subscriptions__next_product_id	NUMERIC	subscriptions.next_product_id	subscriptions.next_product_id
subscriptions__next_product_price_point_id	NUMERIC	subscriptions.next_product_price_point_id	subscriptions.next_product_price_point_id
subscriptions__offer_id	NUMERIC	subscriptions.offer_id	subscriptions.offer_id
subscriptions__on_hold_at	TIMESTAMP	subscriptions.on_hold_at	subscriptions.on_hold_at
subscriptions__payer_id	NUMERIC	subscriptions.payer_id	subscriptions.payer_id
subscriptions__payment_collection_method	TEXT	subscriptions.payment_collection_method	subscriptions.payment_collection_method
subscriptions__payment_type	TEXT	subscriptions.payment_type	subscriptions.payment_type
subscriptions__prepaid_dunning	BOOLEAN	subscriptions.prepaid_dunning	subscriptions.prepaid_dunning
subscriptions__prepayment_balance_in_cents	NUMERIC	subscriptions.prepayment_balance_in_cents	subscriptions.prepayment_balance_in_cents

Chargify subscriptions fields (subscriptions__previous_state to subscriptions__updated_at)

ID	Type	Name	Description
subscriptions__previous_state	TEXT	subscriptions.previous_state	subscriptions.previous_state
subscriptions__product	OBJECT	subscriptions.product	subscriptions.product
subscriptions__product_price_in_cents	NUMERIC	subscriptions.product_price_in_cents	subscriptions.product_price_in_cents
subscriptions__product_price_point_id	NUMERIC	subscriptions.product_price_point_id	subscriptions.product_price_point_id
subscriptions__product_price_point_type	TEXT	subscriptions.product_price_point_type	subscriptions.product_price_point_type
subscriptions__product_version_number	NUMERIC	subscriptions.product_version_number	subscriptions.product_version_number
subscriptions__reason_code	TEXT	subscriptions.reason_code	subscriptions.reason_code
subscriptions__receives_invoice_emails	BOOLEAN	subscriptions.receives_invoice_emails	subscriptions.receives_invoice_emails
subscriptions__reference	TEXT	subscriptions.reference	subscriptions.reference
subscriptions__referral_code	TEXT	subscriptions.referral_code	subscriptions.referral_code
subscriptions__scheduled_cancellation_at	TIMESTAMP	subscriptions.scheduled_cancellation_at	subscriptions.scheduled_cancellation_at
subscriptions__signup_payment_id	NUMERIC	subscriptions.signup_payment_id	subscriptions.signup_payment_id
subscriptions__signup_revenue	TEXT	subscriptions.signup_revenue	subscriptions.signup_revenue
subscriptions__snap_day	TEXT	subscriptions.snap_day	subscriptions.snap_day
subscriptions__state	TEXT	subscriptions.state	subscriptions.state
subscriptions__stored_credential_transaction_id	NUMERIC	subscriptions.stored_credential_transaction_id	subscriptions.stored_credential_transaction_id
subscriptions__total_revenue_in_cents	NUMERIC	subscriptions.total_revenue_in_cents	subscriptions.total_revenue_in_cents
subscriptions__trial_ended_at	TIMESTAMP	subscriptions.trial_ended_at	subscriptions.trial_ended_at
subscriptions__trial_started_at	TIMESTAMP	subscriptions.trial_started_at	subscriptions.trial_started_at
subscriptions__updated_at	TIMESTAMP	subscriptions.updated_at	subscriptions.updated_at

Chargify transactions fields

The transactions report of the Chargify connector includes 27 fields.

ID	Type	Name	Description
transactions__amount_in_cents	NUMERIC	transactions.amount_in_cents	transactions.amount_in_cents
transactions__card_expiration	TEXT	transactions.card_expiration	transactions.card_expiration
transactions__card_number	TEXT	transactions.card_number	transactions.card_number
transactions__card_type	TEXT	transactions.card_type	transactions.card_type
transactions__component_id	NUMERIC	transactions.component_id	transactions.component_id
transactions__created_at	TIMESTAMP	transactions.created_at	transactions.created_at
transactions__customer_id	NUMERIC	transactions.customer_id	transactions.customer_id
transactions__ending_balance_in_cents	NUMERIC	transactions.ending_balance_in_cents	transactions.ending_balance_in_cents
transactions__gateway_order_id	NUMERIC	transactions.gateway_order_id	transactions.gateway_order_id
transactions__gateway_transaction_id	TEXT	transactions.gateway_transaction_id	transactions.gateway_transaction_id
transactions__gateway_used	TEXT	transactions.gateway_used	transactions.gateway_used
transactions__id	TEXT	transactions.id	transactions.id
transactions__item_name	TEXT	transactions.item_name	transactions.item_name
transactions__kind	TEXT	transactions.kind	transactions.kind
transactions__memo	TEXT	transactions.memo	transactions.memo
transactions__parent_id	NUMERIC	transactions.parent_id	transactions.parent_id
transactions__payment_id	NUMERIC	transactions.payment_id	transactions.payment_id
transactions__product_id	NUMERIC	transactions.product_id	transactions.product_id
transactions__refunded_amount_in_cents	NUMERIC	transactions.refunded_amount_in_cents	transactions.refunded_amount_in_cents
transactions__role	TEXT	transactions.role	transactions.role
transactions__starting_balance_in_cents	NUMERIC	transactions.starting_balance_in_cents	transactions.starting_balance_in_cents
transactions__statement_id	NUMERIC	transactions.statement_id	transactions.statement_id
transactions__subscription_id	NUMERIC	transactions.subscription_id	transactions.subscription_id
transactions__success	BOOLEAN	transactions.success	transactions.success
transactions__tax_id	NUMERIC	transactions.tax_id	transactions.tax_id
transactions__transaction_type	TEXT	transactions.transaction_type	transactions.transaction_type
transactions__type	TEXT	transactions.type	transactions.type

Chargify other fields

The Chargify connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date

API Connectors