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

  1. Sign in 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. Post successful authentication you will be prompted to choose from the list of available tables

  6. Then select all required fields for each table

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

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

Last updated