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.Signin to Daton
2.Select StickyIO 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 StickyIO account Username and password and your app key to authorize Daton to periodically extract data from stickyIO.
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
StickyIO Data
Subscriptions
Purpose: Returns all the List of subscriptions associated with stickyio account.
Source API Documentation  https://developer-v2.sticky.io/?version=latest#ec83fffc-4db6-4840-8a9f-388cd855f9ab​
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.
Source API Documentation  https://developer-v2.sticky.io/?version=latest#ec83fffc-4db6-4840-8a9f-388cd855f9ab​
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.
Source API Documentation  https://developer-v2.sticky.io/?version=latest#ec83fffc-4db6-4840-8a9f-388cd855f9ab​
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.
Source API Documentation  https://developer-v2.sticky.io/?version=latest#ec83fffc-4db6-4840-8a9f-388cd855f9ab​
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.
Source API Documentation  https://developer-v2.sticky.io/?version=latest#ec83fffc-4db6-4840-8a9f-388cd855f9ab​
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.
Source API Documentation  https://developer-v2.sticky.io/?version=latest#ec83fffc-4db6-4840-8a9f-388cd855f9ab​
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.
Source API Documentation  https://developer-v2.sticky.io/?version=latest#fb64c8dd-24c1-4524-ad23-dfe9286a7528​
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
freight_code
STRING
threshold_amount
STRING

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

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

Name	Target Datatype
department_id	INTEGER
timezone	STRING
id	INTEGER
is_active	NUMERIC
name	STRING
email	STRING
call_center_provider_id	NUMERIC