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