# ReCharge Payments

## **Snapshot**

| Features                        | Details                                 |
| ------------------------------- | --------------------------------------- |
| Release Status                  | Released                                |
| Source API Version              | <p>‘2021-11’<br>‘2021-01’ (1 table)</p> |
| 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](https://rechargepayments.com/) to Recharge payments.
2. Click **API tokens** under Apps on the left sidebar.<br>

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FZHNmiFqBHPtntJouZ6wG%2Fimage.png?alt=media&#x26;token=3f9b1d40-cf0c-461f-ade8-b3b9a4402c72" alt=""><figcaption></figcaption></figure>
3. Click on "Create an API token" to generate a new set of tokens for Daton.

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FxRZEjPR90SmYVpSbf4z4%2Fimage.png?alt=media&#x26;token=e53fc08d-9a64-48a0-9615-5278d06763a4" alt=""><figcaption></figcaption></figure>
4. Fill in the form and give "read access" to the required tables you'd like to add on Daton.

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FEDSQJ9DXz8Ht9Cf3LH2M%2Fimage.png?alt=media&#x26;token=23e5dfcc-37fd-4e86-b0f6-f13cf0430589" alt=""><figcaption></figcaption></figure>
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](https://daton.sarasanalytics.com/u/integrations-list) to Daton.
2. Select Recharge Payments from the integrations page.
3. Provide Integration Name Replication Frequency and History.
4. Provide your recharge's API token, generated using the steps [above](#how-to-fetch-recharge-api-tokens).
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/>

#### **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    |

#### **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    |

#### **Customers**

Purpose: To get all the information about your customers.

Replication: Incremental

Replication Key: updated\_at\
\
**Fields**<br>

| **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     |

#### **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       |

&#x20;**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         |

#### **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    |

#### **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    |

#### **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      |

#### **Subscriptions**

Purpose: To get information about all the subscriptions.

Replication: Incremental

Replication Key: updated\_at\
\
**Fields**

<table data-header-hidden><thead><tr><th width="391.5793991416309"></th><th></th></tr></thead><tbody><tr><td><strong>Name</strong></td><td><strong>Datatype</strong></td></tr><tr><td>id</td><td>INTEGER</td></tr><tr><td>address_id</td><td>INTEGER</td></tr><tr><td>customer_id</td><td>INTEGER</td></tr><tr><td>analytics_data</td><td>RECORD</td></tr><tr><td>charge_interval_frequency</td><td>INTEGER</td></tr><tr><td>created_at</td><td>TIMESTAMP</td></tr><tr><td>expire_after_specific_number_of_charges</td><td>INTEGER</td></tr><tr><td>external_product_id</td><td>RECORD</td></tr><tr><td>external_variant_id</td><td>RECORD</td></tr><tr><td>has_queued_charges</td><td>BOOLEAN</td></tr><tr><td>is_prepaid</td><td>BOOLEAN</td></tr><tr><td>is_skippable</td><td>BOOLEAN</td></tr><tr><td>is_swappable</td><td>BOOLEAN</td></tr><tr><td>max_retries_reached</td><td>BOOLEAN</td></tr><tr><td>next_charge_scheduled_at</td><td>DATE</td></tr><tr><td>order_interval_frequency</td><td>INTEGER</td></tr><tr><td>order_interval_unit</td><td>STRING</td></tr><tr><td>price</td><td>STRING</td></tr><tr><td>product_title</td><td>STRING</td></tr><tr><td>properties</td><td>RECORD</td></tr><tr><td>quantity</td><td>INTEGER</td></tr><tr><td>sku</td><td>STRING</td></tr><tr><td>sku_override</td><td>BOOLEAN</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>updated_at</td><td>TIMESTAMP</td></tr><tr><td>variant_title</td><td>STRING</td></tr></tbody></table>

&#x20;