Braintree Connector Reference

26 metrics155 dimensions

Fields

The Braintree connector exposes 181 fields (26 metrics, 155 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Braintree Fields

Braintree customer_stream fields

The customer_stream report of the Braintree connector includes 23 fields.

ID	Type	Name	Description
customer_stream__addresses	OBJECT	customer_stream.addresses	customer_stream.addresses
customer_stream__android_pay_cards	OBJECT	customer_stream.android_pay_cards	customer_stream.android_pay_cards
customer_stream__apple_pay_cards	OBJECT	customer_stream.apple_pay_cards	customer_stream.apple_pay_cards
customer_stream__company	TEXT	customer_stream.company	customer_stream.company
customer_stream__created_at	TEXT	customer_stream.created_at	customer_stream.created_at
customer_stream__credit_cards	OBJECT	customer_stream.credit_cards	customer_stream.credit_cards
customer_stream__custom_fields	TEXT	customer_stream.custom_fields	customer_stream.custom_fields
customer_stream__email	TEXT	customer_stream.email	customer_stream.email
customer_stream__fax	TEXT	customer_stream.fax	customer_stream.fax
customer_stream__first_name	TEXT	customer_stream.first_name	customer_stream.first_name
customer_stream__graphql_id	TEXT	customer_stream.graphql_id	customer_stream.graphql_id
customer_stream__id	TEXT	customer_stream.id	customer_stream.id
customer_stream__last_name	TEXT	customer_stream.last_name	customer_stream.last_name
customer_stream__masterpass_cards	OBJECT	customer_stream.masterpass_cards	customer_stream.masterpass_cards
customer_stream__payment_methods	OBJECT	customer_stream.payment_methods	customer_stream.payment_methods
customer_stream__paypal_accounts	OBJECT	customer_stream.paypal_accounts	customer_stream.paypal_accounts
customer_stream__phone	TEXT	customer_stream.phone	customer_stream.phone
customer_stream__samsung_pay_cards	OBJECT	customer_stream.samsung_pay_cards	customer_stream.samsung_pay_cards
customer_stream__updated_at	TEXT	customer_stream.updated_at	customer_stream.updated_at
customer_stream__us_bank_accounts	OBJECT	customer_stream.us_bank_accounts	customer_stream.us_bank_accounts
customer_stream__venmo_accounts	OBJECT	customer_stream.venmo_accounts	customer_stream.venmo_accounts
customer_stream__visa_checkout_cards	OBJECT	customer_stream.visa_checkout_cards	customer_stream.visa_checkout_cards
customer_stream__website	TEXT	customer_stream.website	customer_stream.website

Braintree discount_stream fields

The discount_stream report of the Braintree connector includes 9 fields.

ID	Type	Name	Description
discount_stream__amount	NUMERIC	discount_stream.amount	discount_stream.amount
discount_stream__current_billing_cycle	NUMERIC	discount_stream.current_billing_cycle	discount_stream.current_billing_cycle
discount_stream__description	TEXT	discount_stream.description	discount_stream.description
discount_stream__id	TEXT	discount_stream.id	discount_stream.id
discount_stream__kind	TEXT	discount_stream.kind	discount_stream.kind
discount_stream__name	TEXT	discount_stream.name	discount_stream.name
discount_stream__never_expires	BOOLEAN	discount_stream.never_expires	discount_stream.never_expires
discount_stream__number_of_billing_cycles	NUMERIC	discount_stream.number_of_billing_cycles	discount_stream.number_of_billing_cycles
discount_stream__quantity	NUMERIC	discount_stream.quantity	discount_stream.quantity

Braintree dispute_stream fields

The dispute_stream report of the Braintree connector includes 22 fields.

ID	Type	Name	Description
dispute_stream__amount_disputed	NUMERIC	dispute_stream.amount_disputed	dispute_stream.amount_disputed
dispute_stream__amount_won	NUMERIC	dispute_stream.amount_won	dispute_stream.amount_won
dispute_stream__case_number	TEXT	dispute_stream.case_number	dispute_stream.case_number
dispute_stream__chargeback_protection_level	TEXT	dispute_stream.chargeback_protection_level	dispute_stream.chargeback_protection_level
dispute_stream__created_at	TEXT	dispute_stream.created_at	dispute_stream.created_at
dispute_stream__currency_iso_code	TEXT	dispute_stream.currency_iso_code	dispute_stream.currency_iso_code
dispute_stream__evidence	TEXT	dispute_stream.evidence	dispute_stream.evidence
dispute_stream__graphql_id	TEXT	dispute_stream.graphql_id	dispute_stream.graphql_id
dispute_stream__id	TEXT	dispute_stream.id	dispute_stream.id
dispute_stream__kind	TEXT	dispute_stream.kind	dispute_stream.kind
dispute_stream__merchant_account_id	TEXT	dispute_stream.merchant_account_id	dispute_stream.merchant_account_id
dispute_stream__original_dispute_id	TEXT	dispute_stream.original_dispute_id	dispute_stream.original_dispute_id
dispute_stream__paypal_messages	OBJECT	dispute_stream.paypal_messages	dispute_stream.paypal_messages
dispute_stream__processor_comments	TEXT	dispute_stream.processor_comments	dispute_stream.processor_comments
dispute_stream__reason	TEXT	dispute_stream.reason	dispute_stream.reason
dispute_stream__reason_code	TEXT	dispute_stream.reason_code	dispute_stream.reason_code
dispute_stream__reason_description	TEXT	dispute_stream.reason_description	dispute_stream.reason_description
dispute_stream__received_date	DATE	dispute_stream.received_date	dispute_stream.received_date
dispute_stream__reference_number	TEXT	dispute_stream.reference_number	dispute_stream.reference_number
dispute_stream__reply_by_date	TEXT	dispute_stream.reply_by_date	dispute_stream.reply_by_date
dispute_stream__status	TEXT	dispute_stream.status	dispute_stream.status
dispute_stream__updated_at	TEXT	dispute_stream.updated_at	dispute_stream.updated_at

Braintree merchant_account_stream fields

The merchant_account_stream report of the Braintree connector includes 6 fields.

ID	Type	Name	Description
merchant_account_stream__business_details	TEXT	merchant_account_stream.business_details	merchant_account_stream.business_details
merchant_account_stream__currency_iso_code	TEXT	merchant_account_stream.currency_iso_code	merchant_account_stream.currency_iso_code
merchant_account_stream__funding_details	TEXT	merchant_account_stream.funding_details	merchant_account_stream.funding_details
merchant_account_stream__id	TEXT	merchant_account_stream.id	merchant_account_stream.id
merchant_account_stream__individual_details	TEXT	merchant_account_stream.individual_details	merchant_account_stream.individual_details
merchant_account_stream__status	TEXT	merchant_account_stream.status	merchant_account_stream.status

Braintree plan_stream fields

The plan_stream report of the Braintree connector includes 15 fields.

ID	Type	Name	Description
plan_stream__add_ons	OBJECT	plan_stream.add_ons	plan_stream.add_ons
plan_stream__billing_day_of_month	NUMERIC	plan_stream.billing_day_of_month	plan_stream.billing_day_of_month
plan_stream__billing_frequency	NUMERIC	plan_stream.billing_frequency	plan_stream.billing_frequency
plan_stream__created_at	TEXT	plan_stream.created_at	plan_stream.created_at
plan_stream__currency_iso_code	TEXT	plan_stream.currency_iso_code	plan_stream.currency_iso_code
plan_stream__description	TEXT	plan_stream.description	plan_stream.description
plan_stream__discounts	OBJECT	plan_stream.discounts	plan_stream.discounts
plan_stream__id	TEXT	plan_stream.id	plan_stream.id
plan_stream__name	TEXT	plan_stream.name	plan_stream.name
plan_stream__number_of_billing_cycles	NUMERIC	plan_stream.number_of_billing_cycles	plan_stream.number_of_billing_cycles
plan_stream__price	NUMERIC	plan_stream.price	plan_stream.price
plan_stream__trial_duration	NUMERIC	plan_stream.trial_duration	plan_stream.trial_duration
plan_stream__trial_duration_unit	TEXT	plan_stream.trial_duration_unit	plan_stream.trial_duration_unit
plan_stream__trial_period	BOOLEAN	plan_stream.trial_period	plan_stream.trial_period
plan_stream__updated_at	TEXT	plan_stream.updated_at	plan_stream.updated_at

Braintree subscription_stream fields

The subscription_stream report of the Braintree connector includes 28 fields.

Braintree transaction_stream fields

The transaction_stream report of the Braintree connector includes 73 fields.

Braintree transaction_stream fields (transaction_stream__acquirer_reference_number to transaction_stream__plan_id)

Braintree transaction_stream fields (transaction_stream__processed_with_network_token to transaction_stream__voice_referral_number)

Braintree other fields

The Braintree 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

ID	Type	Name	Description
subscription_stream__add_ons	OBJECT	subscription_stream.add_ons	subscription_stream.add_ons
subscription_stream__balance	NUMERIC	subscription_stream.balance	subscription_stream.balance
subscription_stream__billing_day_of_month	NUMERIC	subscription_stream.billing_day_of_month	subscription_stream.billing_day_of_month
subscription_stream__billing_period_start_date	DATE	subscription_stream.billing_period_start_date	subscription_stream.billing_period_start_date
subscription_stream__created_at	TEXT	subscription_stream.created_at	subscription_stream.created_at
subscription_stream__current_billing_cycle	NUMERIC	subscription_stream.current_billing_cycle	subscription_stream.current_billing_cycle
subscription_stream__days_past_due	NUMERIC	subscription_stream.days_past_due	subscription_stream.days_past_due
subscription_stream__description	TEXT	subscription_stream.description	subscription_stream.description
subscription_stream__discounts	OBJECT	subscription_stream.discounts	subscription_stream.discounts
subscription_stream__failure_count	NUMERIC	subscription_stream.failure_count	subscription_stream.failure_count
subscription_stream__first_billing_date	DATE	subscription_stream.first_billing_date	subscription_stream.first_billing_date
subscription_stream__id	TEXT	subscription_stream.id	subscription_stream.id
subscription_stream__merchant_account_id	TEXT	subscription_stream.merchant_account_id	subscription_stream.merchant_account_id
subscription_stream__never_expires	BOOLEAN	subscription_stream.never_expires	subscription_stream.never_expires
subscription_stream__next_bill_amount	NUMERIC	subscription_stream.next_bill_amount	subscription_stream.next_bill_amount
subscription_stream__next_billing_date	DATE	subscription_stream.next_billing_date	subscription_stream.next_billing_date
subscription_stream__next_billing_period_amount	NUMERIC	subscription_stream.next_billing_period_amount	subscription_stream.next_billing_period_amount
subscription_stream__number_of_billing_cycles	NUMERIC	subscription_stream.number_of_billing_cycles	subscription_stream.number_of_billing_cycles
subscription_stream__paid_through_date	DATE	subscription_stream.paid_through_date	subscription_stream.paid_through_date
subscription_stream__payment_method_token	TEXT	subscription_stream.payment_method_token	subscription_stream.payment_method_token
subscription_stream__plan_id	TEXT	subscription_stream.plan_id	subscription_stream.plan_id
subscription_stream__price	NUMERIC	subscription_stream.price	subscription_stream.price
subscription_stream__status	TEXT	subscription_stream.status	subscription_stream.status
subscription_stream__transactions	OBJECT	subscription_stream.transactions	subscription_stream.transactions
subscription_stream__trial_duration	NUMERIC	subscription_stream.trial_duration	subscription_stream.trial_duration
subscription_stream__trial_duration_unit	TEXT	subscription_stream.trial_duration_unit	subscription_stream.trial_duration_unit
subscription_stream__trial_period	BOOLEAN	subscription_stream.trial_period	subscription_stream.trial_period
subscription_stream__updated_at	TEXT	subscription_stream.updated_at	subscription_stream.updated_at

ID	Type	Name	Description
transaction_stream__acquirer_reference_number	TEXT	transaction_stream.acquirer_reference_number	transaction_stream.acquirer_reference_number
transaction_stream__additional_processor_response	TEXT	transaction_stream.additional_processor_response	transaction_stream.additional_processor_response
transaction_stream__amount	TEXT	transaction_stream.amount	transaction_stream.amount
transaction_stream__android_pay_card_details	TEXT	transaction_stream.android_pay_card_details	transaction_stream.android_pay_card_details
transaction_stream__apple_pay_details	TEXT	transaction_stream.apple_pay_details	transaction_stream.apple_pay_details
transaction_stream__authorization_expires_at	TEXT	transaction_stream.authorization_expires_at	transaction_stream.authorization_expires_at
transaction_stream__avs_error_response_code	TEXT	transaction_stream.avs_error_response_code	transaction_stream.avs_error_response_code
transaction_stream__avs_postal_code_response_code	TEXT	transaction_stream.avs_postal_code_response_code	transaction_stream.avs_postal_code_response_code
transaction_stream__avs_street_address_response_code	TEXT	transaction_stream.avs_street_address_response_code	transaction_stream.avs_street_address_response_code
transaction_stream__billing_details	TEXT	transaction_stream.billing_details	transaction_stream.billing_details
transaction_stream__channel	TEXT	transaction_stream.channel	transaction_stream.channel
transaction_stream__created_at	TEXT	transaction_stream.created_at	transaction_stream.created_at
transaction_stream__credit_card_details	TEXT	transaction_stream.credit_card_details	transaction_stream.credit_card_details
transaction_stream__currency_iso_code	TEXT	transaction_stream.currency_iso_code	transaction_stream.currency_iso_code
transaction_stream__custom_fields	OBJECT	transaction_stream.custom_fields	transaction_stream.custom_fields
transaction_stream__customer_details	TEXT	transaction_stream.customer_details	transaction_stream.customer_details
transaction_stream__cvv_response_code	TEXT	transaction_stream.cvv_response_code	transaction_stream.cvv_response_code
transaction_stream__disbursement_details	TEXT	transaction_stream.disbursement_details	transaction_stream.disbursement_details
transaction_stream__discount_amount	NUMERIC	transaction_stream.discount_amount	transaction_stream.discount_amount
transaction_stream__discounts	OBJECT	transaction_stream.discounts	transaction_stream.discounts
transaction_stream__disputes	OBJECT	transaction_stream.disputes	transaction_stream.disputes
transaction_stream__escrow_status	TEXT	transaction_stream.escrow_status	transaction_stream.escrow_status
transaction_stream__gateway_rejection_reason	TEXT	transaction_stream.gateway_rejection_reason	transaction_stream.gateway_rejection_reason
transaction_stream__global_id	TEXT	transaction_stream.global_id	transaction_stream.global_id
transaction_stream__graphql_id	TEXT	transaction_stream.graphql_id	transaction_stream.graphql_id
transaction_stream__id	TEXT	transaction_stream.id	transaction_stream.id
transaction_stream__installment_count	NUMERIC	transaction_stream.installment_count	transaction_stream.installment_count
transaction_stream__masterpass_card_details	TEXT	transaction_stream.masterpass_card_details	transaction_stream.masterpass_card_details
transaction_stream__merchant_account_id	TEXT	transaction_stream.merchant_account_id	transaction_stream.merchant_account_id
transaction_stream__merchant_address	TEXT	transaction_stream.merchant_address	transaction_stream.merchant_address
transaction_stream__merchant_identification_number	TEXT	transaction_stream.merchant_identification_number	transaction_stream.merchant_identification_number
transaction_stream__merchant_name	TEXT	transaction_stream.merchant_name	transaction_stream.merchant_name
transaction_stream__network_response_code	TEXT	transaction_stream.network_response_code	transaction_stream.network_response_code
transaction_stream__network_response_text	TEXT	transaction_stream.network_response_text	transaction_stream.network_response_text
transaction_stream__network_transaction_id	TEXT	transaction_stream.network_transaction_id	transaction_stream.network_transaction_id
transaction_stream__order_id	TEXT	transaction_stream.order_id	transaction_stream.order_id
transaction_stream__payment_instrument_type	TEXT	transaction_stream.payment_instrument_type	transaction_stream.payment_instrument_type
transaction_stream__paypal_details	TEXT	transaction_stream.paypal_details	transaction_stream.paypal_details
transaction_stream__pin_verified	BOOLEAN	transaction_stream.pin_verified	transaction_stream.pin_verified
transaction_stream__plan_id	TEXT	transaction_stream.plan_id	transaction_stream.plan_id

ID	Type	Name	Description
transaction_stream__processed_with_network_token	BOOLEAN	transaction_stream.processed_with_network_token	transaction_stream.processed_with_network_token
transaction_stream__processor_authorization_code	TEXT	transaction_stream.processor_authorization_code	transaction_stream.processor_authorization_code
transaction_stream__processor_response_code	TEXT	transaction_stream.processor_response_code	transaction_stream.processor_response_code
transaction_stream__processor_response_text	TEXT	transaction_stream.processor_response_text	transaction_stream.processor_response_text
transaction_stream__processor_response_type	TEXT	transaction_stream.processor_response_type	transaction_stream.processor_response_type
transaction_stream__processor_settlement_response_code	TEXT	transaction_stream.processor_settlement_response_code	transaction_stream.processor_settlement_response_code
transaction_stream__processor_settlement_response_text	TEXT	transaction_stream.processor_settlement_response_text	transaction_stream.processor_settlement_response_text
transaction_stream__purchase_order_number	TEXT	transaction_stream.purchase_order_number	transaction_stream.purchase_order_number
transaction_stream__recurring	BOOLEAN	transaction_stream.recurring	transaction_stream.recurring
transaction_stream__refund_global_ids	OBJECT	transaction_stream.refund_global_ids	transaction_stream.refund_global_ids
transaction_stream__refund_ids	OBJECT	transaction_stream.refund_ids	transaction_stream.refund_ids
transaction_stream__refunded_transaction_id	TEXT	transaction_stream.refunded_transaction_id	transaction_stream.refunded_transaction_id
transaction_stream__response_emv_data	TEXT	transaction_stream.response_emv_data	transaction_stream.response_emv_data
transaction_stream__retrieval_reference_number	TEXT	transaction_stream.retrieval_reference_number	transaction_stream.retrieval_reference_number
transaction_stream__samsung_pay_card_details	TEXT	transaction_stream.samsung_pay_card_details	transaction_stream.samsung_pay_card_details
transaction_stream__sca_exemption_requested	TEXT	transaction_stream.sca_exemption_requested	transaction_stream.sca_exemption_requested
transaction_stream__service_fee_amount	NUMERIC	transaction_stream.service_fee_amount	transaction_stream.service_fee_amount
transaction_stream__settlement_batch_id	TEXT	transaction_stream.settlement_batch_id	transaction_stream.settlement_batch_id
transaction_stream__shipping_amount	NUMERIC	transaction_stream.shipping_amount	transaction_stream.shipping_amount
transaction_stream__shipping_details	TEXT	transaction_stream.shipping_details	transaction_stream.shipping_details
transaction_stream__ships_from_postal_code	TEXT	transaction_stream.ships_from_postal_code	transaction_stream.ships_from_postal_code
transaction_stream__status	TEXT	transaction_stream.status	transaction_stream.status
transaction_stream__status_history	OBJECT	transaction_stream.status_history	transaction_stream.status_history
transaction_stream__subscription_details	TEXT	transaction_stream.subscription_details	transaction_stream.subscription_details
transaction_stream__subscription_id	TEXT	transaction_stream.subscription_id	transaction_stream.subscription_id
transaction_stream__tax_amount	NUMERIC	transaction_stream.tax_amount	transaction_stream.tax_amount
transaction_stream__tax_exempt	BOOLEAN	transaction_stream.tax_exempt	transaction_stream.tax_exempt
transaction_stream__terminal_identification_number	TEXT	transaction_stream.terminal_identification_number	transaction_stream.terminal_identification_number
transaction_stream__type	TEXT	transaction_stream.type	transaction_stream.type
transaction_stream__updated_at	TEXT	transaction_stream.updated_at	transaction_stream.updated_at
transaction_stream__venmo_account_details	TEXT	transaction_stream.venmo_account_details	transaction_stream.venmo_account_details
transaction_stream__visa_checkout_card_details	TEXT	transaction_stream.visa_checkout_card_details	transaction_stream.visa_checkout_card_details
transaction_stream__voice_referral_number	TEXT	transaction_stream.voice_referral_number	transaction_stream.voice_referral_number

API Connectors