Schema Information

Structured details and metadata about the Recharge Payments v2 connector and its corresponding tables and fields.

List of Tables/APIs
Subscriptions
Charges
Customers
Discounts
Onetimes
Orders
Address
Products
Collections

Subscriptions

Purpose: This API call will display a list of all the individual items that a customer receives on a recurring basis from your Recharge account.

Source API Documentation: Recharge Payments v2- Subscriptions

FIELDS

Field Name	Data Type
id	NUMERIC
address_id	NUMERIC
customer_id	NUMERIC
cancellation_reason	STRING
cancellation_reason_comments	STRING
cancelled_at	TIMESTAMP
analytics_data	RECORD
charge_interval_frequency	NUMERIC
created_at	TIMESTAMP
external_product_id	RECORD
external_variant_id	RECORD
has_queued_charges	BOOLEAN
is_prepaid	BOOLEAN
is_skippable	BOOLEAN
is_swappable	BOOLEAN
max_retries_reached	BOOLEAN
next_charge_scheduled_at	DATE
order_interval_frequency	NUMERIC
order_interval_unit	STRING
price	STRING
product_title	STRING
properties	RECORD
quantity	NUMERIC
sku	STRING
sku_override	BOOLEAN
status	STRING
updated_at	TIMESTAMP
variant_title	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC
presentment_currency	STRING
expire_after_specific_number_of_charges	NUMERIC
order_day_of_month	NUMERIC

Charges

Purpose: A charge is a transaction that was processed already or the representation of an upcoming transaction. This API call will display a list of all the financial transactions linked to the purchase of any item (past or future) on your Recharge account.

Source API Documentation: Recharge Payments v2- Charges

FIELDS

Field Name	Data Type
id	NUMERIC
address_id	NUMERIC
billing_address	RECORD
client_details	RECORD
created_at	TIMESTAMP
currency	STRING
customer	RECORD
external_order_id	RECORD
external_transaction_id	RECORD
has_uncommitted_changes	BOOLEAN
line_items	RECORD
note	STRING
order_attributes	RECORD
orders_count	NUMERIC
payment_processor	STRING
processed_at	TIMESTAMP
scheduled_at	DATE
shipping_address	RECORD
shipping_lines	RECORD
status	STRING
subtotal_price	STRING
tags	STRING
taxable	BOOLEAN
total_discounts	STRING
total_line_items_price	STRING
total_price	STRING
total_refunds	STRING
total_tax	STRING
total_weight_grams	NUMERIC
type	STRING
updated_at	TIMESTAMP
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC
tax_lines	RECORD
taxes_included	BOOLEAN
discounts	RECORD
error	STRING
error_type	STRING
retry_date	TIMESTAMP

Customers

Purpose: This API call will display a list of account information of all the customers in your Recharge account.

Source API Documentation: Recharge Payments v2- Customers

FIELDS

Field Name	Data Type
id	NUMERIC
created_at	TIMESTAMP
email	STRING
external_customer_id	RECORD
first_charge_processed_at	TIMESTAMP
first_name	STRING
has_payment_method_in_dunning	BOOLEAN
has_valid_payment_method	BOOLEAN
hash	STRING
last_name	STRING
subscriptions_active_count	NUMERIC
subscriptions_total_count	NUMERIC
updated_at	TIMESTAMP
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC
phone	STRING
tax_exempt	BOOLEAN

Discounts

Purpose: This API calls the data-related product discounts that can be applied to orders for customers on your Recharge account.

Source API Documentation: Recharge Payments v2- Discounts

FIELDS

Field Name	Data Type
id	NUMERIC
applies_to	RECORD
channel_settings	RECORD
code	STRING
created_at	TIMESTAMP
status	STRING
updated_at	TIMESTAMP
usage_limits	RECORD
value	STRING
value_type	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC
external_discount_id	RECORD
external_discount_source	STRING
starts_at	TIMESTAMP
ends_at	TIMESTAMP
prerequisite_subtotal_min	STRING

Onetimes

Purpose: This API call will display a list of non-recurring line items on a queued charge on your Recharge account.

Source API Documentation: Recharge Payments v2- Onetimes

FIELDS

Field Name	Data Type
id	NUMERIC
address_id	NUMERIC
customer_id	NUMERIC
created_at	TIMESTAMP
external_product_id	RECORD
external_variant_id	RECORD
next_charge_scheduled_at	DATE
price	STRING
product_title	STRING
quantity	NUMERIC
sku_override	BOOLEAN
updated_at	TIMESTAMP
variant_title	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC
is_cancelled	BOOLEAN
presentment_currency	STRING
properties	RECORD
sku	STRING

Orders

Purpose: This API call will display all the data in accordance with a charge on your Recharge account.

Source API Documentation: Recharge Payments v2- Orders

FIELDS

Field Name	Data Type
id	NUMERIC
address_id	NUMERIC
billing_address	RECORD
charge	RECORD
client_details	RECORD
created_at	TIMESTAMP
currency	STRING
customer	RECORD
external_order_id	RECORD
external_order_name	RECORD
external_order_number	RECORD
is_prepaid	BOOLEAN
line_items	RECORD
note	STRING
processed_at	TIMESTAMP
scheduled_at	TIMESTAMP
shipping_address	RECORD
shipping_lines	RECORD
status	STRING
subtotal_price	STRING
tags	STRING
taxable	BOOLEAN
total_discounts	STRING
total_line_items_price	STRING
total_price	STRING
total_refunds	STRING
total_tax	STRING
total_weight_grams	NUMERIC
type	STRING
updated_at	TIMESTAMP
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

Address

Purpose: This API call will display the shipping addresses of available orders on your Recharge account.

Source API Documentation: Recharge Payments v2- Address

FIELDS

Field Name	Data Type
id	NUMERIC
customer_id	NUMERIC
payment_method_id	NUMERIC
address1	STRING
address2	STRING
city	STRING
company	STRING
country_code	STRING
created_at	TIMESTAMP
first_name	STRING
last_name	STRING
phone	STRING
province	STRING
updated_at	TIMESTAMP
zip	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC
order_attributes	RECORD
shipping_lines_conserved	RECORD
presentment_currency	STRING
discounts	RECORD
order_note	STRING

Products

Purpose: This API call will display a list of all the products from the catalog on your Recharge account.

Source API Documentation: Recharge Payments v2- Products

FIELDS

Field Name	Data Type
created_at	DATETIME
discount_amount	NUMERIC
discount_type	STRING
handle	STRING
id	NUMERIC
images	RECORD
product_id	NUMERIC
shopify_product_id	NUMERIC
subscription_defaults	RECORD
title	STRING
updated_at	DATETIME
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

Collections

Purpose: This API call will display a logical list of products aka collections in your Recharge account.

Source API Documentation: Recharge Payments v2- Collections

FIELDS

Field Name	Data Type
id	NUMERIC
created_at	DATETIME
description	STRING
sort_order	STRING
title	STRING
type	STRING
updated_at	DATETIME
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

Contact Us

Main Menu

Back to Top