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

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

Source API Documentation https://developer-v2.sticky.io/?version=latest#b6e25276-d7b8-40cd-9a6a-198ec33e2280

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.

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
iso_numeric	NUMERIC
calling_code	STRING
id	INTEGER
name	STRING
iso_2	STRING
iso_3	STRING

Channels

Purpose: - Get list of all the channels.

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
id	INTEGER
name	STRING

PaymentMethods

Purpose: Returns all the List of payment method 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
id	INTEGER
name	STRING
description	STRING
is_cc_brand	NUMERIC

CouponProfiles

Purpose: Fetch a list of all coupon profiles

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

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