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
billing_last_name
STRING
billing_postcode
STRING
billing_state
STRING
billing_state_id
STRING
billing_street_address
STRING
billing_street_address2
STRING
campaign_id
INTEGER
cc_expires
INTEGER
cc_first_6
INTEGER
cc_last_4
INTEGER
cc_number
INTEGER
credit_card_number
INTEGER
cc_orig_first_6
STRING
cc_orig_last_4
STRING
cc_type
STRING
chargeback_date
TIMESTAMP
check_account_last_4
STRING
check_routing_last_4
STRING
check_ssn_last_4
STRING
check_transitnum
STRING
child_id
STRING
click_id
STRING
created_by_user_name
STRING
created_by_employee_name
STRING
coupon_discount_amount
STRING
coupon_id
STRING
credit_applied
STRING
promo_code
STRING
customer_id
INTEGER
customers_telephone
STRING
decline_salvage_discount_percent
STRING
decline_reason
STRING
decline_reason_details
STRING
email_address
STRING
first_name
STRING
gateway_id
STRING
gateway_descriptor
STRING
hold_date
DATE
ip_address
STRING
is_blacklisted
STRING
is_chargeback
STRING
is_fraud
STRING
is_recurring
STRING
is_refund
STRING
is_rma
STRING
is_test_cc
STRING
is_void
STRING
last_name
STRING
main_product_id
INTEGER
main_product_quantity
INTEGER
next_subscription_product
STRING
next_subscription_product_id
STRING
on_hold
STRING
on_hold_by
STRING
order_confirmed
STRING
order_sales_tax
NUMERIC
order_sales_tax_amount
NUMERIC
shipping_amount
NUMERIC
order_status
INTEGER
order_total
NUMERIC
parent_id
INTEGER
prepaid_match
STRING
preserve_gateway
STRING
processor_id
STRING
rebill_discount_percent
STRING
current_rebill_discount_percent
STRING
recurring_date
DATE
refund_amount
NUMERIC
refund_date
TIMESTAMP
retry_date
DATE
rma_number
STRING
rma_reason
STRING
shipping_city
STRING
shipping_country
STRING
shipping_date
DATE
shipping_first_name
STRING
shipping_id
INTEGER
shipping_last_name
STRING
shipping_method_name
STRING
shipping_postcode
STRING
shipping_state
STRING
shipping_state_id
STRING
shipping_street_address
STRING
shipping_street_address2
STRING
sub_affiliate
STRING
time_stamp
TIMESTAMP
tracking_number
STRING
transaction_id
STRING
upsell_product_id
STRING
upsell_product_quantity
STRING
void_amount
NUMERIC
void_date
TIMESTAMP
shippable
STRING
website_received
STRING
website_sent
STRING
is_cascaded
INTEGER
stop_after_next_rebill
INTEGER
products
RECORD
systemNotes
STRING
totals_breakdown
RECORD
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
billing_last_name
STRING
billing_postcode
STRING
billing_state
STRING
billing_state_id
STRING
billing_street_address
STRING
billing_street_address2
STRING
campaign_id
INTEGER
cc_expires
INTEGER
cc_first_6
INTEGER
cc_last_4
INTEGER
cc_number
INTEGER
credit_card_number
INTEGER
cc_orig_first_6
STRING
cc_orig_last_4
STRING
cc_type
STRING
chargeback_date
STRING
check_account_last_4
STRING
check_routing_last_4
STRING
check_ssn_last_4
STRING
check_transitnum
STRING
child_id
STRING
click_id
STRING
created_by_user_name
STRING
created_by_employee_name
STRING
coupon_discount_amount
STRING
coupon_id
STRING
credit_applied
STRING
promo_code
STRING
customer_id
INTEGER
customers_telephone
STRING
decline_salvage_discount_percent
STRING
decline_reason
STRING
decline_reason_details
STRING
email_address
STRING
first_name
STRING
gateway_id
STRING
gateway_descriptor
STRING
hold_date
DATE
ip_address
STRING
is_blacklisted
STRING
is_chargeback
STRING
is_fraud
STRING
is_recurring
STRING
is_refund
STRING
is_rma
STRING
is_test_cc
STRING
is_void
STRING
last_name
STRING
main_product_id
INTEGER
main_product_quantity
STRING
next_subscription_product
STRING
next_subscription_product_id
STRING
on_hold
STRING
on_hold_by
STRING
order_confirmed
STRING
order_confirmed_date
DATE
order_sales_tax
NUMERIC
order_sales_tax_amount
NUMERIC
shipping_amount
NUMERIC
order_status
INTEGER
order_total
NUMERIC
parent_id
INTEGER
prepaid_match
STRING
preserve_gateway
STRING
processor_id
STRING
rebill_discount_percent
STRING
current_rebill_discount_percent
STRING
recurring_date
DATE
refund_amount
NUMERIC
refund_date
STRING
retry_date
DATE
rma_number
STRING
rma_reason
STRING
shipping_city
STRING
shipping_country
STRING
shipping_first_name
STRING
shipping_id
INTEGER
shipping_last_name
STRING
shipping_method_name
STRING
shipping_postcode
STRING
shipping_state
STRING
shipping_state_id
STRING
shipping_street_address
STRING
shipping_street_address2
STRING
sub_affiliate
STRING
time_stamp
TIMESTAMP
tracking_number
STRING
transaction_id
STRING
upsell_product_id
STRING
upsell_product_quantity
STRING
void_amount
NUMERIC
void_date
TIMESTAMP
shippable
STRING
website_received
STRING
website_sent
STRING
is_cascaded
INTEGER
stop_after_next_rebill
INTEGER
products
RECORD
systemNotes
STRING
totals_breakdown
RECORD
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
countries
RECORD
fulfillment_id
NUMERIC
check_provider_id
NUMERIC
membership_provider_id
NUMERIC
call_confirm_provider_id
NUMERIC
chargeback_provider_id
NUMERIC
prospect_provider_id
NUMERIC
email_provider_id
NUMERIC
offers
STRING
channel
STRING
payment_methods
RECORD
gateway
RECORD
alternative_payments
STRING
shipping_profiles
RECORD
return_profiles
STRING
postback_profiles
STRING
coupon_profiles
STRING
fraud_providers
STRING
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