# Integration Specifications

## Integration Overview

Recharge is one of the key subscription platforms available for eCommerce.  The platform allows you to stay connected to your users and can help bolster your recurring revenue and reduce churn.  Out of the box, you can allow your users to have better control over their deliveries, understand their reasons for churning and improve payment conversions with automatic retries and dunning. 

Daasity's Recharge extraction helps you understand your recharge data, pulling in key data points from charges, customers, orders, subscriptions, and subscribers to help you take action on the best (and worst) performing areas.

## Integration Availability

This integration is available for: 

* Enterprise

## API Endpoints

The Daasity Recharge extractor is built based on this [Recharge API documentation](https://developer.rechargepayments.com/2021-11). The following endpoints are used by Daasity to replicate data from Recharge:

* [List Addresses](https://developer.rechargepayments.com/2021-11/addresses/list_addresses)
* [List Bundle Selections](https://developer.rechargepayments.com/2021-11/bundle_selections/bundle_selection_list)
* [List Charges](https://developer.rechargepayments.com/2021-11/charges/charge_list)
* [List Customers](https://developer.rechargepayments.com/2021-11/customers/customers_list)
* [List Discounts](https://developer.rechargepayments.com/2021-11/discounts/discounts_list)
* [List Events](https://developer.rechargepayments.com/2021-11/events/events_list)
* [List Onetimes](https://developer.rechargepayments.com/2021-11/onetimes/onetimes_list)
* [List Orders](https://developer.rechargepayments.com/2021-11/orders/orders_list)
* [List Payment Methods](https://developer.rechargepayments.com/2021-11/payment_methods/payment_methods_list)
* [List Subscriptions](https://developer.rechargepayments.com/2021-11/subscriptions/subscriptions_list)

## Recharge 2021-11 Schema

The Daasity Recharge extractor creates these tables using the endpoints and replication methods listed.  The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.

* [Addresses](#addresses)
* [Address Discounts](#address-discounts)
* [Address Order Attributes](#address-order-attributes)
* [Address Shipping Lines Conserved](#address-shipping-lines-conserved)
* [Address Shipping Lines Override](#address-shipping-lines-override)
* [Bundle Selections](#bundle-selections)
* [Bundle Selection Items](#bundle-selection-items)
* [Charges](#charges)
* [Charge Analytics Data UTM Params](#charge-analytics-data-utm-params)
* [Charge Discount Codes](#charge-discount-codes)
* [Charge Line Items](#charge-line-items)
* [Charge Line Item Properties](#charge-line-item-properties)
* [Charge Order Attributes](#charge-order-attributes)
* [Charge Shipping Lines](#charge-shipping-lines)
* [Customers](#customers)
* [Customer Analytics Data UTM Params](#customer-analytics-data-utm-params)
* [Discounts](#discounts)
* [Discount Applies to IDs](#discount-applies-to-ids)
* [Events](#events)
* [Event Custom Attributes](#event-custom-attributes)
* [Onetimes](#onetimes)
* [Onetime Properties](#onetime-properties)
* [Orders](#orders)
* [Order Line Items](#order-line-items)
* [Order Line Item Properties](#order-line-item-properties)
* [Order Shipping Lines](#order-shipping-lines)
* [Payment Methods](#payment-methods)
* [Subscriptions](#subscriptions)
* [Subscription Analytics Data UTM Params](#subscription-analytics-data-utm-params)
* [Subscription Properties](#subscription-properties)

### Addresses

* Endpoint: [List Addresses](https://developer.rechargepayments.com/2021-11/addresses/list_addresses)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.addresses]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>addresses[].id</td><td>ID</td></tr><tr><td>addresses[].customer_id</td><td>CUSTOMER_ID</td></tr><tr><td>addresses[].payment_method_id</td><td>PAYMENT_METHOD_ID</td></tr><tr><td>addresses[].address1</td><td>ADDRESS1</td></tr><tr><td>addresses[].address2</td><td>ADDRESS2</td></tr><tr><td>addresses[].city</td><td>CITY</td></tr><tr><td>addresses[].company</td><td>COMPANY</td></tr><tr><td>addresses[].country_code</td><td>COUNTRY_CODE</td></tr><tr><td>addresses[].created_at</td><td>CREATED_AT</td></tr><tr><td>addresses[].first_name</td><td>FIRST_NAME</td></tr><tr><td>addresses[].last_name</td><td>LAST_NAME</td></tr><tr><td>addresses[].order_note</td><td>ORDER_NOTE</td></tr><tr><td>addresses[].phone</td><td>PHONE</td></tr><tr><td>addresses[].presentment_currency</td><td>PRESENTMENT_CURRENCY</td></tr><tr><td>addresses[].province</td><td>PROVINCE</td></tr><tr><td>addresses[].updated_at</td><td>UPDATED_AT</td></tr><tr><td>addresses[].zip</td><td>ZIP</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(addresses[].id)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Address Discounts

* Endpoint: [List Addresses](https://developer.rechargepayments.com/2021-11/addresses/list_addresses)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.address_discounts]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>addresses[].id</td><td>ADDRESS_ID</td></tr><tr><td>addresses[].discounts[].id</td><td>DISCOUNT_ID</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>addresses[].id +<br>discounts[].id<br>)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Address Order Attributes

* Endpoint: [List Addresses](https://developer.rechargepayments.com/2021-11/addresses/list_addresses)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.address_order_attributes]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>addresses[].id</td><td>ADDRESS_ID</td></tr><tr><td>addresses[].order_attributes[].name</td><td>NAME</td></tr><tr><td>addresses[].order_attributes[].value</td><td>VALUE</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>addresses[].id +<br>addresses[].order_attributes[].name +<br>addresses[].order_attributes[].value<br>)</td><td>__SYNC_KEY</td></tr></tbody></table>

### Address Shipping Lines Conserved

* Endpoint: [List Addresses](https://developer.rechargepayments.com/2021-11/addresses/list_addresses)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.address_shipping_lines_conserved]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>addresses[].id</td><td>ADDRESS_ID</td></tr><tr><td>addresses[].shipping_lines_conserved[].code</td><td>CODE</td></tr><tr><td>addresses[].shipping_lines_conserved[].price</td><td>PRICE</td></tr><tr><td>addresses[].shipping_lines_conserved[].title</td><td>TITLE</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>addresses[].id +<br>addresses[].shipping_lines_conserved[].code +<br>addresses[].shipping_lines_conserved[].title<br>)</td><td>__SYNC_KEY</td></tr></tbody></table>

### Address Shipping Lines Override

* Endpoint: [List Addresses](https://developer.rechargepayments.com/2021-11/addresses/list_addresses)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.address_shipping_lines_override]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td><a href="http://addresses.array.id/">addresses[].id</a></td><td>ADDRESS_ID</td></tr><tr><td>addresses[].shipping_lines_override[].code</td><td>CODE</td></tr><tr><td>addresses[].shipping_lines_override[].price</td><td>PRICE</td></tr><tr><td>addresses[].shipping_lines_override[].title</td><td>TITLE</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>addresses[].id +<br>addresses[].shipping_lines_override[].code +<br>addresses[].shipping_lines_override[].title<br>)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Bundle Selections

* Endpoint: [List Bundle Selections](https://developer.rechargepayments.com/2021-11/bundle_selections/bundle_selection_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.bundle_selections]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>bundle_selections[].id</td><td>ID</td></tr><tr><td>bundle_selections[].bundle_variant</td><td>BUNDLE_VARIANT_ID</td></tr><tr><td>bundle_selections[].charge_id</td><td>CHARGE_ID</td></tr><tr><td>bundle_selections[].order_id</td><td>ORDER_ID</td></tr><tr><td>bundle_selections[].purchase_item_id</td><td>PURCHASE_ITEM_ID</td></tr><tr><td>bundle_selections[].created_at</td><td>CREATED_AT</td></tr><tr><td>bundle_selections[].external_product_id</td><td>EXTERNAL_PRODUCT_ID</td></tr><tr><td>bundle_selections[].external_variant_id</td><td>EXTERNAL_VARIANT_ID</td></tr><tr><td>bundle_selections[].items_count</td><td>ITEMS_COUNT</td></tr><tr><td>bundle_selections[].updated_at</td><td>UPDATED_AT</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(bundle_selections[].id)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Bundle Selection Items

* Endpoint: [List Bundle Selections](https://developer.rechargepayments.com/2021-11/bundle_selections/bundle_selection_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.bundle_selection_items]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>bundle_selections[].id</td><td>BUNDLE_ID</td></tr><tr><td>bundle_selections[].items[].id</td><td>ITEM_ID</td></tr><tr><td>bundle_selections[].items[].collection_id</td><td>COLLECTION_ID</td></tr><tr><td>bundle_selections[].items[].collection_source</td><td>COLLECTION_SOURCE</td></tr><tr><td>bundle_selections[].items[].created_at</td><td>CREATED_AT</td></tr><tr><td>bundle_selections[].items[].external_product_id</td><td>EXTERNAL_PRODUCT_ID</td></tr><tr><td>bundle_selections[].items[].external_variant_id</td><td>EXTERNAL_VARIANT_ID</td></tr><tr><td>bundle_selections[].items[].price</td><td>PRICE</td></tr><tr><td>bundle_selections[].items[].quantity</td><td>QUANTITY</td></tr><tr><td>bundle_selections[].items[].updated_at</td><td>UPDATED_AT</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>bundle_selections[].id +<br>bundle_selections[].items[].id<br>)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Charges

* Endpoint: [List Charges](https://developer.rechargepayments.com/2021-11/charges/charge_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.charges]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>charges[].id</td><td>ID</td></tr><tr><td>charges[].note</td><td>NOTE</td></tr><tr><td>charges[].tags</td><td>TAGS</td></tr><tr><td>charges[].type</td><td>TYPE</td></tr><tr><td>charges[].error</td><td>ERROR</td></tr><tr><td>charges[].status</td><td>STATUS</td></tr><tr><td>charges[].currency</td><td>CURRENCY</td></tr><tr><td>charges[].total_tax</td><td>TOTAL_TAX</td></tr><tr><td>charges[].address_id</td><td>ADDRESS_ID</td></tr><tr><td>charges[].error_type</td><td>ERROR_TYPE</td></tr><tr><td>charges[].created_at</td><td>CREATED_AT</td></tr><tr><td>charges[].updated_at</td><td>UPDATED_AT</td></tr><tr><td>charges[].total_price</td><td>TOTAL_PRICE</td></tr><tr><td>charges[].scheduled_at</td><td>SCHEDULED_AT</td></tr><tr><td>charges[].total_refunds</td><td>TOTAL_REFUNDS</td></tr><tr><td>charges[].tax_lines</td><td>TAX_LINES</td></tr><tr><td>charges[].payment_processor</td><td>PAYMENT_PROCESSOR</td></tr><tr><td>charges[].subtotal_price</td><td>SUBTOTAL_PRICE</td></tr><tr><td>charges[].taxes_included</td><td>TAXES_INCLUDED</td></tr><tr><td>charges[].total_discounts</td><td>TOTAL_DISCOUNTS</td></tr><tr><td>charges[].customer.id</td><td>CUSTOMER_ID</td></tr><tr><td>charges[].customer.hash</td><td>CUSTOMER_HASH</td></tr><tr><td>charges[].customer.email</td><td>CUSTOMER_EMAIL</td></tr><tr><td>charges[].customer.external_customer_id.ecommerce</td><td>CUSTOMER_EXTERNAL_CUSTOMER_ID_ECOMMERCE</td></tr><tr><td>charges[].total_weight_grams</td><td>TOTAL_WEIGHT_GRAMS</td></tr><tr><td>charges[].total_line_items_price</td><td>TOTAL_LINE_ITEMS_PRICE</td></tr><tr><td>charges[].has_uncommitted_changes</td><td>HAS_UNCOMMITTED_CHANGES</td></tr><tr><td>charges[].client_details.browser_ip</td><td>CLIENT_DETAILS_BROWSER_IP</td></tr><tr><td>charges[].client_details.user_agent</td><td>CLIENT_DETAILS_USER_AGENT</td></tr><tr><td>charges[].external_order_id.ecommerce</td><td>EXTERNAL_ORDER_ID_ECOMMERCE</td></tr><tr><td>charges[].external_transaction_id.payment_processor</td><td>EXTERNAL_TRANSACTION_ID_PAYMENT_PROCESSOR</td></tr><tr><td>charges[].shipping_address.zip</td><td>SHIPPING_ADDRESS_ZIP</td></tr><tr><td>charges[].shipping_address.city</td><td>SHIPPING_ADDRESS_CITY</td></tr><tr><td>charges[].shipping_address.phone</td><td>SHIPPING_ADDRESS_PHONE</td></tr><tr><td>charges[].shipping_address.company</td><td>SHIPPING_ADDRESS_COMPANY</td></tr><tr><td>charges[].shipping_address.country</td><td>SHIPPING_ADDRESS_COUNTRY</td></tr><tr><td>charges[].shipping_address.address1</td><td>SHIPPING_ADDRESS_ADDRESS1</td></tr><tr><td>charges[].shipping_address.address2</td><td>SHIPPING_ADDRESS_ADDRESS2</td></tr><tr><td>charges[].shipping_address.province</td><td>SHIPPING_ADDRESS_PROVINCE</td></tr><tr><td>charges[].shipping_address.last_name</td><td>SHIPPING_ADDRESS_LAST_NAME</td></tr><tr><td>charges[].shipping_address.first_name</td><td>SHIPPING_ADDRESS_FIRST_NAME</td></tr><tr><td>charges[].billing_address.zip</td><td>BILLING_ADDRESS_ZIP</td></tr><tr><td>charges[].billing_address.city</td><td>BILLING_ADDRESS_CITY</td></tr><tr><td>charges[].billing_address.phone</td><td>BILLING_ADDRESS_PHONE</td></tr><tr><td>charges[].billing_address.company</td><td>BILLING_ADDRESS_COMPANY</td></tr><tr><td>charges[].billing_address.address1</td><td>BILLING_ADDRESS_ADDRESS1</td></tr><tr><td>charges[].billing_address.address2</td><td>BILLING_ADDRESS_ADDRESS2</td></tr><tr><td>charges[].billing_address.province</td><td>BILLING_ADDRESS_PROVINCE</td></tr><tr><td>charges[].billing_address.last_name</td><td>BILLING_ADDRESS_LAST_NAME</td></tr><tr><td>charges[].billing_address.first_name</td><td>BILLING_ADDRESS_FIRST_NAME</td></tr><tr><td>charges[].billing_address.country_code</td><td>BILLING_ADDRESS_COUNTRY_CODE</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(charges[].id)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Charge Analytics Data UTM Params

* Endpoint: [List Charges](https://developer.rechargepayments.com/2021-11/charges/charge_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.charge_analytics_data_utm_params]`

<table data-full-width="true"><thead><tr><th width="600">JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>charges[].id</td><td>CHARGE_ID</td></tr><tr><td>charges[].analytics_data.utm_params[].utm_term</td><td>UTM_TERM</td></tr><tr><td>charges[].analytics_data.utm_params[].utm_medium</td><td>UTM_MEDIUM</td></tr><tr><td>charges[].analytics_data.utm_params[].utm_source</td><td>UTM_SOURCE</td></tr><tr><td>charges[].analytics_data.utm_params[].utm_content</td><td>UTM_CONTENT</td></tr><tr><td>charges[].analytics_data.utm_params[].utm_campaign</td><td>UTM_CAMPAIGN</td></tr><tr><td>charges[].analytics_data.utm_params[].utm_time_stamp</td><td>UTM_TIME_STAMP</td></tr><tr><td>charges[].analytics_data.utm_params[].utm_data_source</td><td>UTM_DATA_SOURCE</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>charges[].id +<br>charges[].analytics_data.utm_params[].utm_term +<br>charges[].analytics_data.utm_params[].utm_medium +<br>charges[].analytics_data.utm_params[].utm_source +<br>charges[].analytics_data.utm_params[].utm_content +<br>charges[].analytics_data.utm_params[].utm_campaign +<br>charges[].analytics_data.utm_params[].utm_time_stamp +<br>charges[].analytics_data.utm_params[].utm_data_source<br>)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Charge Discount Codes

* Endpoint: [List Charges](https://developer.rechargepayments.com/2021-11/charges/charge_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.charge_discount_codes]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>charges[].id</td><td>CHARGE_ID</td></tr><tr><td>charges[].discounts[].id</td><td>DISCOUNT_ID</td></tr><tr><td>charges[].discounts[].code</td><td>DISCOUNT_CODE</td></tr><tr><td>charges[].discounts[].value</td><td>DISCOUNT_VALUE</td></tr><tr><td>charges[].discounts[].value_type</td><td>DISCOUNT_VALUE_TYPE</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>charges[].id +<br>charges[].discounts[].id<br>)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Charge Line Items

* Endpoint: [List Charges](https://developer.rechargepayments.com/2021-11/charges/charge_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.charge_line_items]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>charges[].id</td><td>CHARGE_ID</td></tr><tr><td>charges[].line_items[].sku</td><td>LINE_ITEM_SKU</td></tr><tr><td>charges[].line_items[].grams</td><td>LINE_ITEM_GRAMS</td></tr><tr><td>charges[].line_items[].title</td><td>LINE_ITEM_TITLE</td></tr><tr><td>charges[].line_items[].taxable</td><td>LINE_ITEM_TAXABLE</td></tr><tr><td>charges[].line_items[].tax_due</td><td>LINE_ITEM_TAX_DUE</td></tr><tr><td>charges[].line_items[].quantity</td><td>LINE_ITEM_QUANTITY</td></tr><tr><td>charges[].line_items[].unit_price</td><td>LINE_ITEM_UNIT_PRICE</td></tr><tr><td>charges[].line_items[].total_price</td><td>LINE_ITEM_TOTAL_PRICE</td></tr><tr><td>charges[].line_items[].variant_title</td><td>LINE_ITEM_VARIANT_TITLE</td></tr><tr><td>charges[].line_items[].original_price</td><td>LINE_ITEM_ORIGINAL_PRICE</td></tr><tr><td>charges[].line_items[].taxable_amount</td><td>LINE_ITEM_TAXABLE_AMOUNT</td></tr><tr><td>charges[].line_items[].purchase_item_id</td><td>LINE_ITEM_PURCHASE_ITEM_ID</td></tr><tr><td>charges[].line_items[].purchase_item_type</td><td>LINE_ITEM_PURCHASE_ITEM_TYPE</td></tr><tr><td>charges[].line_items[].external_variant_id.ecommerce</td><td>LINE_ITEM_EXTERNAL_VARIANT_ID_ECOMMERCE</td></tr><tr><td>charges[].line_items[].external_product_id.ecommerce</td><td>LINE_ITEM_EXTERNAL_PRODUCT_ID_ECOMMERCE</td></tr><tr><td>charges[].line_items[].tax_lines</td><td>LINE_ITEM_TAX_LINES</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>charges[].id +<br>charges[].line_items[].purchase_item_id +<br>charges[].line_items[].sku +<br>charges[].line_items[].title +<br>charges[].line_items[].variant_title<br>)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Charge Line Item Properties

* Endpoint: [List Charges](https://developer.rechargepayments.com/2021-11/charges/charge_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.charge_line_item_properties]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>charges[].id</td><td>CHARGE_ID</td></tr><tr><td>charges[].line_items[].purchase_item_id</td><td>LINE_ITEM_PURCHASE_ITEM_ID</td></tr><tr><td>charges[].line_items[].sku</td><td>LINE_ITEM_SKU</td></tr><tr><td>charges[].line_items[].title</td><td>LINE_ITEM_TITLE</td></tr><tr><td>charges[].line_items[].variant_title</td><td>LINE_ITEM_VARIANT_TITLE</td></tr><tr><td>charges[].line_items[].properties[].name</td><td>LINE_ITEM_PROPERTY_NAME</td></tr><tr><td>charges[].line_items[].properties[].value</td><td>LINE_ITEM_PROPERTY_VALUE</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>charges[].id +<br>charges[].line_items[].purchase_item_id +<br>charges[].line_items[].sku +<br>charges[].line_items[].title +<br>charges[].line_items[].variant_title +<br>charges[].line_items[].properties[].name +<br>charges[].line_items[].properties[].value<br>)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Charge Order Attributes

* Endpoint: [List Charges](https://developer.rechargepayments.com/2021-11/charges/charge_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.charge_order_attributes]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>charges[].id</td><td>CHARGE_ID</td></tr><tr><td>charges[].order_attributes[].name</td><td>ORDER_ATTRIBUTES_NAME</td></tr><tr><td>charges[].order_attributes[].value</td><td>ORDER_ATTRIBUTES_VALUE</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>charges[].id +<br>charges[].order_attributes[].name +<br>charges[].order_attributes[].value<br>)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Charge Shipping Lines

* Endpoint: [List Charges](https://developer.rechargepayments.com/2021-11/charges/charge_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.charge_shipping_lines]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>charges[].id</td><td>CHARGE_ID</td></tr><tr><td>charges[].shipping_lines[].code</td><td>SHIPPING_LINE_CODE</td></tr><tr><td>charges[].shipping_lines[].price</td><td>SHIPPING_LINE_PRICE</td></tr><tr><td>charges[].shipping_lines[].title</td><td>SHIPPING_LINE_TITLE</td></tr><tr><td>charges[].shipping_lines[].taxable</td><td>SHIPPING_LINE_TAXABLE</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>charges[].id +<br>charges[].shipping_lines[].code +<br>charges[].shipping_lines[].price +<br>charges[].shipping_lines[].title +<br>charges[].shipping_lines[].taxable<br>)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Customers

* Endpoint: [List Customers](https://developer.rechargepayments.com/2021-11/customers/customers_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.customers]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>customers[].id</td><td>ID</td></tr><tr><td>customers[].created_at</td><td>CREATED_AT</td></tr><tr><td>customers[].email</td><td>EMAIL</td></tr><tr><td>customers[].external_customer_id</td><td>EXTERNAL_CUSTOMER_ID</td></tr><tr><td>customers[].first_charge_processed_at</td><td>FIRST_CHARGE_PROCESSED_AT</td></tr><tr><td>customers[].first_name</td><td>FIRST_NAME</td></tr><tr><td>customers[].has_payment_method_in_dunning</td><td>HAS_PAYMENT_METHOD_IN_DUNNING</td></tr><tr><td>customers[].has_valid_payment_method</td><td>HAS_VALID_PAYMENT_METHOD</td></tr><tr><td>customers[].hash</td><td>HASH</td></tr><tr><td>customers[].last_name</td><td>LAST_NAME</td></tr><tr><td>customers[].phone</td><td>PHONE</td></tr><tr><td>customers[].subscriptions_active_count</td><td>SUBSCRIPTIONS_ACTIVE_COUNT</td></tr><tr><td>customers[].subscriptions_total_count</td><td>SUBSCRIPTIONS_TOTAL_COUNT</td></tr><tr><td>customers[].tax_exempt</td><td>TAX_EXEMPT</td></tr><tr><td>customers[].updated_at</td><td>UPDATED_AT</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(customers[].id)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Customer Analytics Data UTM Params

* Endpoint: [List Customers](https://developer.rechargepayments.com/2021-11/customers/customers_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.customer_analytics_data_utm_params]`

<table data-full-width="true"><thead><tr><th width="551">JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>customers[].id</td><td>CUSTOMER_ID</td></tr><tr><td>customers[].analytics_data.utm_params[].utm_campaign</td><td>UTM_CAMPAIGN</td></tr><tr><td>customers[].analytics_data.utm_params[].utm_content</td><td>UTM_CONTENT</td></tr><tr><td>customers[].analytics_data.utm_params[].utm_data_source</td><td>UTM_DATA_SOURCE</td></tr><tr><td>customers[].analytics_data.utm_params[].utm_source</td><td>UTM_SOURCE</td></tr><tr><td>customers[].analytics_data.utm_params[].utm_medium</td><td>UTM_MEDIUM</td></tr><tr><td>customers[].analytics_data.utm_params[].utm_term</td><td>UTM_TERM</td></tr><tr><td>customers[].analytics_data.utm_params[].utm_timestamp</td><td>UTM_TIMESTAMP</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>customers[].id<br>customers[].analytics_data.utm_params[].utm_campaign +<br>customers[].analytics_data.utm_params[].utm_content +<br>customers[].analytics_data.utm_params[].utm_data_source +<br>customers[].analytics_data.utm_params[].utm_source +<br>customers[].analytics_data.utm_params[].utm_medium +<br>customers[].analytics_data.utm_params[].utm_term +<br>customers[].analytics_data.utm_params[].utm_timestamp<br>)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Discounts

* Endpoint: [List Discounts](https://developer.rechargepayments.com/2021-11/discounts/discounts_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.discounts]`

<table data-full-width="true"><thead><tr><th width="460">JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>discounts[].id</td><td>ID</td></tr><tr><td>discounts[].code</td><td>CODE</td></tr><tr><td>discounts[].value</td><td>VALUE</td></tr><tr><td>discounts[].status</td><td>STATUS</td></tr><tr><td>discounts[].ends_at</td><td>ENDS_AT</td></tr><tr><td>discounts[].starts_at</td><td>STARTS_AT</td></tr><tr><td>discounts[].created_at</td><td>CREATED_AT</td></tr><tr><td>discounts[].updated_at</td><td>UPDATED_AT</td></tr><tr><td>discounts[].value_type</td><td>VALUE_TYPE</td></tr><tr><td>discounts[].applies_to.resource</td><td>APPLIES_TO_RESOURCE</td></tr><tr><td>discounts[].usage_limits.redemptions</td><td>USAGE_LIMITS_REDEMPTIONS</td></tr><tr><td>discounts[].external_discount_source</td><td>EXTERNAL_DISCOUNT_SOURCE</td></tr><tr><td>discounts[].prerequisite_subtotal_min</td><td>PREREQUISITE_SUBTOTAL_MIN</td></tr><tr><td>discounts[].applies_to.purchase_item_type</td><td>APPLIES_TO_PURCHASE_ITEM_TYPE</td></tr><tr><td>discounts[].channel_settings.api.can_apply</td><td>CHANNEL_SETTINGS_API_CAN_APPLY</td></tr><tr><td>discounts[].external_discount_id.ecommerce</td><td>EXTERNAL_DISCOUNT_ID_ECOMMERCE</td></tr><tr><td>discounts[].channel_settings.checkout_page.can_apply</td><td>CHANNEL_SETTINGS_CHECKOUT_PAGE_CAN_APPLY</td></tr><tr><td>discounts[].channel_settings.merchant_portal.can_apply</td><td>CHANNEL_SETTINGS_MERCHANT_PORTAL_CAN_APPLY</td></tr><tr><td>discounts[].channel_settings.customer_portal.can_apply</td><td>CHANNEL_SETTINGS_CUSTOMER_PORTAL_CAN_APPLY</td></tr><tr><td>discounts[].usage_limits.max_subsequent_redemptions</td><td>USAGE_LIMITS_MAX_SUBSEQUENT_REDEMPTIONS</td></tr><tr><td>discounts[].usage_limits.one_application_per_customer</td><td>USAGE_LIMITS_ONE_APPLICATION_PER_CUSTOMER</td></tr><tr><td>discounts[].usage_limits.first_time_customer_restriction</td><td>USAGE_LIMITS_FIRST_TIME_CUSTOMER_RESTRICTION</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(discounts[].id)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr><tr><td>discounts[].usage_limits.automatic_redemptions_per_customer</td><td>USAGE_LIMITS_AUTOMATIC_REDEMPTIONS_PER_CUSTOMER</td></tr></tbody></table>

### Discount Applies to IDs

* Endpoint: [List Discounts](https://developer.rechargepayments.com/2021-11/discounts/discounts_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.discounts_applies_to_ids]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>discounts[].id</td><td>DISCOUNT_ID</td></tr><tr><td>discounts[].applies_to.ids</td><td>APPLIES_TO_ID</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>discounts[].id +<br>discounts[].applies_to.ids<br>)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Events

* Endpoint: [List Events](https://developer.rechargepayments.com/2021-11/events/events_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.events]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>events[].id</td><td>ID</td></tr><tr><td>events[].object_id</td><td>OBJECT_ID</td></tr><tr><td>events[].customer_id</td><td>CUSTOMER_ID</td></tr><tr><td>events[].created_at</td><td>CREATED_AT</td></tr><tr><td>events[].object_type</td><td>OBJECT_TYPE</td></tr><tr><td>events[].verb</td><td>VERB</td></tr><tr><td>events[].description</td><td>DESCRIPTION</td></tr><tr><td>events[].source.account_id</td><td>SOURCE_ACCOUNT_ID</td></tr><tr><td>events[].source.api_token_id</td><td>SOURCE_API_TOKEN_ID</td></tr><tr><td>events[].source.account_email</td><td>SOURCE_ACCOUNT_EMAIL</td></tr><tr><td>events[].source.origin</td><td>SOURCE_ORIGIN</td></tr><tr><td>events[].source.user_type</td><td>SOURCE_USER_TYPE</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(events[].id)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Event Custom Attributes

* Endpoint: [List Events](https://developer.rechargepayments.com/2021-11/events/events_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.event_custom_attributes]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>events[].id</td><td>EVENT_ID</td></tr><tr><td>events[].custom_attributes[].key</td><td>EVENT_CUSTOM_ATTRIBUTE_KEY</td></tr><tr><td>events[].custom_attributes[].value</td><td>EVENT_CUSTOM_ATTRIBUTE_VALUE</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td></td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr><tr><td>events[].id</td><td>EVENT_ID</td></tr><tr><td>events[].updated_attributes[].attribute</td><td>UPDATED_ATTRIBUTE_ATTRIBUTE</td></tr><tr><td>events[].updated_attributes[].previous_value</td><td>UPDATED_ATTRIBUTE_PREVIOUS_VALUE</td></tr><tr><td>events[].updated_attributes[].value</td><td>UPDATED_ATTRIBUTE_VALUE</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>events[].id +<br>events[].updated_attributes[].attribute<br>)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Onetimes

* Endpoint: [List Onetimes](https://developer.rechargepayments.com/2021-11/onetimes/onetimes_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.onetimes]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>onetimes[].id</td><td>ID</td></tr><tr><td>onetimes[].sku</td><td>SKU</td></tr><tr><td>onetimes[].price</td><td>PRICE</td></tr><tr><td>onetimes[].quantity</td><td>QUANTITY</td></tr><tr><td>onetimes[].address_id</td><td>ADDRESS_ID</td></tr><tr><td>onetimes[].created_at</td><td>CREATED_AT</td></tr><tr><td>onetimes[].updated_at</td><td>UPDATED_AT</td></tr><tr><td>onetimes[].customer_id</td><td>CUSTOMER_ID</td></tr><tr><td>onetimes[].is_cancelled</td><td>IS_CANCELLED</td></tr><tr><td>onetimes[].sku_override</td><td>SKU_OVERRIDE</td></tr><tr><td>onetimes[].product_title</td><td>PRODUCT_TITLE</td></tr><tr><td>onetimes[].variant_title</td><td>VARIANT_TITLE</td></tr><tr><td>onetimes[].presentment_currency</td><td>PRESENTMENT_CURRENCY</td></tr><tr><td>onetimes[].next_charge_scheduled_at</td><td>NEXT_CHARGE_SCHEDULED_AT</td></tr><tr><td>onetimes[].external_variant_id.ecommerce</td><td>EXTERNAL_VARIANT_ID_ECOMMERCE</td></tr><tr><td>onetimes[].external_product_id.ecommerce</td><td>EXTERNAL_PRODUCT_ID_ECOMMERCE</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(onetimes[].id)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Onetime Properties

* Endpoint: [List onetimes](https://developer.rechargepayments.com/2021-11/onetimes/onetimes_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.onetime_properties]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>onetimes[].id</td><td>ONETIME_ID</td></tr><tr><td>onetimes[].properties[].name</td><td>PROPERTIES_NAME</td></tr><tr><td>onetimes[].properties[].value</td><td>PROPERTIES_VALUE</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>onetimes[].id +<br>onetimes[].properties[].name +<br>onetimes[].properties[].value<br>)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Orders

* Endpoint: [List orders](https://developer.rechargepayments.com/2021-11/orders/orders_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.orders]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>orders[].id</td><td>ID</td></tr><tr><td>orders[].address_id</td><td>ADDRESS_ID</td></tr><tr><td>orders[].billing_address.address1</td><td>BILLING_ADDRESS_ADDRESS1</td></tr><tr><td>orders[].billing_address.address2</td><td>BILLING_ADDRESS_ADDRESS2</td></tr><tr><td>orders[].billing_address.city</td><td>BILLING_ADDRESS_CITY</td></tr><tr><td>orders[].billing_address.company</td><td>BILLING_ADDRESS_COMPANY</td></tr><tr><td>orders[].billing_address.country_code</td><td>BILLING_ADDRESS_COUNTRY_CODE</td></tr><tr><td>orders[].billing_address.first_name</td><td>BILLING_ADDRESS_FIRST_NAME</td></tr><tr><td>orders[].billing_address.last_name</td><td>BILLING_ADDRESS_LAST_NAME</td></tr><tr><td>orders[].billing_address.phone</td><td>BILLING_ADDRESS_PHONE</td></tr><tr><td>orders[].billing_address.province</td><td>BILLING_ADDRESS_PROVINCE</td></tr><tr><td>orders[].billing_address.zip</td><td>BILLING_ADDRESS_ZIP</td></tr><tr><td>orders[].charge.external_transaction_id.payment_processor</td><td>CHARGE_EXTERNAL_TRANSACTION_ID_PAYMENT_PROCESSOR</td></tr><tr><td>orders[].charge.id</td><td>CHARGE_ID</td></tr><tr><td>orders[].charge.payment_processor_name</td><td>CHARGE_PAYMENT_PROCESSOR_NAME</td></tr><tr><td>orders[].charge.status</td><td>CHARGE_STATUS</td></tr><tr><td>orders[].client_details.browser_ip</td><td>CLIENT_DETAILS_BROWSER_IP</td></tr><tr><td>orders[].client_details.user_agent</td><td>CLIENT_DETAILS_USER_AGENT</td></tr><tr><td>orders[].created_at</td><td>CREATED_AT</td></tr><tr><td>orders[].currency</td><td>CURRENCY</td></tr><tr><td>orders[].customer.email</td><td>CUSTOMER_EMAIL</td></tr><tr><td>orders[].customer.external_customer_id.ecommerce</td><td>CUSTOMER_EXTERNAL_CUSTOMER_ID_ECOMMERCE</td></tr><tr><td>orders[].customer.hash</td><td>CUSTOMER_HASH</td></tr><tr><td>orders[].customer.id</td><td>CUSTOMER_ID</td></tr><tr><td>orders[].error</td><td>ERROR</td></tr><tr><td>orders[].external_cart_token</td><td>EXTERNAL_CART_TOKEN</td></tr><tr><td>orders[].external_order_id.ecommerce</td><td>EXTERNAL_ORDER_ID_ECOMMERCE</td></tr><tr><td>orders[].external_order_name.ecommerce</td><td>EXTERNAL_ORDER_NAME_ECOMMERCE</td></tr><tr><td>orders[].external_order_number.ecommerce</td><td>EXTERNAL_ORDER_NUMBER_ECOMMERCE</td></tr><tr><td>orders[].is_prepaid</td><td>IS_PREPAID</td></tr><tr><td>orders[].note</td><td>NOTE</td></tr><tr><td>orders[].processed_at</td><td>PROCESSED_AT</td></tr><tr><td>orders[].scheduled_at</td><td>SCHEDULED_AT</td></tr><tr><td>orders[].shipping_address.address1</td><td>SHIPPING_ADDRESS_ADDRESS1</td></tr><tr><td>orders[].shipping_address.address2</td><td>SHIPPING_ADDRESS_ADDRESS2</td></tr><tr><td>orders[].shipping_address.city</td><td>SHIPPING_ADDRESS_CITY</td></tr><tr><td>orders[].shipping_address.company</td><td>SHIPPING_ADDRESS_COMPANY</td></tr><tr><td>orders[].shipping_address.country_code</td><td>SHIPPING_ADDRESS_COUNTRY_CODE</td></tr><tr><td>orders[].shipping_address.first_name</td><td>SHIPPING_ADDRESS_FIRST_NAME</td></tr><tr><td>orders[].shipping_address.last_name</td><td>SHIPPING_ADDRESS_LAST_NAME</td></tr><tr><td>orders[].shipping_address.phone</td><td>SHIPPING_ADDRESS_PHONE</td></tr><tr><td>orders[].shipping_address.province</td><td>SHIPPING_ADDRESS_PROVINCE</td></tr><tr><td>orders[].shipping_address.zip</td><td>SHIPPING_ADDRESS_ZIP</td></tr><tr><td>orders[].status</td><td>STATUS</td></tr><tr><td>orders[].subtotal_price</td><td>SUBTOTAL_PRICE</td></tr><tr><td>orders[].tags</td><td>TAGS</td></tr><tr><td>orders[].taxable</td><td>TAXABLE</td></tr><tr><td>orders[].total_discounts</td><td>TOTAL_DISCOUNTS</td></tr><tr><td>orders[].total_duties</td><td>TOTAL_DUTIES</td></tr><tr><td>orders[].total_line_items_price</td><td>TOTAL_LINE_ITEMS_PRICE</td></tr><tr><td>orders[].total_price</td><td>TOTAL_PRICE</td></tr><tr><td>orders[].total_refunds</td><td>TOTAL_REFUNDS</td></tr><tr><td>orders[].total_tax</td><td>TOTAL_TAX</td></tr><tr><td>orders[].total_weight_grams</td><td>TOTAL_WEIGHT_GRAMS</td></tr><tr><td>orders[].type</td><td>TYPE</td></tr><tr><td>orders[].tax_lines</td><td>TAX_LINES</td></tr><tr><td>orders[].updated_at</td><td>UPDATED_AT</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(orders[].id)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Order Line Items

* Endpoint: [List orders](https://developer.rechargepayments.com/2021-11/orders/orders_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.order_line_items]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>orders[].id</td><td>ORDER_ID</td></tr><tr><td>orders[].line_items[].purchase_item_id</td><td>PURCHASE_ITEM_ID</td></tr><tr><td>orders[].line_items[].external_inventory_policy</td><td>EXTERNAL_INVENTORY_POLICY</td></tr><tr><td>orders[].line_items[].external_product_id.ecommerce</td><td>EXTERNAL_PRODUCT_ID_ECOMMERCE</td></tr><tr><td>orders[].line_items[].external_variant_id.ecommerce</td><td>EXTERNAL_VARIANT_ID_ECOMMERCE</td></tr><tr><td>orders[].line_items[].grams</td><td>GRAMS</td></tr><tr><td>orders[].line_items[].handle</td><td>HANDLE</td></tr><tr><td>orders[].line_items[].original_price</td><td>ORIGINAL_PRICE</td></tr><tr><td>orders[].line_items[].purchase_item_type</td><td>PURCHASE_ITEM_TYPE</td></tr><tr><td>orders[].line_items[].quantity</td><td>QUANTITY</td></tr><tr><td>orders[].line_items[].sku</td><td>SKU</td></tr><tr><td>orders[].line_items[].tax_due</td><td>TAX_DUE</td></tr><tr><td>orders[].line_items[].taxable_amount</td><td>TAXABLE_AMOUNT</td></tr><tr><td>orders[].line_items[].taxable</td><td>TAXABLE</td></tr><tr><td>orders[].line_items[].title</td><td>TITLE</td></tr><tr><td>orders[].line_items[].total_price</td><td>TOTAL_PRICE</td></tr><tr><td>orders[].line_items[].unit_price_includes_tax</td><td>UNIT_PRICE_INCLUDES_TAX</td></tr><tr><td>orders[].line_items[].unit_price</td><td>UNIT_PRICE</td></tr><tr><td>orders[].line_items[].variant_title</td><td>VARIANT_TITLE</td></tr><tr><td>orders[].line_items[].tax_lines</td><td>TAX_LINES</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>orders[].id +<br>orders[].line_items[].purchase_item_id +<br>orders[].line_items[].sku +<br>orders[].line_items[].title +<br>orders[].line_items[].variant_title<br>)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Order Line Item Properties

* Endpoint: [List orders](https://developer.rechargepayments.com/2021-11/orders/orders_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.order_line_item_properties]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>orders[].id</td><td>ORDER_ID</td></tr><tr><td>orders[].line_items[].purchase_item_id</td><td>PURCHASE_ITEM_ID</td></tr><tr><td>orders[].line_items[].sku</td><td>SKU</td></tr><tr><td>orders[].line_items[].title</td><td>TITLE</td></tr><tr><td>orders[].line_items[].variant_title</td><td>VARIANT_TITLE</td></tr><tr><td>orders[].line_items[].properties[].name</td><td>NAME</td></tr><tr><td>orders[].line_items[].properties[].value</td><td>VALUE</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>orders[].id +<br>orders[].line_items[].purchase_item_id +<br>orders[].line_items[].sku +<br>orders[].line_items[].title +<br>orders[].line_items[].variant_title +<br>orders[].line_items[].properties[].name +<br>orders[].line_items[].properties[].value<br>)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Order Shipping Lines

* Endpoint: [List Orders](https://developer.rechargepayments.com/2021-11/orders/orders_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.order_shipping_lines]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>orders[].id</td><td>ORDER_ID</td></tr><tr><td>orders[].shipping_lines[].code</td><td>CODE</td></tr><tr><td>orders[].shipping_lines[].price</td><td>PRICE</td></tr><tr><td>orders[].shipping_lines[].title</td><td>TITLE</td></tr><tr><td>orders[].shipping_lines[].source</td><td>SOURCE</td></tr><tr><td>orders[].shipping_lines[].taxable</td><td>TAXABLE</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>orders[].id +<br>orders[].shipping_lines[].code +<br>orders[].shipping_lines[].price +<br>orders[].shipping_lines[].title<br>)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Payment Methods

* Endpoint: [List Payment Methods](https://developer.rechargepayments.com/2021-11/payment_methods/payment_methods_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.payment_methods]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>payment_methods[].id</td><td>ID</td></tr><tr><td>payment_methods[].default</td><td>DEFAULT</td></tr><tr><td>payment_methods[].created_at</td><td>CREATED_AT</td></tr><tr><td>payment_methods[].updated_at</td><td>UPDATED_AT</td></tr><tr><td>payment_methods[].customer_id</td><td>CUSTOMER_ID</td></tr><tr><td>payment_methods[].payment_type</td><td>PAYMENT_TYPE</td></tr><tr><td>payment_methods[].processor_name</td><td>PROCESSOR_NAME</td></tr><tr><td>payment_methods[].billing_address.zip</td><td>BILLING_ADDRESS_ZIP</td></tr><tr><td>payment_methods[].billing_address.city</td><td>BILLING_ADDRESS_CITY</td></tr><tr><td>payment_methods[].billing_address.name</td><td>BILLING_ADDRESS_NAME</td></tr><tr><td>payment_methods[].billing_address.phone</td><td>BILLING_ADDRESS_PHONE</td></tr><tr><td>payment_methods[].billing_address.address1</td><td>BILLING_ADDRESS_ADDRESS1</td></tr><tr><td>payment_methods[].billing_address.address2</td><td>BILLING_ADDRESS_ADDRESS2</td></tr><tr><td>payment_methods[].billing_address.province</td><td>BILLING_ADDRESS_PROVINCE</td></tr><tr><td>payment_methods[].billing_address.company_name</td><td>BILLING_ADDRESS_COMPANY_NAME</td></tr><tr><td>payment_methods[].billing_address.country_code</td><td>BILLING_ADDRESS_COUNTRY_CODE</td></tr><tr><td>payment_methods[].processor_customer_token</td><td>PROCESSOR_CUSTOMER_TOKEN</td></tr><tr><td>payment_methods[].processor_payment_method_token</td><td>PROCESSOR_PAYMENT_METHOD_TOKEN</td></tr><tr><td>payment_methods[].payment_details.brand</td><td>PAYMENT_METHOD_DETAIL_BRAND</td></tr><tr><td>payment_methods[].payment_details.last4</td><td>PAYMENT_METHOD_DETAIL_LAST4</td></tr><tr><td>payment_methods[].payment_details.exp_year</td><td>PAYMENT_METHOD_DETAIL_EXP_YEAR</td></tr><tr><td>payment_methods[].payment_details.exp_month</td><td>PAYMENT_METHOD_DETAIL_EXP_MONTH</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(payment_methods[].id)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Subscriptions

* Endpoint: [List Subscriptions](https://developer.rechargepayments.com/2021-11/subscriptions/subscriptions_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.subscriptions]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>subscriptions[].id</td><td>ID</td></tr><tr><td>subscriptions[].address_id</td><td>ADDRESS_ID</td></tr><tr><td>subscriptions[].customer_id</td><td>CUSTOMER_ID</td></tr><tr><td>subscriptions[].cancellation_reason</td><td>CANCELLATION_REASON</td></tr><tr><td>subscriptions[].cancellation_reason_comments</td><td>CANCELLATION_REASON_COMMENTS</td></tr><tr><td>subscriptions[].cancelled_at</td><td>CANCELLED_AT</td></tr><tr><td>subscriptions[].charge_interval_frequency</td><td>CHARGE_INTERVAL_FREQUENCY</td></tr><tr><td>subscriptions[].created_at</td><td>CREATED_AT</td></tr><tr><td>subscriptions[].expire_after_specific_number_of_charges</td><td>EXPIRE_AFTER_SPECIFIC_NUMBER_OF_CHARGES</td></tr><tr><td>subscriptions[].external_product_id.ecommerce</td><td>EXTERNAL_PRODUCT_ID_ECOMMERCE</td></tr><tr><td>subscriptions[].external_variant_id.ecommerce</td><td>EXTERNAL_VARIANT_ID_ECOMMERCE</td></tr><tr><td>subscriptions[].has_queued_charges</td><td>HAS_QUEUED_CHARGES</td></tr><tr><td>subscriptions[].is_prepaid</td><td>IS_PREPAID</td></tr><tr><td>subscriptions[].is_skippable</td><td>IS_SKIPPABLE</td></tr><tr><td>subscriptions[].is_swappable</td><td>IS_SWAPPABLE</td></tr><tr><td>subscriptions[].max_retries_reached</td><td>MAX_RETRIES_REACHED</td></tr><tr><td>subscriptions[].next_charge_scheduled_at</td><td>NEXT_CHARGE_SCHEDULED_AT</td></tr><tr><td>subscriptions[].order_day_of_month</td><td>ORDER_DAY_OF_MONTH</td></tr><tr><td>subscriptions[].order_day_of_week</td><td>ORDER_DAY_OF_WEEK</td></tr><tr><td>subscriptions[].order_interval_frequency</td><td>ORDER_INTERVAL_FREQUENCY</td></tr><tr><td>subscriptions[].order_interval_unit</td><td>ORDER_INTERVAL_UNIT</td></tr><tr><td>subscriptions[].presentment_currency</td><td>PRESENTMENT_CURRENCY</td></tr><tr><td>subscriptions[].price</td><td>PRICE</td></tr><tr><td>subscriptions[].product_title</td><td>PRODUCT_TITLE</td></tr><tr><td>subscriptions[].quantity</td><td>QUANTITY</td></tr><tr><td>subscriptions[].sku</td><td>SKU</td></tr><tr><td>subscriptions[].sku_override</td><td>SKU_OVERRIDE</td></tr><tr><td>subscriptions[].status</td><td>STATUS</td></tr><tr><td>subscriptions[].updated_at</td><td>UPDATED_AT</td></tr><tr><td>subscriptions[].variant_title</td><td>VARIANT_TITLE</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(subscriptions[].id)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Subscription Analytics Data UTM Params

* Endpoint: [List Subscriptions](https://developer.rechargepayments.com/2021-11/subscriptions/subscriptions_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.subscription_analytics_data_utm_params]`

<table data-full-width="true"><thead><tr><th width="581">JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>subscriptions[].id</td><td>SUBSCRIPTION_ID</td></tr><tr><td>subscriptions[].analytics_data.utm_params[].utm_campaign</td><td>UTM_CAMPAIGN</td></tr><tr><td>subscriptions[].analytics_data.utm_params[].utm_content</td><td>UTM_CONTENT</td></tr><tr><td>subscriptions[].analytics_data.utm_params[].utm_data_source</td><td>UTM_DATA_SOURCE</td></tr><tr><td>subscriptions[].analytics_data.utm_params[].utm_source</td><td>UTM_SOURCE</td></tr><tr><td>subscriptions[].analytics_data.utm_params[].utm_medium</td><td>UTM_MEDIUM</td></tr><tr><td>subscriptions[].analytics_data.utm_params[].utm_term</td><td>UTM_TERM</td></tr><tr><td>subscriptions[].analytics_data.utm_params[].utm_timestamp</td><td>UTM_TIMESTAMP</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>subscriptions[].id +<br>subscriptions[].analytics_data.utm_params[].utm_campaign +<br>subscriptions[].analytics_data.utm_params[].utm_content +<br>subscriptions[].analytics_data.utm_params[].utm_data_source +<br>subscriptions[].analytics_data.utm_params[].utm_source +<br>subscriptions[].analytics_data.utm_params[].utm_medium +<br>subscriptions[].analytics_data.utm_params[].utm_term +<br>subscriptions[].analytics_data.utm_params[].utm_timestamp<br>)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>

### Subscription Properties

* Endpoint: [List Subscriptions](https://developer.rechargepayments.com/2021-11/subscriptions/subscriptions_list)
* Update Method: UPSERT
* Table Name: `[recharge_2021_11.subscription_properties]`

<table data-full-width="true"><thead><tr><th>JSON Element</th><th>Database Column</th></tr></thead><tbody><tr><td>subscriptions[].id</td><td>SUBSCRIPTION_ID</td></tr><tr><td>subscriptions[].properties[].name</td><td>NAME</td></tr><tr><td>subscriptions[].properties[].value</td><td>VALUE</td></tr><tr><td>Daasity: shop id</td><td>__SOURCE_ID</td></tr><tr><td>Daasity: account id</td><td>_ACCOUNT_ID</td></tr><tr><td>MD5(<br>subscriptions[].id +<br>subscriptions[].properties[].name +<br>subscriptions[].properties[].value<br>)</td><td>__SYNC_KEY</td></tr><tr><td>Daasity: timestamp when loaded into DB</td><td>__SYNCED_AT</td></tr></tbody></table>


---

# 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://help.daasity.com/core-concepts/data-integrations/setup-guides/digital-integrations/recharge/integration-specifications.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.