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

addresses[].id

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

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

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

__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

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

PreviousIntegration SpecificationsNextWorkflow Configuration Setup

Last updated

Was this helpful?