Sticky.io
Sticky.io ETL connector for data replication

Snapshot

Features
Details
Release Status
Released
Source API Version
v8.12
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
StickyIO account Username StickyIO account Password StickyIO App Key
Replication Type
Key Based Incremental Full Based Replication
Replication Key
Date NA
Suggested Replication Frequency
24 hrs
Tables/APIs Supported
Subscriptions
Orders
Accounts
CustomerCustomFields
CustomFields
Users
BillingModels
Campaigns
Contacts
Countries
Channels
PaymentMethods
CouponProfiles
Shipping

Integrate StickyIO with Daton

  1. 1.
    Signin to Daton
  2. 2.
    Select StickyIO 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 StickyIO account Username and password and your app key to authorize Daton to periodically extract data from stickyIO.
  5. 5.
    Post successful authentication, you will be prompted to choose from the list of available tables
  6. 6.
    Then select all required fields for each table
  7. 7.
    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

StickyIO Data

Subscriptions
Purpose: Returns all the List of subscriptions associated with stickyio account.
Replication: Key-based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
response_code
STRING
order_id
INTEGER
acquisition_date
TIMESTAMP
ancestor_id
INTEGER
affiliate
STRING
afid
STRING
sid
STRING
affid
STRING
c1
STRING
c2
STRING
c3
STRING
aid
STRING
opt
STRING
amount_refunded_to_date
NUMERIC
auth_id
STRING
billing_city
STRING
billing_country
STRING
billing_cycle
STRING
billing_first_name
STRING
Orders
Purpose: Returns all the List of order information associated with stickyio account.
Replication: Key based Replication
Replication Key: lastRunDate
Fields
Name
Target Datatype
response_code
STRING
order_id
INTEGER
acquisition_date
TIMESTAMP
ancestor_id
INTEGER
affiliate
STRING
afid
STRING
sid
STRING
affid
STRING
c1
STRING
c2
STRING
c3
STRING
aid
STRING
opt
STRING
amount_refunded_to_date
NUMERIC
auth_id
STRING
billing_city
STRING
billing_country
STRING
billing_cycle
STRING
billing_first_name
STRING
Accounts
Purpose: Returns all the list of account information associated with stickyio account.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
INTEGER
name
STRING
type
STRING
CustomerCustomFields
Purpose: Returns all the List of custom fields information for customers associated with stickyio account.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
INTEGER
field_type_id
NUMERIC
name
STRING
token_key
STRING
is_multi
NUMERIC
options
RECORD
type_id
NUMERIC
CustomFields
Purpose: Returns all the List of custom fields information associated with stickyio account.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
INTEGER
field_type_id
NUMERIC
name
STRING
is_multi
NUMERIC
options
RECORD
Users
Purpose: Returns all the List of user information associated with stickyio account.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
department_id
INTEGER
timezone
STRING
id
INTEGER
is_active
NUMERIC
name
STRING
email
STRING
call_center_provider_id
NUMERIC
BillingModels
Purpose: Returns all the List of billing models information associated with stickyio account.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
freight_code
STRING
threshold_amount
STRING
threshold_charge_amount
STRING
id
INTEGER
name
STRING
description
STRING
amount_trial
STRING
amount_recurring
STRING
type
RECORD
service_code
STRING
created_at
RECORD
updated_at
RECORD
Campaigns
Purpose: Returns all the List of campaigns information associated with stickyio account.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
gateway_id
INTEGER
is_active
INTEGER
tax_provider_id
NUMERIC
data_verification_provider_id
NUMERIC
site_url
STRING
id
INTEGER
is_archived
NUMERIC
is_prepaid_blocked
NUMERIC
is_custom_price_allowed
NUMERIC
is_avs_enabled
NUMERIC
is_collections_enabled
NUMERIC
created_at
RECORD
updated_at
RECORD
archived_at
TIMESTAMP
name
STRING
description
STRING
pre_auth_amount
STRING
creator
RECORD
updator
RECORD
Contacts
Purpose: Returns all the List of contact information associated with stickyio account.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
INTEGER
email
STRING
origin_id
NUMERIC
is_member
NUMERIC
created_at
TIMESTAMP
first_name
STRING
last_name
STRING
phone
STRING
phone_key
STRING
custom_fields
STRING
addresses
RECORD
notes
STRING
is_sms_communication_enabled
NUMERIC
Countries
Purpose: Returns all the List of countries information associated with stickyio account.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
iso_numeric
NUMERIC
calling_code
STRING
id
INTEGER
name
STRING
iso_2
STRING
iso_3
STRING
Channels
Purpose: - Get list of all the channels.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
INTEGER
name
STRING
PaymentMethods
Purpose: Returns all the List of payment method information associated with stickyio account.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
INTEGER
name
STRING
description
STRING
is_cc_brand
NUMERIC
CouponProfiles
Purpose: Fetch a list of all coupon profiles
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
id
INTEGER
name
STRING
description
STRING
use_count
NUMERIC
discount_amt
STRING
discount_pct
STRING
minimum_purchase
STRING
is_lifetime
NUMERIC
is_active
NUMERIC
created_at
RECORD
updated_at
RECORD
expires_at
STRING
is_free_shipping
NUMERIC
promo_code_count
NUMERIC
limits
RECORD
creator
RECORD
updator
RECORD
Shipping
Purpose: Returns all the List of shipping information associated with stickyio account.
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
freight_code
STRING
threshold_amount
STRING
threshold_charge_amount
STRING
id
INTEGER
name
STRING
description
STRING
amount_trial
STRING
amount_recurring
STRING
type
RECORD
service_code
STRING
created_at
RECORD
updated_at
RECORD
Last modified 1yr ago