ReCharge Payments

Snapshot

Features	Details
Release Status	Released
Source API Version	‘2021-11’ ‘2021-01’ (1 table)
Table Selection	Yes
Column Selection	Yes
Edit Integrations	Yes
Replication Type Selection	No
Authentication Parameters	Recharge payments API token
Replication Type	Key based replication
Replication Key	Date
Suggested Replication Frequency	1 hr

How to fetch Recharge API tokens:

1. Sign in to Recharge payments.

2. Click API tokens under Apps on the left sidebar.

   
3. Click on "Create an API token" to generate a new set of tokens for Daton.

   
4. Fill in the form and give "read access" to the required tables you'd like to add on Daton.

   
5. Click "Save" after filling in all the details.

6. With the new token generated, use it on Daton while creating the integration.

Integrate Recharge Payments with Daton

1. Sign in to Daton.

2. Select Recharge Payments from integrations page.

3. Provide Integration Name Replication Frequency and History.

4. Provide your recharge's API token, generated using the steps above.

5. Post which you will be prompted to choose from the list of available tables.

6. Select all required columns for each table.

7. Submit the integration.

Recharge Payments Tables

Source documentation: https://developer.rechargepayments.com/2021-11/

1. Addresses Purpose: To view all the addresses of your customers. Replication: Incremental Replication Key: updated_at Fields

Name	Datatype
id	INTEGER
payment_method_id	INTEGER
address1	STRING
address2	STRING
city	STRING
company	STRING
country_code	STRING
created_at	DATETIME
customer_id	INTEGER
discounts	RECORD
first_name	STRING
last_name	STRING
order_attributes	RECORD
order_note	STRING
phone	STRING
province	STRING
shipping_lines_override	RECORD
updated_at	DATETIME
zip	STRING
created_at_ts	TIMESTAMP
updated_at_ts	TIMESTAMP

2. Charges Purpose: To get a list of charges (transactions) on your store. Replication: Incremental Replication Key: updated_at Fields

Name	Datatype
id	INTEGER
address_id	INTEGER
analytics_data	RECORD
billing_address	RECORD
client_details	RECORD
created_at	TIMESTAMP
currency	STRING
customer	RECORD
discounts	RECORD
external_order_id	RECORD
external_transaction_id	RECORD
has_uncommitted_changes	BOOLEAN
line_items	RECORD
note	STRING
order_attributes	RECORD
orders_count	INTEGER
payment_processor	STRING
processed_at	TIMESTAMP
retry_date	DATE
scheduled_at	DATE
shipping_address	RECORD
shipping_lines	RECORD
status	STRING
subtotal_price	STRING
tags	STRING
tax_lines	RECORD
taxable	BOOLEAN
total_discounts	STRING
total_line_items_price	STRING
total_price	STRING
total_refunds	STRING
total_tax	STRING
total_weight_grams	INTEGER
type	STRING
updated_at	TIMESTAMP
retry_date_ts	TIMESTAMP

3. Customers Purpose: To get all the information about your customers. Replication: Incremental Replication Key: updated_at Fields

Name	Datatype
id	INTEGER
analytics_data	RECORD
created_at	DATETIME
email	STRING
external_customer_id	RECORD
first_charge_processed_at	DATETIME
first_name	STRING
has_payment_method_in_dunning	BOOLEAN
has_valid_payment_method	BOOLEAN
hash	STRING
last_name	STRING
subscriptions_active_count	INTEGER
subscriptions_total_count	INTEGER
updated_at	DATETIME

4. Discounts Purpose: To get information about all the applicable/previously applicable discounts on your store. Replication: Incremental Replication Key: updated_at Fields

Name	Datatype
id	INTEGER
applies_to	RECORD
channel_settings	RECORD
code	STRING
created_at	TIMESTAMP
status	STRING
updated_at	TIMESTAMP
usage_limits	RECORD
value	STRING
value_type	STRING

5. Onetimes Purpose: To get a list of all the products bought when added to an ongoing subscription. Replication: Incremental Replication Key: updated_at Fields

Name	Datatype
id	INTEGER
address_id	INTEGER
created_at	TIMESTAMP
customer_id	INTEGER
external_product_id	RECORD
external_variant_id	RECORD
next_charge_scheduled_at	TIMESTAMP
price	STRING
product_title	STRING
properties	RECORD
quantity	INTEGER
sku	STRING
sku_override	BOOLEAN
updated_at	TIMESTAMP
variant_title	STRING
next_charge_scheduled_at_dt	DATE

6. Orders Purpose: To get list of all the orders from your store. Replication: Incremental Replication Key: updated_at Fields

Name	Datatype
id	INTEGER
address_id	INTEGER
billing_address	RECORD
charge	RECORD
client_details	RECORD
created_at	DATETIME
currency	STRING
customer	RECORD
discounts	RECORD
external_cart_token	STRING
external_order_id	RECORD
external_order_number	RECORD
is_prepaid	BOOLEAN
line_items	RECORD
note	STRING
order_attributes	RECORD
processed_at	DATETIME
scheduled_at	DATETIME
shipping_address	RECORD
shipping_lines	RECORD
status	STRING
subtotal_price	STRING
tags	STRING
tax_lines	RECORD
taxable	BOOLEAN
total_discounts	STRING
total_line_items_price	STRING
total_price	STRING
total_refunds	STRING
total_tax	STRING
total_weight_grams	INTEGER
type	STRING
updated_at	DATETIME
created_at_ts	TIMESTAMP
processed_at_ts	TIMESTAMP
scheduled_at_ts	TIMESTAMP
updated_at_ts	TIMESTAMP

7. Plans Purpose: To get a list of all the plans on your store. Replication: Incremental Replication Key: updated_at Fields

Name	Datatype
id	INTEGER
channel_settings	RECORD
created_at	TIMESTAMP
external_product_id	RECORD
sort_order	INTEGER
subscription_preferences	RECORD
title	STRING
type	STRING
updated_at	TIMESTAMP

8. Products Purpose: To get a list of all the products in your catalogue. Replication: Replication Key: external_product_ids Fields

Name	Datatype
id	INTEGER
collection_id	INTEGER
created_at	DATETIME
discount_amount	INTEGER
discount_type	STRING
handle	STRING
images	RECORD
product_id	INTEGER
shopify_product_id	INTEGER
subscription_defaults	RECORD
title	STRING
updated_at	DATETIME
discount_amount_nu	NUMERIC
product_id_nu	NUMERIC
shopify_product_id_nu	NUMERIC

9. Subscriptions Purpose: To get information about all the subscriptions. Replication: Incremental Replication Key: updated_at Fields

Name	Datatype
id	INTEGER
address_id	INTEGER
customer_id	INTEGER
analytics_data	RECORD
charge_interval_frequency	INTEGER
created_at	TIMESTAMP
expire_after_specific_number_of_charges	INTEGER
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	INTEGER
order_interval_unit	STRING
price	STRING
product_title	STRING
properties	RECORD
quantity	INTEGER
sku	STRING
sku_override	BOOLEAN
status	STRING
updated_at	TIMESTAMP
variant_title	STRING