# 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="/files/0EyooHf0TlCisYgMyMFG" alt=""><figcaption></figcaption></figure>
3. Click on "Create an API token" to generate a new set of tokens for Daton.

   <figure><img src="/files/yLZJHpsbAWc3UPxP0IUT" 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="/files/foYQXNISaNVUmG4sXNyW" 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;


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/saas-integrations/recharge-payments.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.