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]
| 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 | |
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 |
__SYNC_KEY | |
Daasity: timestamp when loaded into DB | __SYNCED_AT |
events[].id | EVENT_ID |
events[].updated_attributes[].attribute | UPDATED_ATTRIBUTE_ATTRIBUTE |
events[].updated_attributes[].previous_value | UPDATED_ATTRIBUTE_PREVIOUS_VALUE |
events[].updated_attributes[].value | UPDATED_ATTRIBUTE_VALUE |
Daasity: shop id | __SOURCE_ID |
Daasity: account id | _ACCOUNT_ID |
MD5( events[].id + events[].updated_attributes[].attribute ) | __SYNC_KEY |
Daasity: timestamp when loaded into DB | __SYNCED_AT |
Onetimes
Endpoint: List Onetimes
Update Method: UPSERT
Table Name:
[recharge_2021_11.onetimes]
| JSON Element | Database Column |
|---|---|
onetimes[].id | ID |
onetimes[].sku | SKU |
onetimes[].price | PRICE |
onetimes[].quantity | QUANTITY |
onetimes[].address_id | ADDRESS_ID |
onetimes[].created_at | CREATED_AT |
onetimes[].updated_at | UPDATED_AT |
onetimes[].customer_id | CUSTOMER_ID |
onetimes[].is_cancelled | IS_CANCELLED |
onetimes[].sku_override | SKU_OVERRIDE |
onetimes[].product_title | PRODUCT_TITLE |
onetimes[].variant_title | VARIANT_TITLE |
onetimes[].presentment_currency | PRESENTMENT_CURRENCY |
onetimes[].next_charge_scheduled_at | NEXT_CHARGE_SCHEDULED_AT |
onetimes[].external_variant_id.ecommerce | EXTERNAL_VARIANT_ID_ECOMMERCE |
onetimes[].external_product_id.ecommerce | EXTERNAL_PRODUCT_ID_ECOMMERCE |
Daasity: shop id | __SOURCE_ID |
Daasity: account id | _ACCOUNT_ID |
MD5(onetimes[].id) | __SYNC_KEY |
Daasity: timestamp when loaded into DB | __SYNCED_AT |
Onetime Properties
Endpoint: List onetimes
Update Method: UPSERT
Table Name:
[recharge_2021_11.onetime_properties]
| JSON Element | Database Column |
|---|---|
onetimes[].id | ONETIME_ID |
onetimes[].properties[].name | PROPERTIES_NAME |
onetimes[].properties[].value | PROPERTIES_VALUE |
Daasity: shop id | __SOURCE_ID |
Daasity: account id | _ACCOUNT_ID |
MD5( onetimes[].id + onetimes[].properties[].name + onetimes[].properties[].value ) | __SYNC_KEY |
Daasity: timestamp when loaded into DB | __SYNCED_AT |
Orders
Endpoint: List orders
Update Method: UPSERT
Table Name:
[recharge_2021_11.orders]
| JSON Element | Database Column |
|---|---|
orders[].id | ID |
orders[].address_id | ADDRESS_ID |
orders[].billing_address.address1 | BILLING_ADDRESS_ADDRESS1 |
orders[].billing_address.address2 | BILLING_ADDRESS_ADDRESS2 |
orders[].billing_address.city | BILLING_ADDRESS_CITY |
orders[].billing_address.company | BILLING_ADDRESS_COMPANY |
orders[].billing_address.country_code | BILLING_ADDRESS_COUNTRY_CODE |
orders[].billing_address.first_name | BILLING_ADDRESS_FIRST_NAME |
orders[].billing_address.last_name | BILLING_ADDRESS_LAST_NAME |
orders[].billing_address.phone | BILLING_ADDRESS_PHONE |
orders[].billing_address.province | BILLING_ADDRESS_PROVINCE |
orders[].billing_address.zip | BILLING_ADDRESS_ZIP |
orders[].charge.external_transaction_id.payment_processor | CHARGE_EXTERNAL_TRANSACTION_ID_PAYMENT_PROCESSOR |
orders[].charge.id | CHARGE_ID |
orders[].charge.payment_processor_name | CHARGE_PAYMENT_PROCESSOR_NAME |
orders[].charge.status | CHARGE_STATUS |
orders[].client_details.browser_ip | CLIENT_DETAILS_BROWSER_IP |
orders[].client_details.user_agent | CLIENT_DETAILS_USER_AGENT |
orders[].created_at | CREATED_AT |
orders[].currency | CURRENCY |
orders[].customer.email | CUSTOMER_EMAIL |
orders[].customer.external_customer_id.ecommerce | CUSTOMER_EXTERNAL_CUSTOMER_ID_ECOMMERCE |
orders[].customer.hash | CUSTOMER_HASH |
orders[].customer.id | CUSTOMER_ID |
orders[].error | ERROR |
orders[].external_cart_token | EXTERNAL_CART_TOKEN |
orders[].external_order_id.ecommerce | EXTERNAL_ORDER_ID_ECOMMERCE |
orders[].external_order_name.ecommerce | EXTERNAL_ORDER_NAME_ECOMMERCE |
orders[].external_order_number.ecommerce | EXTERNAL_ORDER_NUMBER_ECOMMERCE |
orders[].is_prepaid | IS_PREPAID |
orders[].note | NOTE |
orders[].processed_at | PROCESSED_AT |
orders[].scheduled_at | SCHEDULED_AT |
orders[].shipping_address.address1 | SHIPPING_ADDRESS_ADDRESS1 |
orders[].shipping_address.address2 | SHIPPING_ADDRESS_ADDRESS2 |
orders[].shipping_address.city | SHIPPING_ADDRESS_CITY |
orders[].shipping_address.company | SHIPPING_ADDRESS_COMPANY |
orders[].shipping_address.country_code | SHIPPING_ADDRESS_COUNTRY_CODE |
orders[].shipping_address.first_name | SHIPPING_ADDRESS_FIRST_NAME |
orders[].shipping_address.last_name | SHIPPING_ADDRESS_LAST_NAME |
orders[].shipping_address.phone | SHIPPING_ADDRESS_PHONE |
orders[].shipping_address.province | SHIPPING_ADDRESS_PROVINCE |
orders[].shipping_address.zip | SHIPPING_ADDRESS_ZIP |
orders[].status | STATUS |
orders[].subtotal_price | SUBTOTAL_PRICE |
orders[].tags | TAGS |
orders[].taxable | TAXABLE |
orders[].total_discounts | TOTAL_DISCOUNTS |
orders[].total_duties | TOTAL_DUTIES |
orders[].total_line_items_price | TOTAL_LINE_ITEMS_PRICE |
orders[].total_price | TOTAL_PRICE |
orders[].total_refunds | TOTAL_REFUNDS |
orders[].total_tax | TOTAL_TAX |
orders[].total_weight_grams | TOTAL_WEIGHT_GRAMS |
orders[].type | TYPE |
orders[].tax_lines | TAX_LINES |
orders[].updated_at | UPDATED_AT |
Daasity: shop id | __SOURCE_ID |
Daasity: account id | _ACCOUNT_ID |
MD5(orders[].id) | __SYNC_KEY |
Daasity: timestamp when loaded into DB | __SYNCED_AT |
Order Line Items
Endpoint: List orders
Update Method: UPSERT
Table Name:
[recharge_2021_11.order_line_items]
| JSON Element | Database Column |
|---|---|
orders[].id | ORDER_ID |
orders[].line_items[].purchase_item_id | PURCHASE_ITEM_ID |
orders[].line_items[].external_inventory_policy | EXTERNAL_INVENTORY_POLICY |
orders[].line_items[].external_product_id.ecommerce | EXTERNAL_PRODUCT_ID_ECOMMERCE |
orders[].line_items[].external_variant_id.ecommerce | EXTERNAL_VARIANT_ID_ECOMMERCE |
orders[].line_items[].grams | GRAMS |
orders[].line_items[].handle | HANDLE |
orders[].line_items[].original_price | ORIGINAL_PRICE |
orders[].line_items[].purchase_item_type | PURCHASE_ITEM_TYPE |
orders[].line_items[].quantity | QUANTITY |
orders[].line_items[].sku | SKU |
orders[].line_items[].tax_due | TAX_DUE |
orders[].line_items[].taxable_amount | TAXABLE_AMOUNT |
orders[].line_items[].taxable | TAXABLE |
orders[].line_items[].title | TITLE |
orders[].line_items[].total_price | TOTAL_PRICE |
orders[].line_items[].unit_price_includes_tax | UNIT_PRICE_INCLUDES_TAX |
orders[].line_items[].unit_price | UNIT_PRICE |
orders[].line_items[].variant_title | VARIANT_TITLE |
orders[].line_items[].tax_lines | TAX_LINES |
Daasity: shop id | __SOURCE_ID |
Daasity: account id | _ACCOUNT_ID |
MD5( orders[].id + orders[].line_items[].purchase_item_id + orders[].line_items[].sku + orders[].line_items[].title + orders[].line_items[].variant_title ) | __SYNC_KEY |
Daasity: timestamp when loaded into DB | __SYNCED_AT |
Order Line Item Properties
Endpoint: List orders
Update Method: UPSERT
Table Name:
[recharge_2021_11.order_line_item_properties]
| JSON Element | Database Column |
|---|---|
orders[].id | ORDER_ID |
orders[].line_items[].purchase_item_id | PURCHASE_ITEM_ID |
orders[].line_items[].sku | SKU |
orders[].line_items[].title | TITLE |
orders[].line_items[].variant_title | VARIANT_TITLE |
orders[].line_items[].properties[].name | NAME |
orders[].line_items[].properties[].value | VALUE |
Daasity: shop id | __SOURCE_ID |
Daasity: account id | _ACCOUNT_ID |
MD5( orders[].id + orders[].line_items[].purchase_item_id + orders[].line_items[].sku + orders[].line_items[].title + orders[].line_items[].variant_title + orders[].line_items[].properties[].name + orders[].line_items[].properties[].value ) | __SYNC_KEY |
Daasity: timestamp when loaded into DB | __SYNCED_AT |
Order Shipping Lines
Endpoint: List Orders
Update Method: UPSERT
Table Name:
[recharge_2021_11.order_shipping_lines]
| JSON Element | Database Column |
|---|---|
orders[].id | ORDER_ID |
orders[].shipping_lines[].code | CODE |
orders[].shipping_lines[].price | PRICE |
orders[].shipping_lines[].title | TITLE |
orders[].shipping_lines[].source | SOURCE |
orders[].shipping_lines[].taxable | TAXABLE |
Daasity: shop id | __SOURCE_ID |
Daasity: account id | _ACCOUNT_ID |
MD5( orders[].id + orders[].shipping_lines[].code + orders[].shipping_lines[].price + orders[].shipping_lines[].title ) | __SYNC_KEY |
Daasity: timestamp when loaded into DB | __SYNCED_AT |
Payment Methods
Endpoint: List Payment Methods
Update Method: UPSERT
Table Name:
[recharge_2021_11.payment_methods]
| JSON Element | Database Column |
|---|---|
payment_methods[].id | ID |
payment_methods[].default | DEFAULT |
payment_methods[].created_at | CREATED_AT |
payment_methods[].updated_at | UPDATED_AT |
payment_methods[].customer_id | CUSTOMER_ID |
payment_methods[].payment_type | PAYMENT_TYPE |
payment_methods[].processor_name | PROCESSOR_NAME |
payment_methods[].billing_address.zip | BILLING_ADDRESS_ZIP |
payment_methods[].billing_address.city | BILLING_ADDRESS_CITY |
payment_methods[].billing_address.name | BILLING_ADDRESS_NAME |
payment_methods[].billing_address.phone | BILLING_ADDRESS_PHONE |
payment_methods[].billing_address.address1 | BILLING_ADDRESS_ADDRESS1 |
payment_methods[].billing_address.address2 | BILLING_ADDRESS_ADDRESS2 |
payment_methods[].billing_address.province | BILLING_ADDRESS_PROVINCE |
payment_methods[].billing_address.company_name | BILLING_ADDRESS_COMPANY_NAME |
payment_methods[].billing_address.country_code | BILLING_ADDRESS_COUNTRY_CODE |
payment_methods[].processor_customer_token | PROCESSOR_CUSTOMER_TOKEN |
payment_methods[].processor_payment_method_token | PROCESSOR_PAYMENT_METHOD_TOKEN |
payment_methods[].payment_details.brand | PAYMENT_METHOD_DETAIL_BRAND |
payment_methods[].payment_details.last4 | PAYMENT_METHOD_DETAIL_LAST4 |
payment_methods[].payment_details.exp_year | PAYMENT_METHOD_DETAIL_EXP_YEAR |
payment_methods[].payment_details.exp_month | PAYMENT_METHOD_DETAIL_EXP_MONTH |
Daasity: shop id | __SOURCE_ID |
Daasity: account id | _ACCOUNT_ID |
MD5(payment_methods[].id) | __SYNC_KEY |
Daasity: timestamp when loaded into DB | __SYNCED_AT |
Subscriptions
Endpoint: List Subscriptions
Update Method: UPSERT
Table Name:
[recharge_2021_11.subscriptions]
| JSON Element | Database Column |
|---|---|
subscriptions[].id | ID |
subscriptions[].address_id | ADDRESS_ID |
subscriptions[].customer_id | CUSTOMER_ID |
subscriptions[].cancellation_reason | CANCELLATION_REASON |
subscriptions[].cancellation_reason_comments | CANCELLATION_REASON_COMMENTS |
subscriptions[].cancelled_at | CANCELLED_AT |
subscriptions[].charge_interval_frequency | CHARGE_INTERVAL_FREQUENCY |
subscriptions[].created_at | CREATED_AT |
subscriptions[].expire_after_specific_number_of_charges | EXPIRE_AFTER_SPECIFIC_NUMBER_OF_CHARGES |
subscriptions[].external_product_id.ecommerce | EXTERNAL_PRODUCT_ID_ECOMMERCE |
subscriptions[].external_variant_id.ecommerce | EXTERNAL_VARIANT_ID_ECOMMERCE |
subscriptions[].has_queued_charges | HAS_QUEUED_CHARGES |
subscriptions[].is_prepaid | IS_PREPAID |
subscriptions[].is_skippable | IS_SKIPPABLE |
subscriptions[].is_swappable | IS_SWAPPABLE |
subscriptions[].max_retries_reached | MAX_RETRIES_REACHED |
subscriptions[].next_charge_scheduled_at | NEXT_CHARGE_SCHEDULED_AT |
subscriptions[].order_day_of_month | ORDER_DAY_OF_MONTH |
subscriptions[].order_day_of_week | ORDER_DAY_OF_WEEK |
subscriptions[].order_interval_frequency | ORDER_INTERVAL_FREQUENCY |
subscriptions[].order_interval_unit | ORDER_INTERVAL_UNIT |
subscriptions[].presentment_currency | PRESENTMENT_CURRENCY |
subscriptions[].price | PRICE |
subscriptions[].product_title | PRODUCT_TITLE |
subscriptions[].quantity | QUANTITY |
subscriptions[].sku | SKU |
subscriptions[].sku_override | SKU_OVERRIDE |
subscriptions[].status | STATUS |
subscriptions[].updated_at | UPDATED_AT |
subscriptions[].variant_title | VARIANT_TITLE |
Daasity: shop id | __SOURCE_ID |
Daasity: account id | _ACCOUNT_ID |
MD5(subscriptions[].id) | __SYNC_KEY |
Daasity: timestamp when loaded into DB | __SYNCED_AT |
Subscription Analytics Data UTM Params
Endpoint: List Subscriptions
Update Method: UPSERT
Table Name:
[recharge_2021_11.subscription_analytics_data_utm_params]
| JSON Element | Database Column |
|---|---|
subscriptions[].id | SUBSCRIPTION_ID |
subscriptions[].analytics_data.utm_params[].utm_campaign | UTM_CAMPAIGN |
subscriptions[].analytics_data.utm_params[].utm_content | UTM_CONTENT |
subscriptions[].analytics_data.utm_params[].utm_data_source | UTM_DATA_SOURCE |
subscriptions[].analytics_data.utm_params[].utm_source | UTM_SOURCE |
subscriptions[].analytics_data.utm_params[].utm_medium | UTM_MEDIUM |
subscriptions[].analytics_data.utm_params[].utm_term | UTM_TERM |
subscriptions[].analytics_data.utm_params[].utm_timestamp | UTM_TIMESTAMP |
Daasity: shop id | __SOURCE_ID |
Daasity: account id | _ACCOUNT_ID |
MD5( subscriptions[].id + subscriptions[].analytics_data.utm_params[].utm_campaign + subscriptions[].analytics_data.utm_params[].utm_content + subscriptions[].analytics_data.utm_params[].utm_data_source + subscriptions[].analytics_data.utm_params[].utm_source + subscriptions[].analytics_data.utm_params[].utm_medium + subscriptions[].analytics_data.utm_params[].utm_term + subscriptions[].analytics_data.utm_params[].utm_timestamp ) | __SYNC_KEY |
Daasity: timestamp when loaded into DB | __SYNCED_AT |
Subscription Properties
Endpoint: List Subscriptions
Update Method: UPSERT
Table Name:
[recharge_2021_11.subscription_properties]
| JSON Element | Database Column |
|---|---|
subscriptions[].id | SUBSCRIPTION_ID |
subscriptions[].properties[].name | NAME |
subscriptions[].properties[].value | VALUE |
Daasity: shop id | __SOURCE_ID |
Daasity: account id | _ACCOUNT_ID |
MD5( subscriptions[].id + subscriptions[].properties[].name + subscriptions[].properties[].value ) | __SYNC_KEY |
Daasity: timestamp when loaded into DB | __SYNCED_AT |
Last updated