Recharge Connector Reference

25 metrics298 dimensions

Fields

The Recharge connector exposes 323 fields (25 metrics, 298 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Recharge Fields

Recharge addresses fields

The addresses report of the Recharge connector includes 25 fields.

ID	Type	Name	Description
addresses__address1	TEXT	addresses.address1	addresses.address1
addresses__address2	TEXT	addresses.address2	addresses.address2
addresses__cart_note	TEXT	addresses.cart_note	addresses.cart_note
addresses__city	TEXT	addresses.city	addresses.city
addresses__company	TEXT	addresses.company	addresses.company
addresses__country	TEXT	addresses.country	addresses.country
addresses__country_code	TEXT	addresses.country_code	addresses.country_code
addresses__created_at	TIMESTAMP	addresses.created_at	addresses.created_at
addresses__customer_id	TEXT	addresses.customer_id	addresses.customer_id
addresses__discount_id	TEXT	addresses.discount_id	addresses.discount_id
addresses__discounts	OBJECT	addresses.discounts	addresses.discounts
addresses__first_name	TEXT	addresses.first_name	addresses.first_name
addresses__id	TEXT	addresses.id	addresses.id
addresses__last_name	TEXT	addresses.last_name	addresses.last_name
addresses__note_attributes	OBJECT	addresses.note_attributes	addresses.note_attributes
addresses__order_attributes	OBJECT	addresses.order_attributes	addresses.order_attributes
addresses__order_note	TEXT	addresses.order_note	addresses.order_note
addresses__payment_method_id	TEXT	addresses.payment_method_id	addresses.payment_method_id
addresses__phone	TEXT	addresses.phone	addresses.phone
addresses__presentment_currency	TEXT	addresses.presentment_currency	addresses.presentment_currency
addresses__province	TEXT	addresses.province	addresses.province
addresses__shipping_lines_conserved	OBJECT	addresses.shipping_lines_conserved	addresses.shipping_lines_conserved
addresses__shipping_lines_override	OBJECT	addresses.shipping_lines_override	addresses.shipping_lines_override
addresses__updated_at	TIMESTAMP	addresses.updated_at	addresses.updated_at
addresses__zip	TEXT	addresses.zip	addresses.zip

Recharge charges fields

The charges report of the Recharge connector includes 60 fields.

Recharge charges fields (charges__address_id to charges__shipping_address)

ID	Type	Name	Description
charges__address_id	TEXT	charges.address_id	charges.address_id
charges__analytics_data	OBJECT	charges.analytics_data	charges.analytics_data
charges__billing_address	OBJECT	charges.billing_address	charges.billing_address
charges__charge_attempts	NUMERIC	charges.charge_attempts	charges.charge_attempts
charges__client_details	OBJECT	charges.client_details	charges.client_details
charges__created_at	TIMESTAMP	charges.created_at	charges.created_at
charges__currency	TEXT	charges.currency	charges.currency
charges__customer	OBJECT	charges.customer	charges.customer
charges__customer_hash	TEXT	charges.customer_hash	charges.customer_hash
charges__customer_id	TEXT	charges.customer_id	charges.customer_id
charges__discount_codes	OBJECT	charges.discount_codes	charges.discount_codes
charges__discounts	OBJECT	charges.discounts	charges.discounts
charges__email	TEXT	charges.email	charges.email
charges__error	TEXT	charges.error	charges.error
charges__error_type	TEXT	charges.error_type	charges.error_type
charges__external_order_id	OBJECT	charges.external_order_id	charges.external_order_id
charges__external_transaction_id	OBJECT	charges.external_transaction_id	charges.external_transaction_id
charges__external_variant_id_not_found	BOOLEAN	charges.external_variant_id_not_found	charges.external_variant_id_not_found
charges__external_variant_not_found	BOOLEAN	charges.external_variant_not_found	charges.external_variant_not_found
charges__first_name	TEXT	charges.first_name	charges.first_name
charges__has_uncommited_changes	BOOLEAN	charges.has_uncommited_changes	charges.has_uncommited_changes
charges__has_uncommitted_changes	BOOLEAN	charges.has_uncommitted_changes	charges.has_uncommitted_changes
charges__id	TEXT	charges.id	charges.id
charges__last_charge_attempt	TEXT	charges.last_charge_attempt	charges.last_charge_attempt
charges__last_charge_attempt_date	TEXT	charges.last_charge_attempt_date	charges.last_charge_attempt_date
charges__last_name	TEXT	charges.last_name	charges.last_name
charges__line_items	OBJECT	charges.line_items	charges.line_items
charges__merged_at	TIMESTAMP	charges.merged_at	charges.merged_at
charges__note	TEXT	charges.note	charges.note
charges__note_attributes	OBJECT	charges.note_attributes	charges.note_attributes
charges__number_times_tried	NUMERIC	charges.number_times_tried	charges.number_times_tried
charges__order_attributes	OBJECT	charges.order_attributes	charges.order_attributes
charges__orders_count	NUMERIC	charges.orders_count	charges.orders_count
charges__payment_processor	TEXT	charges.payment_processor	charges.payment_processor
charges__processed_at	TIMESTAMP	charges.processed_at	charges.processed_at
charges__processor_name	TEXT	charges.processor_name	charges.processor_name
charges__retry_date	TEXT	charges.retry_date	charges.retry_date
charges__scheduled_at	TIMESTAMP	charges.scheduled_at	charges.scheduled_at
charges__shipments_count	NUMERIC	charges.shipments_count	charges.shipments_count
charges__shipping_address	OBJECT	charges.shipping_address	charges.shipping_address

Recharge charges fields (charges__shipping_lines to charges__updated_at)

ID	Type	Name	Description
charges__shipping_lines	OBJECT	charges.shipping_lines	charges.shipping_lines
charges__shopify_order_id	TEXT	charges.shopify_order_id	charges.shopify_order_id
charges__shopify_variant_id_not_found	TEXT	charges.shopify_variant_id_not_found	charges.shopify_variant_id_not_found
charges__status	TEXT	charges.status	charges.status
charges__subtotal_price	TEXT	charges.subtotal_price	charges.subtotal_price
charges__tags	TEXT	charges.tags	charges.tags
charges__tax_lines	TEXT	charges.tax_lines	charges.tax_lines
charges__taxable	BOOLEAN	charges.taxable	charges.taxable
charges__taxes_included	BOOLEAN	charges.taxes_included	charges.taxes_included
charges__total_discounts	TEXT	charges.total_discounts	charges.total_discounts
charges__total_duties	TEXT	charges.total_duties	charges.total_duties
charges__total_line_items_price	TEXT	charges.total_line_items_price	charges.total_line_items_price
charges__total_price	TEXT	charges.total_price	charges.total_price
charges__total_refunds	TEXT	charges.total_refunds	charges.total_refunds
charges__total_tax	TEXT	charges.total_tax	charges.total_tax
charges__total_weight	NUMERIC	charges.total_weight	charges.total_weight
charges__total_weight_grams	NUMERIC	charges.total_weight_grams	charges.total_weight_grams
charges__transaction_id	TEXT	charges.transaction_id	charges.transaction_id
charges__type	TEXT	charges.type	charges.type
charges__updated_at	TIMESTAMP	charges.updated_at	charges.updated_at

Recharge collections fields

The collections report of the Recharge connector includes 8 fields.

ID	Type	Name	Description
collections__created_at	TIMESTAMP	collections.created_at	collections.created_at
collections__description	TEXT	collections.description	collections.description
collections__id	TEXT	collections.id	collections.id
collections__name	TEXT	collections.name	collections.name
collections__sort_order	TEXT	collections.sort_order	collections.sort_order
collections__title	TEXT	collections.title	collections.title
collections__type	TEXT	collections.type	collections.type
collections__updated_at	TIMESTAMP	collections.updated_at	collections.updated_at

Recharge customers fields

The customers report of the Recharge connector includes 37 fields.

ID	Type	Name	Description
customers__accepts_marketing	BOOLEAN	customers.accepts_marketing	customers.accepts_marketing
customers__analytics_data	OBJECT	customers.analytics_data	customers.analytics_data
customers__apply_credit_to_next_checkout_charge	BOOLEAN	customers.apply_credit_to_next_checkout_charge	customers.apply_credit_to_next_checkout_charge
customers__apply_credit_to_next_recurring_charge	BOOLEAN	customers.apply_credit_to_next_recurring_charge	customers.apply_credit_to_next_recurring_charge
customers__billing_address1	TEXT	customers.billing_address1	customers.billing_address1
customers__billing_address2	TEXT	customers.billing_address2	customers.billing_address2
customers__billing_city	TEXT	customers.billing_city	customers.billing_city
customers__billing_company	TEXT	customers.billing_company	customers.billing_company
customers__billing_country	TEXT	customers.billing_country	customers.billing_country
customers__billing_first_name	TEXT	customers.billing_first_name	customers.billing_first_name
customers__billing_last_name	TEXT	customers.billing_last_name	customers.billing_last_name
customers__billing_phone	TEXT	customers.billing_phone	customers.billing_phone
customers__billing_province	TEXT	customers.billing_province	customers.billing_province
customers__billing_zip	TEXT	customers.billing_zip	customers.billing_zip
customers__created_at	TIMESTAMP	customers.created_at	customers.created_at
customers__email	TEXT	customers.email	customers.email
customers__external_customer_id	OBJECT	customers.external_customer_id	customers.external_customer_id
customers__first_charge_processed_at	TIMESTAMP	customers.first_charge_processed_at	customers.first_charge_processed_at
customers__first_name	TEXT	customers.first_name	customers.first_name
customers__has_card_error_in_dunning	BOOLEAN	customers.has_card_error_in_dunning	customers.has_card_error_in_dunning
customers__has_payment_method_in_dunning	BOOLEAN	customers.has_payment_method_in_dunning	customers.has_payment_method_in_dunning
customers__has_valid_payment_method	BOOLEAN	customers.has_valid_payment_method	customers.has_valid_payment_method
customers__hash	TEXT	customers.hash	customers.hash
customers__id	TEXT	customers.id	customers.id
customers__last_name	TEXT	customers.last_name	customers.last_name
customers__number_active_subscriptions	NUMERIC	customers.number_active_subscriptions	customers.number_active_subscriptions
customers__number_subscriptions	NUMERIC	customers.number_subscriptions	customers.number_subscriptions
customers__phone	TEXT	customers.phone	customers.phone
customers__processor_type	TEXT	customers.processor_type	customers.processor_type
customers__reason_payment_method_not_valid	TEXT	customers.reason_payment_method_not_valid	customers.reason_payment_method_not_valid
customers__shopify_customer_id	TEXT	customers.shopify_customer_id	customers.shopify_customer_id
customers__status	TEXT	customers.status	customers.status
customers__stripe_customer_token	TEXT	customers.stripe_customer_token	customers.stripe_customer_token
customers__subscriptions_active_count	NUMERIC	customers.subscriptions_active_count	customers.subscriptions_active_count
customers__subscriptions_total_count	NUMERIC	customers.subscriptions_total_count	customers.subscriptions_total_count
customers__tax_exempt	BOOLEAN	customers.tax_exempt	customers.tax_exempt
customers__updated_at	TIMESTAMP	customers.updated_at	customers.updated_at

Recharge discounts fields

The discounts report of the Recharge connector includes 23 fields.

ID	Type	Name	Description
discounts__applies_to	TEXT	discounts.applies_to	discounts.applies_to
discounts__applies_to_id	TEXT	discounts.applies_to_id	discounts.applies_to_id
discounts__applies_to_product_type	TEXT	discounts.applies_to_product_type	discounts.applies_to_product_type
discounts__applies_to_resource	TEXT	discounts.applies_to_resource	discounts.applies_to_resource
discounts__channel_settings	OBJECT	discounts.channel_settings	discounts.channel_settings
discounts__code	TEXT	discounts.code	discounts.code
discounts__created_at	TIMESTAMP	discounts.created_at	discounts.created_at
discounts__discount_type	TEXT	discounts.discount_type	discounts.discount_type
discounts__duration	TEXT	discounts.duration	discounts.duration
discounts__duration_usage_limit	NUMERIC	discounts.duration_usage_limit	discounts.duration_usage_limit
discounts__ends_at	TIMESTAMP	discounts.ends_at	discounts.ends_at
discounts__external_discount_id	TEXT	discounts.external_discount_id	discounts.external_discount_id
discounts__external_discount_source	TEXT	discounts.external_discount_source	discounts.external_discount_source
discounts__first_time_customer_restriction	TEXT	discounts.first_time_customer_restriction	discounts.first_time_customer_restriction
discounts__id	TEXT	discounts.id	discounts.id
discounts__once_per_customer	BOOLEAN	discounts.once_per_customer	discounts.once_per_customer
discounts__prerequisite_subtotal_min	NUMERIC	discounts.prerequisite_subtotal_min	discounts.prerequisite_subtotal_min
discounts__starts_at	TIMESTAMP	discounts.starts_at	discounts.starts_at
discounts__status	TEXT	discounts.status	discounts.status
discounts__times_used	NUMERIC	discounts.times_used	discounts.times_used
discounts__updated_at	TIMESTAMP	discounts.updated_at	discounts.updated_at
discounts__usage_limit	NUMERIC	discounts.usage_limit	discounts.usage_limit
discounts__value	NUMERIC	discounts.value	discounts.value

Recharge metafields fields

The metafields report of the Recharge connector includes 10 fields.

ID	Type	Name	Description
metafields__created_at	TIMESTAMP	metafields.created_at	metafields.created_at
metafields__description	TEXT	metafields.description	metafields.description
metafields__id	TEXT	metafields.id	metafields.id
metafields__key	TEXT	metafields.key	metafields.key
metafields__namespace	TEXT	metafields.namespace	metafields.namespace
metafields__owner_id	TEXT	metafields.owner_id	metafields.owner_id
metafields__owner_resource	TEXT	metafields.owner_resource	metafields.owner_resource
metafields__updated_at	TIMESTAMP	metafields.updated_at	metafields.updated_at
metafields__value	TEXT	metafields.value	metafields.value
metafields__value_type	TEXT	metafields.value_type	metafields.value_type

Recharge onetimes fields

The onetimes report of the Recharge connector includes 16 fields.

ID	Type	Name	Description
onetimes__address_id	TEXT	onetimes.address_id	onetimes.address_id
onetimes__created_at	TIMESTAMP	onetimes.created_at	onetimes.created_at
onetimes__customer_id	TEXT	onetimes.customer_id	onetimes.customer_id
onetimes__id	TEXT	onetimes.id	onetimes.id
onetimes__next_charge_scheduled_at	TIMESTAMP	onetimes.next_charge_scheduled_at	onetimes.next_charge_scheduled_at
onetimes__price	TEXT	onetimes.price	onetimes.price
onetimes__product_title	TEXT	onetimes.product_title	onetimes.product_title
onetimes__properties	OBJECT	onetimes.properties	onetimes.properties
onetimes__quantity	NUMERIC	onetimes.quantity	onetimes.quantity
onetimes__recharge_product_id	TEXT	onetimes.recharge_product_id	onetimes.recharge_product_id
onetimes__shopify_product_id	TEXT	onetimes.shopify_product_id	onetimes.shopify_product_id
onetimes__shopify_variant_id	TEXT	onetimes.shopify_variant_id	onetimes.shopify_variant_id
onetimes__sku	TEXT	onetimes.sku	onetimes.sku
onetimes__status	TEXT	onetimes.status	onetimes.status
onetimes__updated_at	TIMESTAMP	onetimes.updated_at	onetimes.updated_at
onetimes__variant_title	TEXT	onetimes.variant_title	onetimes.variant_title

Recharge orders fields

The orders report of the Recharge connector includes 62 fields.

Recharge orders fields (orders__accepts_marketing to orders__shipping_lines)

ID	Type	Name	Description
orders__accepts_marketing	BOOLEAN	orders.accepts_marketing	orders.accepts_marketing
orders__address_id	TEXT	orders.address_id	orders.address_id
orders__address_is_active	BOOLEAN	orders.address_is_active	orders.address_is_active
orders__billing_address	OBJECT	orders.billing_address	orders.billing_address
orders__browser_ip	TEXT	orders.browser_ip	orders.browser_ip
orders__charge	OBJECT	orders.charge	orders.charge
orders__charge_id	TEXT	orders.charge_id	orders.charge_id
orders__charge_status	TEXT	orders.charge_status	orders.charge_status
orders__client_details	OBJECT	orders.client_details	orders.client_details
orders__created_at	TIMESTAMP	orders.created_at	orders.created_at
orders__currency	TEXT	orders.currency	orders.currency
orders__customer	OBJECT	orders.customer	orders.customer
orders__customer_id	TEXT	orders.customer_id	orders.customer_id
orders__discount_codes	OBJECT	orders.discount_codes	orders.discount_codes
orders__discounts	OBJECT	orders.discounts	orders.discounts
orders__email	TEXT	orders.email	orders.email
orders__error	TEXT	orders.error	orders.error
orders__external_cart_token	TEXT	orders.external_cart_token	orders.external_cart_token
orders__external_order_id	OBJECT	orders.external_order_id	orders.external_order_id
orders__external_order_name	OBJECT	orders.external_order_name	orders.external_order_name
orders__external_order_number	OBJECT	orders.external_order_number	orders.external_order_number
orders__first_name	TEXT	orders.first_name	orders.first_name
orders__hash	TEXT	orders.hash	orders.hash
orders__id	TEXT	orders.id	orders.id
orders__is_prepaid	BOOLEAN	orders.is_prepaid	orders.is_prepaid
orders__last_name	TEXT	orders.last_name	orders.last_name
orders__line_items	OBJECT	orders.line_items	orders.line_items
orders__note	TEXT	orders.note	orders.note
orders__note_attributes	OBJECT	orders.note_attributes	orders.note_attributes
orders__order_attributes	OBJECT	orders.order_attributes	orders.order_attributes
orders__payment_processor	TEXT	orders.payment_processor	orders.payment_processor
orders__phone	TEXT	orders.phone	orders.phone
orders__processed_at	TIMESTAMP	orders.processed_at	orders.processed_at
orders__redacted	BOOLEAN	orders.redacted	orders.redacted
orders__scheduled_at	TIMESTAMP	orders.scheduled_at	orders.scheduled_at
orders__send_email_welcome	BOOLEAN	orders.send_email_welcome	orders.send_email_welcome
orders__shipped_date	TEXT	orders.shipped_date	orders.shipped_date
orders__shipping_address	OBJECT	orders.shipping_address	orders.shipping_address
orders__shipping_date	TEXT	orders.shipping_date	orders.shipping_date
orders__shipping_lines	OBJECT	orders.shipping_lines	orders.shipping_lines

Recharge orders fields (orders__shopify_cart_token to orders__verified_email)

ID	Type	Name	Description
orders__shopify_cart_token	TEXT	orders.shopify_cart_token	orders.shopify_cart_token
orders__shopify_customer_id	TEXT	orders.shopify_customer_id	orders.shopify_customer_id
orders__shopify_id	TEXT	orders.shopify_id	orders.shopify_id
orders__shopify_order_id	TEXT	orders.shopify_order_id	orders.shopify_order_id
orders__shopify_order_number	TEXT	orders.shopify_order_number	orders.shopify_order_number
orders__status	TEXT	orders.status	orders.status
orders__subtotal_price	NUMERIC	orders.subtotal_price	orders.subtotal_price
orders__tags	TEXT	orders.tags	orders.tags
orders__tax_lines	OBJECT	orders.tax_lines	orders.tax_lines
orders__taxable	BOOLEAN	orders.taxable	orders.taxable
orders__total_discounts	NUMERIC	orders.total_discounts	orders.total_discounts
orders__total_duties	TEXT	orders.total_duties	orders.total_duties
orders__total_line_items_price	NUMERIC	orders.total_line_items_price	orders.total_line_items_price
orders__total_price	NUMERIC	orders.total_price	orders.total_price
orders__total_refunds	TEXT	orders.total_refunds	orders.total_refunds
orders__total_tax	TEXT	orders.total_tax	orders.total_tax
orders__total_weight	NUMERIC	orders.total_weight	orders.total_weight
orders__total_weight_grams	NUMERIC	orders.total_weight_grams	orders.total_weight_grams
orders__transaction_id	TEXT	orders.transaction_id	orders.transaction_id
orders__type	TEXT	orders.type	orders.type
orders__updated_at	TIMESTAMP	orders.updated_at	orders.updated_at
orders__verified_email	BOOLEAN	orders.verified_email	orders.verified_email

Recharge products fields

The products report of the Recharge connector includes 22 fields.

ID	Type	Name	Description
products__charge_interval_frequency	TEXT	products.charge_interval_frequency	products.charge_interval_frequency
products__collection_id	TEXT	products.collection_id	products.collection_id
products__created_at	TIMESTAMP	products.created_at	products.created_at
products__cutoff_day_of_month	TEXT	products.cutoff_day_of_month	products.cutoff_day_of_month
products__cutoff_day_of_week	TEXT	products.cutoff_day_of_week	products.cutoff_day_of_week
products__discount_amount	NUMERIC	products.discount_amount	products.discount_amount
products__discount_type	TEXT	products.discount_type	products.discount_type
products__expire_after_specific_number_of_charges	TEXT	products.expire_after_specific_number_of_charges	products.expire_after_specific_number_of_charges
products__handle	TEXT	products.handle	products.handle
products__id	TEXT	products.id	products.id
products__images	OBJECT	products.images	products.images
products__modifiable_properties	OBJECT	products.modifiable_properties	products.modifiable_properties
products__order_day_of_month	TEXT	products.order_day_of_month	products.order_day_of_month
products__order_day_of_week	TEXT	products.order_day_of_week	products.order_day_of_week
products__order_interval_frequency_options	OBJECT	products.order_interval_frequency_options	products.order_interval_frequency_options
products__order_interval_unit	TEXT	products.order_interval_unit	products.order_interval_unit
products__product_id	TEXT	products.product_id	products.product_id
products__shopify_product_id	TEXT	products.shopify_product_id	products.shopify_product_id
products__storefront_purchase_options	TEXT	products.storefront_purchase_options	products.storefront_purchase_options
products__subscription_defaults	OBJECT	products.subscription_defaults	products.subscription_defaults
products__title	TEXT	products.title	products.title
products__updated_at	TIMESTAMP	products.updated_at	products.updated_at

Recharge subscriptions fields

The subscriptions report of the Recharge connector includes 37 fields.

ID	Type	Name	Description
subscriptions__address_id	TEXT	subscriptions.address_id	subscriptions.address_id
subscriptions__analytics_data	OBJECT	subscriptions.analytics_data	subscriptions.analytics_data
subscriptions__cancellation_reason	TEXT	subscriptions.cancellation_reason	subscriptions.cancellation_reason
subscriptions__cancellation_reason_comments	TEXT	subscriptions.cancellation_reason_comments	subscriptions.cancellation_reason_comments
subscriptions__cancelled_at	TIMESTAMP	subscriptions.cancelled_at	subscriptions.cancelled_at
subscriptions__charge_interval_frequency	TEXT	subscriptions.charge_interval_frequency	subscriptions.charge_interval_frequency
subscriptions__commit_update	BOOLEAN	subscriptions.commit_update	subscriptions.commit_update
subscriptions__created_at	TIMESTAMP	subscriptions.created_at	subscriptions.created_at
subscriptions__customer_id	TEXT	subscriptions.customer_id	subscriptions.customer_id
subscriptions__email	TEXT	subscriptions.email	subscriptions.email
subscriptions__expire_after_specific_number_of_charges	TEXT	subscriptions.expire_after_specific_number_of_charges	subscriptions.expire_after_specific_number_of_charges
subscriptions__external_product_id	OBJECT	subscriptions.external_product_id	subscriptions.external_product_id
subscriptions__external_variant_id	OBJECT	subscriptions.external_variant_id	subscriptions.external_variant_id
subscriptions__has_queued_charges	BOOLEAN	subscriptions.has_queued_charges	subscriptions.has_queued_charges
subscriptions__id	TEXT	subscriptions.id	subscriptions.id
subscriptions__is_prepaid	BOOLEAN	subscriptions.is_prepaid	subscriptions.is_prepaid
subscriptions__is_skippable	BOOLEAN	subscriptions.is_skippable	subscriptions.is_skippable
subscriptions__is_swappable	BOOLEAN	subscriptions.is_swappable	subscriptions.is_swappable
subscriptions__max_retries_reached	BOOLEAN	subscriptions.max_retries_reached	subscriptions.max_retries_reached
subscriptions__next_charge_scheduled_at	TIMESTAMP	subscriptions.next_charge_scheduled_at	subscriptions.next_charge_scheduled_at
subscriptions__order_day_of_month	TEXT	subscriptions.order_day_of_month	subscriptions.order_day_of_month
subscriptions__order_day_of_week	TEXT	subscriptions.order_day_of_week	subscriptions.order_day_of_week
subscriptions__order_interval_frequency	TEXT	subscriptions.order_interval_frequency	subscriptions.order_interval_frequency
subscriptions__order_interval_unit	TEXT	subscriptions.order_interval_unit	subscriptions.order_interval_unit
subscriptions__presentment_currency	TEXT	subscriptions.presentment_currency	subscriptions.presentment_currency
subscriptions__price	NUMERIC	subscriptions.price	subscriptions.price
subscriptions__product_title	TEXT	subscriptions.product_title	subscriptions.product_title
subscriptions__properties	OBJECT	subscriptions.properties	subscriptions.properties
subscriptions__quantity	NUMERIC	subscriptions.quantity	subscriptions.quantity
subscriptions__recharge_product_id	TEXT	subscriptions.recharge_product_id	subscriptions.recharge_product_id
subscriptions__shopify_product_id	TEXT	subscriptions.shopify_product_id	subscriptions.shopify_product_id
subscriptions__shopify_variant_id	TEXT	subscriptions.shopify_variant_id	subscriptions.shopify_variant_id
subscriptions__sku	TEXT	subscriptions.sku	subscriptions.sku
subscriptions__sku_override	BOOLEAN	subscriptions.sku_override	subscriptions.sku_override
subscriptions__status	TEXT	subscriptions.status	subscriptions.status
subscriptions__updated_at	TIMESTAMP	subscriptions.updated_at	subscriptions.updated_at
subscriptions__variant_title	TEXT	subscriptions.variant_title	subscriptions.variant_title

Recharge other fields

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

ID	Type	Name	Description	Report
account_id	TEXT	Account ID	Account ID.
account_name	TEXT	Account Name	Account name.
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
date	DATE	Date	Date.
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
shop__shop	OBJECT	shop.shop	shop.shop	shop
shop__store	OBJECT	shop.store	shop.store	shop
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20

API Connectors