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

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

Workflow

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

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
email	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
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