Upscribe
Upscribe ETL connector for data replication
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 |
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 |
