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 [e-mail] 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:

• List Addresses

• List Bundle Selections

• List Charges

• List Customers

• List Discounts

• List Events

• List Onetimes

• List Orders

• List Payment Methods

• List Subscriptions

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

• Address Discounts

• Address Order Attributes

• Address Shipping Lines Conserved

• Address Shipping Lines Override

• Bundle Selections

• Bundle Selection Items

• Charges

• Charge Analytics Data UTM Params

• Charge Discount Codes

• Charge Line Items

• Charge Line Item Properties

• Charge Order Attributes

• Charge Shipping Lines

• Customers

• Customer Analytics Data UTM Params

• Discounts

• Discount Applies to IDs

• Events

• Event Custom Attributes

• Onetimes

• Onetime Properties

• Orders

• Order Line Items

• Order Line Item Properties

• Order Shipping Lines

• Payment Methods

• Subscriptions

• Subscription Analytics Data UTM Params

• Subscription Properties

Addresses

• Endpoint: List Addresses

• Update Method: UPSERT

• Table Name: [recharge_2021_11.addresses]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
	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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
customers[].id	ID
customers[].created_at	CREATED_AT
customers[].email	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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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]

JSON Element	Database Column
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