Upscribe
Upscribe ETL connector for data replication
Features | Details |
Release Status | Released |
Source API Version | v2 |
Table Selection | Yes |
Column Selection | Yes |
Edit Integration | Yes |
Replication Type Selection | No |
Authentication Parameters | Upscribe Email
Upscribe password
Upscribe Store Domain |
Replication Type | Key based Replication |
Replication Key | datetime |
Suggested Replication Frequency | 24 hours |
subscription | subscription_history_report |
customers | products |
collections | refunds |
orders | ​ |
- 1.Sign in to Daton
- 2.Select Upscribe from Integrations page
- 3.Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
- 4.Provide your Upscribe account Email and Password and provide your store URL
- 5.Post successful authentication you will be prompted to choose from the list of available tables
- 6.Then select all required fields for each table
- 7.Submit the integration
- 1.Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
- 2.Users would be able to edit/pause/re-activate/delete integration anytime
- 3.Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Purpose: Returns all the List of subscriptions associated with upscribe account and your given domain.
Replication: Key-Based Replication
Replication Key: updated_at_min, updated_at_max
Fields
Name | Target Datatype |
|---|---|
activated_on | STRING |
active | BOOLEAN |
billing_address | RECORD |
cancellation_reason | STRING |
cancellation_comment | STRING |
cancellation_reminder_sent | BOOLEAN |
cancelled_on | TIMESTAMP |
charge_limit | NUMERIC |
coupon_discount | STRING |
created_at | TIMESTAMP |
id | NUMERIC |
import_id | STRING |
interval | NUMERIC |
items | RECORD |
next | RECORD |
order_count | NUMERIC |
original_total_line_items_price | STRING |
original_total_price | STRING |
original_total_tax | STRING |
payment_customer_id | STRING |
payment_method_id | STRING |
payment_type | STRING |
period | STRING |
quantity_discount | STRING |
requires_customer_update | BOOLEAN |
requires_update | BOOLEAN |
shipping_address | RECORD |
shipping_discount | STRING |
shipping_lines | RECORD |
shopify_customer_email | STRING |
shopify_customer_id | NUMERIC |
shopify_discount | STRING |
shopify_order_id | NUMERIC |
store_id | NUMERIC |
subscription_discount | STRING |
tax_discount | STRING |
total_discount | STRING |
total_discount_inc_tax | STRING |
total_line_items_price | NUMERIC |
total_price | NUMERIC |
total_tax | NUMERIC |
tracking_codes | RECORD |
updated_at | TIMESTAMP |
Purpose: Returns all the List of subscriptions changelogs associated with upscribe account and your given domain.
Replication: Key-Based Replication
Replication Key: updated_at_min, updated_at_max
Fields
Name | Data Type |
|---|---|
admin_email | STRING |
admin_id | STRING |
created_at | STRING |
field | STRING |
id | STRING |
is_admin | STRING |
item_id | STRING |
new_value | STRING |
old_value | STRING |
product_title | STRING |
queue_id | STRING |
requested_by_ip | STRING |
store_id | STRING |
subscription_id | STRING |
updated_at | STRING |
variant_title | STRING |
Purpose: Returns all the List of customer information and cards associated with upscribe account and your given domain.
Replication: Key-Based Replication
Replication Key: updated_at_min, updated_at_max
Fields
Name | Target Datatype |
|---|---|
accepts_marketing | BOOLEAN |
active_subscription_count | NUMERIC |
addresses | RECORD |
created_at | TIMESTAMP |
default_address | RECORD |
email | STRING |
first_name | STRING |
id | NUMERIC |
inactive_subscription_count | NUMERIC |
language | STRING |
last_name | STRING |
state | STRING |
store_id | NUMERIC |
updated_at | TIMESTAMP |
Purpose: Returns all the List of product information associated with upscribe account and your given domain.
Replication: Key-Based Replication
Replication Key: updated_at_min, updated_at_max
Fields
Name | Target Datatype |
|---|---|
body_html | STRING |
collections | RECORD |
created_at | TIMESTAMP |
handle | STRING |
id | NUMERIC |
image | RECORD |
images | RECORD |
in_sales_channel | BOOLEAN |
is_subscription | BOOLEAN |
metafields | RECORD |
options | RECORD |
store_id | NUMERIC |
template_suffix | STRING |
title | STRING |
updated_at | TIMESTAMP |
variants | RECORD |
vendor | STRING |
Purpose: Returns all the List of collections information associated with upscribe account and your given domain.
Source API Documentation
Replication: Key-Based Replication
Replication Key: updated_at_min, updated_at_max
Fields
Name | Target Datatype |
|---|---|
body_html | STRING |
created_at | TIMESTAMP |
handle | STRING |
id | NUMERIC |
image | STRING |
sort_order | STRING |
store_id | NUMERIC |
title | STRING |
updated_at | TIMESTAMP |
Purpose:Returns all the List of refunds associated with upscribe account and your given domain.
Replication: Key-Based Replication
Replication Key: updated_at_min, updated_at_max
Fields
Name | Target Datatype |
|---|---|
amount | NUMERIC |
created_at | TIMESTAMP |
currency | STRING |
id | STRING |
payment_charge_id | STRING |
reason | STRING |
shopify_order_id | NUMERIC |
status | STRING |
store_id | NUMERIC |
type | STRING |
updated_at | TIMESTAMP |
Purpose: Returns all the List of order information associated with upscribe account and your given domain.
Replication: Key-Based Replication
Replication Key: updated_at_min, updated_at_max
Fields
Name | Target Datatype |
|---|---|
analytics | STRING |
billing_address | RECORD |
cancel_reason | STRING |
cancelled_at | TIMESTAMP |
contact_email | STRING |
create_subscription | BOOLEAN |
created_at | TIMESTAMP |
customer | RECORD |
discount_applications | RECORD |
discount_codes | RECORD |
email | STRING |
financial_status | STRING |
fulfillment_status | STRING |
fulfillments | RECORD |
guest_checkout | BOOLEAN |
id | NUMERIC |
line_items | RECORD |
name | STRING |
note | STRING |
number | NUMERIC |
order_number | NUMERIC |
payment_charge_id | STRING |
payment_customer_id | STRING |
payment_method_id | STRING |
payment_type | STRING |
phone | STRING |
presentment_currency | STRING |
processed_at | TIMESTAMP |
refunds | RECORD |
shipping_address | RECORD |
shipping_lines | RECORD |
shopify_customer_id | NUMERIC |
store_id | NUMERIC |
subtotal_price | NUMERIC |
tags | STRING |
tax_lines | RECORD |
token | STRING |
total_discounts | NUMERIC |
total_line_items_price | NUMERIC |
total_price | NUMERIC |
total_shipping_price_set | RECORD |
total_tax | NUMERIC |
tracking_codes | RECORD |
updated_at | TIMESTAMP |
Last modified 1d ago