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