Sticky.io

Essential Attributes

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

Signin to Daton
Select StickyIO from Integrations page
Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide your StickyIO account Username and password and your app key to authorize Daton to periodically extract data from stickyIO.
Post successful authentication, you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration

Workflow

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
Users would be able to edit/pause/re-activate/delete integration anytime
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