Upscribe V2

Upscribe is a software platform that provides tools for creating and managing subscription forms and email opt-in forms.

Snapshot

Features	Details
Release Status	Released
Source API Version	v2
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Authentication Parameters	Upscribe Email Upscribe password Upscribe Store Domain
Replication Type	Key based Replication
Suggested Replication Frequency	24 hours

Tables/APIs supported

Tables Supported
collections
customers
orders
refunds
subscription_history_report
products
subscription

Instructions to Integrate Upscribe with Daton

You can use Templates to create new integrations quickly, this may help you in configuring your Tables, Fields, or Column selection with ease.

Prerequisites

• An active Upscribe account store and existing Daton account.

Integrate Upscribe with Daton

1. Sign in to your existing Daton account.

2. Search for Upscribe V2 in the list of Connectors and click on the 'Configure' button.

3. Provide the necessary Integration Name, Replication Frequency, and Replication Start Date data and click on the 'Authenticate' button. Please Note, the Integration Name would be used in creating tables for the integration and cannot be changed later.

   
4. Provide your Upscribe 'Store Domain,' 'Email' and 'Password' and click on the 'Authenticate' button.

   
5. Post successful authentication, you will be prompted to choose from the list of available tables. Add the required Tables and click on 'Next.'

   
6. Select all the Columns you require for each table and Submit the integration.

   
7. Once submitted, you will be prompted to select the destination for your Shop. Select your favorite destination and click on 'Confirm.' Congrats! Your Shop has been integrated with Daton.

Workflow

1. Integrations would be in the Pending state initially and will be moved to the Active state as soon as the first job loads data successfully into the configured warehouse.

2. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list.

3. Users can Re-Authenticate, Edit, Clone, Pause or Delete the integration at any given time by clicking on the settings You can also edit the integration to change frequency and history.

4. Each table in your integration can be accessed by clicking on the integration on the 'Sources' page. Here you may find the status of each table, the last replicated time, and Reload access buttons.

Upscribe Data

collections

Purpose: Returns all the List of collections information associated with the upscribe account and your given domain.

FIELDS

Field Name	Data Type
body_html	STRING
created_at	STRING
handle	STRING
id	NUMERIC
image	RECORD
sort_order	STRING
store_id	NUMERIC
title	STRING
updated_at	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

customers

Purpose: Gets all the List of customer information and cards associated with upscribe account and your given domain.

Source API Documentation: Upscribe V2- Customers API

FIELDS

Field Name	Data Type
accepts_marketing	BOOLEAN
active_subscription_count	NUMERIC
addresses	RECORD
created_at	STRING
email	STRING
email_marketing_consent	RECORD
first_name	STRING
id	NUMERIC
inactive_subscription_count	NUMERIC
language	STRING
last_name	STRING
state	STRING
store_id	NUMERIC
tax_exempt	BOOLEAN
updated_at	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

orders

Purpose: Returns all the List of order information associated with the upscribe account and your given domain.

Source API Documentation: Upscribe V2- Orders API

FIELDS

Field Name	Data Type
billing_address	RECORD
contact_email	STRING
create_subscription	BOOLEAN
created_at	STRING
customer	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	RECORD
payment_method_id	STRING
payment_type	STRING
presentment_currency	STRING
processed_at	DATETIME
shipping_address	RECORD
shipping_lines	RECORD
shopify_customer_id	NUMERIC
store_id	NUMERIC
subtotal_price	NUMERIC
tags	STRING
tax_lines	RECORD
taxes_included	BOOLEAN
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	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

refunds

Purpose: Returns all the List of refunds associated with the upscribe account and your given domain.

Source API Documentation: Upscribe V2- Refunds API

FIELDS

Field Name	Data Type
amount	NUMERIC
created_at	STRING
currency	STRING
id	STRING
payment_charge_id	STRING
reason	STRING
shopify_order_id	NUMERIC
status	STRING
store_id	NUMERIC
type	STRING
updated_at	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

products

Purpose: Returns all the List of product information associated with upscribe account and your given domain.

Source API Documentation: Upscribe V2- Products API

FIELDS

Field Name	Data Type
body_html	STRING
collections	RECORD
created_at	DATETIME
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	STRING
variants	RECORD
vendor	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

subscription

Purpose: Returns all the List of subscriptions associated with upscribe account and your given domain.

Source API Documentation: Upscribe V2- Subscription API

FIELDS

Field Name	Data Type
body_html	STRING
collections	RECORD
created_at	DATETIME
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	STRING
variants	RECORD
vendor	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

subscription_history_report

Purpose: Returns all the history reports of subscriptions associated with the upscribe account and your given domain.

Source API Documentation: Upscribe V2- Subscription Report API

FIELDS

Feild Name	Data Type
admin_email	STRING
admin_id	NUMERIC
created_at	STRING
field	STRING
id	NUMERIC
is_admin	BOOLEAN
item_id	STRING
new_value	STRING
old_value	STRING
product_title	STRING
queue_id	NUMERIC
requested_by_ip	STRING
store_id	NUMERIC
subscription_id	NUMERIC
updated_at	STRING
variant_title	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC