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
DATE
Suggested Replication Frequency
24 hrs
Tables/APIs Supported
Subscriptions
SubscriptionQueues
Customers
Products
Collections
Refunds
Order

Integrate Upscribe with Daton

  1. 1.
    Signin to Daton
  2. 2.
    Select Upscribe from Integrations page
  3. 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. 4.
    Provide your Upscribe account Email and Password and provide your store URL
  5. 5.
    After providing the Email,password and Store url to authorize Daton to periodically extract data from Upscribe.
  6. 6.
    Post successful authentication you will be prompted to choose from the list of available tables
  7. 7.
    Then select all required fields for each table
  8. 8.
    Submit the integration.

Workflow

  1. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 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

Subscriptions
Purpose: Returns all the List of subscriptions associated with upscribe account and your given domain.
Replication: Key-Based Replication
Replication Key: lastRunDate
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
SubscriptionQueues
Purpose:Returns all the List of subscriptions queues associated with upscribe account and your given domain.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
billing_address
RECORD
charge_error
STRING
charge_errors
STRING
coupon_discount
STRING
created_at
TIMESTAMP
created_order
STRING
custom_date
BOOLEAN
date
TIMESTAMP
discount_code
STRING
errored
BOOLEAN
errored_count
NUMERIC
id
NUMERIC
is_addressing_upcoming_notification
BOOLEAN
items
RECORD
origin_subtotal_price
STRING
original_total_line_items_price
STRING
original_total_price
STRING
original_total_tax
STRING
payment_method_id
STRING
payment_type
STRING
processed
BOOLEAN
processing
BOOLEAN
quantity_discount
STRING
shipping_address
RECORD
shipping_discount
STRING
shipping_lines
RECORD
shopify_customer_email
STRING
shopify_customer_id
NUMERIC
shopify_order_id
NUMERIC
skip
BOOLEAN
store_id
NUMERIC
subscription_discount
STRING
subscription_id
NUMERIC
subtotal_price
NUMERIC
tax_discount
STRING
total_discount
STRING
total_discount_inc_tax
STRING
total_line_items_price
NUMERIC
total_price
NUMERIC
total_tax
NUMERIC
upcoming_notification_sent
BOOLEAN
updated_at
TIMESTAMP
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: lastRunDate
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.
Replication: Key-Based Replication
Replication Key: lastRunDate
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: lastRunDate
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: lastRunDate
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
Order
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: lastRunDate
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 1yr ago