Sticky.io
Sticky.io ETL connector for data replication
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 |
- 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
- 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
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 |