Upscribe
Upscribe ETL connector for data replication
Snapshot
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 |
Tables/APIs supported
subscription | subscription_history_report |
customers | products |
collections | refunds |
orders |
Integrate Upscribe with Daton
Sign in to Daton
Select Upscribe from Integrations page
Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide your Upscribe account Email and Password and provide your store URL
Post successful authentication you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration
Workflow
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
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Upscribe Data
subscription
Purpose: Returns all the List of subscriptions associated with upscribe account and your given domain.
Source API Documentation https://api.upscribe.io/#list-subscriptions
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 |
subscription_history_report
Purpose: Returns all the List of subscriptions changelogs associated with upscribe account and your given domain.
Source API Documentation: https://api.upscribe.io/#list-subscription-queues
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 |
customers
Purpose: Returns all the List of customer information and cards associated with upscribe account and your given domain.
Source API Documentation: https://api.upscribe.io/#get-customer
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 |
STRING | |
first_name | STRING |
id | NUMERIC |
inactive_subscription_count | NUMERIC |
language | STRING |
last_name | STRING |
state | STRING |
store_id | NUMERIC |
updated_at | TIMESTAMP |
products
Purpose: Returns all the List of product information associated with upscribe account and your given domain.
Source API Documentation https://api.upscribe.io/#list-subscription-products
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 |
collections
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 |
refunds
Purpose:Returns all the List of refunds associated with upscribe account and your given domain.
Source API Documentation https://api.upscribe.io/#list-refunds
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 |
orders
Purpose: Returns all the List of order information associated with upscribe account and your given domain.
Source API Documentation https://api.upscribe.io/#get-order
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 |
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 updated