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. Signin 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. After providing the Email,password and Store url to authorize Daton to periodically extract data from Upscribe.

  6. Post successful authentication you will be prompted to choose from the list of available tables

  7. Then select all required fields for each table

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

Subscriptions

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

Source API Documentation: https://api.upscribe.io/#list-subscription-queues

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.

Source API Documentation https://api.upscribe.io/#list-subscription-products

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