Integration Specifications (2021-11 Beta)
Enabling 2021-11 Beta extractors
The 2021-11 Beta is part of the standard Recharge integration, but needs to be enabled manually.
To get the 2021-11 Beta, please email support@daasity.com and request to have it enabled for your account.
Once enabled, you will get all of the new tables listed below.
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. The following endpoints are used by Daasity to replicate data from Recharge:
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
Endpoint: List Addresses
Update Method: UPSERT
Table Name:
[recharge_2021_11.addresses]
addresses[].id
ID
addresses[].customer_id
CUSTOMER_ID
addresses[].payment_method_id
PAYMENT_METHOD_ID
addresses[].address1
ADDRESS1
addresses[].address2
ADDRESS2
addresses[].city
CITY
addresses[].company
COMPANY
addresses[].country_code
COUNTRY_CODE
addresses[].created_at
CREATED_AT
addresses[].first_name
FIRST_NAME
addresses[].last_name
LAST_NAME
addresses[].order_note
ORDER_NOTE
addresses[].phone
PHONE
addresses[].presentment_currency
PRESENTMENT_CURRENCY
addresses[].province
PROVINCE
addresses[].updated_at
UPDATED_AT
addresses[].zip
ZIP
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5(addresses[].id)
__SYNC_KEY
Daasity: timestamp when loaded into DB
__SYNCED_AT
Address Discounts
Endpoint: List Addresses
Update Method: UPSERT
Table Name:
[recharge_2021_11.address_discounts]
addresses[].id
ADDRESS_ID
addresses[].discounts[].id
DISCOUNT_ID
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5( addresses[].id + discounts[].id )
__SYNC_KEY
Daasity: timestamp when loaded into DB
__SYNCED_AT
Address Order Attributes
Endpoint: List Addresses
Update Method: UPSERT
Table Name:
[recharge_2021_11.address_order_attributes]
addresses[].id
ADDRESS_ID
addresses[].order_attributes[].name
NAME
addresses[].order_attributes[].value
VALUE
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5( addresses[].id + addresses[].order_attributes[].name + addresses[].order_attributes[].value )
__SYNC_KEY
Address Shipping Lines Conserved
Endpoint: List Addresses
Update Method: UPSERT
Table Name:
[recharge_2021_11.address_shipping_lines_conserved]
addresses[].id
ADDRESS_ID
addresses[].shipping_lines_conserved[].code
CODE
addresses[].shipping_lines_conserved[].price
PRICE
addresses[].shipping_lines_conserved[].title
TITLE
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5( addresses[].id + addresses[].shipping_lines_conserved[].code + addresses[].shipping_lines_conserved[].title )
__SYNC_KEY
Address Shipping Lines Override
Endpoint: List Addresses
Update Method: UPSERT
Table Name:
[recharge_2021_11.address_shipping_lines_override]
ADDRESS_ID
addresses[].shipping_lines_override[].code
CODE
addresses[].shipping_lines_override[].price
PRICE
addresses[].shipping_lines_override[].title
TITLE
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5( addresses[].id + addresses[].shipping_lines_override[].code + addresses[].shipping_lines_override[].title )
__SYNC_KEY
Daasity: timestamp when loaded into DB
__SYNCED_AT
Bundle Selections
Endpoint: List Bundle Selections
Update Method: UPSERT
Table Name:
[recharge_2021_11.bundle_selections]
bundle_selections[].id
ID
bundle_selections[].bundle_variant
BUNDLE_VARIANT_ID
bundle_selections[].charge_id
CHARGE_ID
bundle_selections[].order_id
ORDER_ID
bundle_selections[].purchase_item_id
PURCHASE_ITEM_ID
bundle_selections[].created_at
CREATED_AT
bundle_selections[].external_product_id
EXTERNAL_PRODUCT_ID
bundle_selections[].external_variant_id
EXTERNAL_VARIANT_ID
bundle_selections[].items_count
ITEMS_COUNT
bundle_selections[].updated_at
UPDATED_AT
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5(bundle_selections[].id)
__SYNC_KEY
Daasity: timestamp when loaded into DB
__SYNCED_AT
Bundle Selection Items
Endpoint: List Bundle Selections
Update Method: UPSERT
Table Name:
[recharge_2021_11.bundle_selection_items]
bundle_selections[].id
BUNDLE_ID
bundle_selections[].items[].id
ITEM_ID
bundle_selections[].items[].collection_id
COLLECTION_ID
bundle_selections[].items[].collection_source
COLLECTION_SOURCE
bundle_selections[].items[].created_at
CREATED_AT
bundle_selections[].items[].external_product_id
EXTERNAL_PRODUCT_ID
bundle_selections[].items[].external_variant_id
EXTERNAL_VARIANT_ID
bundle_selections[].items[].price
PRICE
bundle_selections[].items[].quantity
QUANTITY
bundle_selections[].items[].updated_at
UPDATED_AT
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5( bundle_selections[].id + bundle_selections[].items[].id )
__SYNC_KEY
Daasity: timestamp when loaded into DB
__SYNCED_AT
Charges
Endpoint: List Charges
Update Method: UPSERT
Table Name:
[recharge_2021_11.charges]
charges[].id
ID
charges[].note
NOTE
charges[].tags
TAGS
charges[].type
TYPE
charges[].error
ERROR
charges[].status
STATUS
charges[].currency
CURRENCY
charges[].total_tax
TOTAL_TAX
charges[].address_id
ADDRESS_ID
charges[].error_type
ERROR_TYPE
charges[].created_at
CREATED_AT
charges[].updated_at
UPDATED_AT
charges[].total_price
TOTAL_PRICE
charges[].scheduled_at
SCHEDULED_AT
charges[].total_refunds
TOTAL_REFUNDS
charges[].tax_lines
TAX_LINES
charges[].payment_processor
PAYMENT_PROCESSOR
charges[].subtotal_price
SUBTOTAL_PRICE
charges[].taxes_included
TAXES_INCLUDED
charges[].total_discounts
TOTAL_DISCOUNTS
charges[].customer.id
CUSTOMER_ID
charges[].customer.hash
CUSTOMER_HASH
charges[].customer.email
CUSTOMER_EMAIL
charges[].customer.external_customer_id.ecommerce
CUSTOMER_EXTERNAL_CUSTOMER_ID_ECOMMERCE
charges[].total_weight_grams
TOTAL_WEIGHT_GRAMS
charges[].total_line_items_price
TOTAL_LINE_ITEMS_PRICE
charges[].has_uncommitted_changes
HAS_UNCOMMITTED_CHANGES
charges[].client_details.browser_ip
CLIENT_DETAILS_BROWSER_IP
charges[].client_details.user_agent
CLIENT_DETAILS_USER_AGENT
charges[].external_order_id.ecommerce
EXTERNAL_ORDER_ID_ECOMMERCE
charges[].external_transaction_id.payment_processor
EXTERNAL_TRANSACTION_ID_PAYMENT_PROCESSOR
charges[].shipping_address.zip
SHIPPING_ADDRESS_ZIP
charges[].shipping_address.city
SHIPPING_ADDRESS_CITY
charges[].shipping_address.phone
SHIPPING_ADDRESS_PHONE
charges[].shipping_address.company
SHIPPING_ADDRESS_COMPANY
charges[].shipping_address.country
SHIPPING_ADDRESS_COUNTRY
charges[].shipping_address.address1
SHIPPING_ADDRESS_ADDRESS1
charges[].shipping_address.address2
SHIPPING_ADDRESS_ADDRESS2
charges[].shipping_address.province
SHIPPING_ADDRESS_PROVINCE
charges[].shipping_address.last_name
SHIPPING_ADDRESS_LAST_NAME
charges[].shipping_address.first_name
SHIPPING_ADDRESS_FIRST_NAME
charges[].billing_address.zip
BILLING_ADDRESS_ZIP
charges[].billing_address.city
BILLING_ADDRESS_CITY
charges[].billing_address.phone
BILLING_ADDRESS_PHONE
charges[].billing_address.company
BILLING_ADDRESS_COMPANY
charges[].billing_address.address1
BILLING_ADDRESS_ADDRESS1
charges[].billing_address.address2
BILLING_ADDRESS_ADDRESS2
charges[].billing_address.province
BILLING_ADDRESS_PROVINCE
charges[].billing_address.last_name
BILLING_ADDRESS_LAST_NAME
charges[].billing_address.first_name
BILLING_ADDRESS_FIRST_NAME
charges[].billing_address.country_code
BILLING_ADDRESS_COUNTRY_CODE
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5(charges[].id)
__SYNC_KEY
Daasity: timestamp when loaded into DB
__SYNCED_AT
Charge Analytics Data UTM Params
Endpoint: List Charges
Update Method: UPSERT
Table Name:
[recharge_2021_11.charge_analytics_data_utm_params]
charges[].id
CHARGE_ID
charges[].analytics_data.utm_params[].utm_term
UTM_TERM
charges[].analytics_data.utm_params[].utm_medium
UTM_MEDIUM
charges[].analytics_data.utm_params[].utm_source
UTM_SOURCE
charges[].analytics_data.utm_params[].utm_content
UTM_CONTENT
charges[].analytics_data.utm_params[].utm_campaign
UTM_CAMPAIGN
charges[].analytics_data.utm_params[].utm_time_stamp
UTM_TIME_STAMP
charges[].analytics_data.utm_params[].utm_data_source
UTM_DATA_SOURCE
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5( charges[].id + charges[].analytics_data.utm_params[].utm_term + charges[].analytics_data.utm_params[].utm_medium + charges[].analytics_data.utm_params[].utm_source + charges[].analytics_data.utm_params[].utm_content + charges[].analytics_data.utm_params[].utm_campaign + charges[].analytics_data.utm_params[].utm_time_stamp + charges[].analytics_data.utm_params[].utm_data_source )
__SYNC_KEY
Daasity: timestamp when loaded into DB
__SYNCED_AT
Charge Discount Codes
Endpoint: List Charges
Update Method: UPSERT
Table Name:
[recharge_2021_11.charge_discount_codes]
charges[].id
CHARGE_ID
charges[].discounts[].id
DISCOUNT_ID
charges[].discounts[].code
DISCOUNT_CODE
charges[].discounts[].value
DISCOUNT_VALUE
charges[].discounts[].value_type
DISCOUNT_VALUE_TYPE
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5( charges[].id + charges[].discounts[].id )
__SYNC_KEY
Daasity: timestamp when loaded into DB
__SYNCED_AT
Charge Line Items
Endpoint: List Charges
Update Method: UPSERT
Table Name:
[recharge_2021_11.charge_line_items]
charges[].id
CHARGE_ID
charges[].line_items[].sku
LINE_ITEM_SKU
charges[].line_items[].grams
LINE_ITEM_GRAMS
charges[].line_items[].title
LINE_ITEM_TITLE
charges[].line_items[].taxable
LINE_ITEM_TAXABLE
charges[].line_items[].tax_due
LINE_ITEM_TAX_DUE
charges[].line_items[].quantity
LINE_ITEM_QUANTITY
charges[].line_items[].unit_price
LINE_ITEM_UNIT_PRICE
charges[].line_items[].total_price
LINE_ITEM_TOTAL_PRICE
charges[].line_items[].variant_title
LINE_ITEM_VARIANT_TITLE
charges[].line_items[].original_price
LINE_ITEM_ORIGINAL_PRICE
charges[].line_items[].taxable_amount
LINE_ITEM_TAXABLE_AMOUNT
charges[].line_items[].purchase_item_id
LINE_ITEM_PURCHASE_ITEM_ID
charges[].line_items[].purchase_item_type
LINE_ITEM_PURCHASE_ITEM_TYPE
charges[].line_items[].external_variant_id.ecommerce
LINE_ITEM_EXTERNAL_VARIANT_ID_ECOMMERCE
charges[].line_items[].external_product_id.ecommerce
LINE_ITEM_EXTERNAL_PRODUCT_ID_ECOMMERCE
charges[].line_items[].tax_lines
LINE_ITEM_TAX_LINES
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5( charges[].id + charges[].line_items[].purchase_item_id + charges[].line_items[].sku + charges[].line_items[].title + charges[].line_items[].variant_title )
__SYNC_KEY
Daasity: timestamp when loaded into DB
__SYNCED_AT
Charge Line Item Properties
Endpoint: List Charges
Update Method: UPSERT
Table Name:
[recharge_2021_11.charge_line_item_properties]
charges[].id
CHARGE_ID
charges[].line_items[].purchase_item_id
LINE_ITEM_PURCHASE_ITEM_ID
charges[].line_items[].sku
LINE_ITEM_SKU
charges[].line_items[].title
LINE_ITEM_TITLE
charges[].line_items[].variant_title
LINE_ITEM_VARIANT_TITLE
charges[].line_items[].properties[].name
LINE_ITEM_PROPERTY_NAME
charges[].line_items[].properties[].value
LINE_ITEM_PROPERTY_VALUE
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5( charges[].id + charges[].line_items[].purchase_item_id + charges[].line_items[].sku + charges[].line_items[].title + charges[].line_items[].variant_title + charges[].line_items[].properties[].name + charges[].line_items[].properties[].value )
__SYNC_KEY
Daasity: timestamp when loaded into DB
__SYNCED_AT
Charge Order Attributes
Endpoint: List Charges
Update Method: UPSERT
Table Name:
[recharge_2021_11.charge_order_attributes]
charges[].id
CHARGE_ID
charges[].order_attributes[].name
ORDER_ATTRIBUTES_NAME
charges[].order_attributes[].value
ORDER_ATTRIBUTES_VALUE
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5( charges[].id + charges[].order_attributes[].name + charges[].order_attributes[].value )
__SYNC_KEY
Daasity: timestamp when loaded into DB
__SYNCED_AT
Charge Shipping Lines
Endpoint: List Charges
Update Method: UPSERT
Table Name:
[recharge_2021_11.charge_shipping_lines]
charges[].id
CHARGE_ID
charges[].shipping_lines[].code
SHIPPING_LINE_CODE
charges[].shipping_lines[].price
SHIPPING_LINE_PRICE
charges[].shipping_lines[].title
SHIPPING_LINE_TITLE
charges[].shipping_lines[].taxable
SHIPPING_LINE_TAXABLE
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5( charges[].id + charges[].shipping_lines[].code + charges[].shipping_lines[].price + charges[].shipping_lines[].title + charges[].shipping_lines[].taxable )
__SYNC_KEY
Daasity: timestamp when loaded into DB
__SYNCED_AT
Customers
Endpoint: List Customers
Update Method: UPSERT
Table Name:
[recharge_2021_11.customers]
customers[].id
ID
customers[].created_at
CREATED_AT
customers[].email
customers[].external_customer_id
EXTERNAL_CUSTOMER_ID
customers[].first_charge_processed_at
FIRST_CHARGE_PROCESSED_AT
customers[].first_name
FIRST_NAME
customers[].has_payment_method_in_dunning
HAS_PAYMENT_METHOD_IN_DUNNING
customers[].has_valid_payment_method
HAS_VALID_PAYMENT_METHOD
customers[].hash
HASH
customers[].last_name
LAST_NAME
customers[].phone
PHONE
customers[].subscriptions_active_count
SUBSCRIPTIONS_ACTIVE_COUNT
customers[].subscriptions_total_count
SUBSCRIPTIONS_TOTAL_COUNT
customers[].tax_exempt
TAX_EXEMPT
customers[].updated_at
UPDATED_AT
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5(customers[].id)
__SYNC_KEY
Daasity: timestamp when loaded into DB
__SYNCED_AT
Customer Analytics Data UTM Params
Endpoint: List Customers
Update Method: UPSERT
Table Name:
[recharge_2021_11.customer_analytics_data_utm_params]
customers[].id
CUSTOMER_ID
customers[].analytics_data.utm_params[].utm_campaign
UTM_CAMPAIGN
customers[].analytics_data.utm_params[].utm_content
UTM_CONTENT
customers[].analytics_data.utm_params[].utm_data_source
UTM_DATA_SOURCE
customers[].analytics_data.utm_params[].utm_source
UTM_SOURCE
customers[].analytics_data.utm_params[].utm_medium
UTM_MEDIUM
customers[].analytics_data.utm_params[].utm_term
UTM_TERM
customers[].analytics_data.utm_params[].utm_timestamp
UTM_TIMESTAMP
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5( customers[].id customers[].analytics_data.utm_params[].utm_campaign + customers[].analytics_data.utm_params[].utm_content + customers[].analytics_data.utm_params[].utm_data_source + customers[].analytics_data.utm_params[].utm_source + customers[].analytics_data.utm_params[].utm_medium + customers[].analytics_data.utm_params[].utm_term + customers[].analytics_data.utm_params[].utm_timestamp )
__SYNC_KEY
Daasity: timestamp when loaded into DB
__SYNCED_AT
Discounts
Endpoint: List Discounts
Update Method: UPSERT
Table Name:
[recharge_2021_11.discounts]
discounts[].id
ID
discounts[].code
CODE
discounts[].value
VALUE
discounts[].status
STATUS
discounts[].ends_at
ENDS_AT
discounts[].starts_at
STARTS_AT
discounts[].created_at
CREATED_AT
discounts[].updated_at
UPDATED_AT
discounts[].value_type
VALUE_TYPE
discounts[].applies_to.resource
APPLIES_TO_RESOURCE
discounts[].usage_limits.redemptions
USAGE_LIMITS_REDEMPTIONS
discounts[].external_discount_source
EXTERNAL_DISCOUNT_SOURCE
discounts[].prerequisite_subtotal_min
PREREQUISITE_SUBTOTAL_MIN
discounts[].applies_to.purchase_item_type
APPLIES_TO_PURCHASE_ITEM_TYPE
discounts[].channel_settings.api.can_apply
CHANNEL_SETTINGS_API_CAN_APPLY
discounts[].external_discount_id.ecommerce
EXTERNAL_DISCOUNT_ID_ECOMMERCE
discounts[].channel_settings.checkout_page.can_apply
CHANNEL_SETTINGS_CHECKOUT_PAGE_CAN_APPLY
discounts[].channel_settings.merchant_portal.can_apply
CHANNEL_SETTINGS_MERCHANT_PORTAL_CAN_APPLY
discounts[].channel_settings.customer_portal.can_apply
CHANNEL_SETTINGS_CUSTOMER_PORTAL_CAN_APPLY
discounts[].usage_limits.max_subsequent_redemptions
USAGE_LIMITS_MAX_SUBSEQUENT_REDEMPTIONS
discounts[].usage_limits.one_application_per_customer
USAGE_LIMITS_ONE_APPLICATION_PER_CUSTOMER
discounts[].usage_limits.first_time_customer_restriction
USAGE_LIMITS_FIRST_TIME_CUSTOMER_RESTRICTION
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5(discounts[].id)
__SYNC_KEY
Daasity: timestamp when loaded into DB
__SYNCED_AT
discounts[].usage_limits.automatic_redemptions_per_customer
USAGE_LIMITS_AUTOMATIC_REDEMPTIONS_PER_CUSTOMER
Discount Applies to IDs
Endpoint: List Discounts
Update Method: UPSERT
Table Name:
[recharge_2021_11.discounts_applies_to_ids]
discounts[].id
DISCOUNT_ID
discounts[].applies_to.ids
APPLIES_TO_ID
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5( discounts[].id + discounts[].applies_to.ids )
__SYNC_KEY
Daasity: timestamp when loaded into DB
__SYNCED_AT
Events
Endpoint: List Events
Update Method: UPSERT
Table Name:
[recharge_2021_11.events]
events[].id
ID
events[].object_id
OBJECT_ID
events[].customer_id
CUSTOMER_ID
events[].created_at
CREATED_AT
events[].object_type
OBJECT_TYPE
events[].verb
VERB
events[].description
DESCRIPTION
events[].source.account_id
SOURCE_ACCOUNT_ID
events[].source.api_token_id
SOURCE_API_TOKEN_ID
events[].source.account_email
SOURCE_ACCOUNT_EMAIL
events[].source.origin
SOURCE_ORIGIN
events[].source.user_type
SOURCE_USER_TYPE
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID
MD5(events[].id)
__SYNC_KEY
Daasity: timestamp when loaded into DB
__SYNCED_AT
Event Custom Attributes
Endpoint: List Events
Update Method: UPSERT
Table Name:
[recharge_2021_11.event_custom_attributes]
events[].id
EVENT_ID
events[].custom_attributes[].key
EVENT_CUSTOM_ATTRIBUTE_KEY
events[].custom_attributes[].value
EVENT_CUSTOM_ATTRIBUTE_VALUE
Daasity: shop id
__SOURCE_ID
Daasity: account id
_ACCOUNT_ID