Schema Information

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

List of Tables/APIs

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

NUMERIC

created_at

TIMESTAMP

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

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

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

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

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

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

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

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

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

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

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