LoyaltyLion

Locating the Username(Token) & Password(Secret)

1. Login to Loyalty Lion (https://app.loyaltylion.com/) OR Login to your Shopify store and go to Apps

If you have Loyalty Lion added as an app, you should find it here, then just click on it and it should redirect you to Loyalty Lion as a logged in user.

2. After logging in, click on manage

3. On that page, if you scroll a little to the bottom, you should find Settings under configuration

4. On that page, if you scroll a little to the bottom, you’ll find your token and secret.

5. Token is the username and Secret is the password.

Snapshot

Features	Details
Release Status	Released
Source API Version	v2
Table Selection	Yes
Column Selection	Yes
Edit Integrations	Yes
Replication Type Selection	No
Authentication Parameters	Basic Auth (Token & Secret)
Replication Type	Key based incremental Full Load
Replication Key	Date
Suggested Replication Frequency	1 hr

Loyalty Lion Tables

Source documentation: https://developers.loyaltylion.com/api/resources/customers

1. Activities Purpose: To get a list of all the activities. Replication: Incremental Replication Key: created_at Fields

Name	Data Type
id	NUMERIC
merchant_id	STRING
value	NUMERIC
state	STRING
rule	RECORD
customer	RECORD
created_at	TIMESTAMP

2. Customers Purpose: To get a list of all the customers Replication: Incremental Replication Key: updated_at Fields

Name	Data Type
id	NUMERIC
merchant_id	STRING
email	STRING
points_approved	NUMERIC
points_pending	NUMERIC
points_spent	NUMERIC
properties	RECORD
birthday	STRING
metadata	RECORD
blocked	BOOLEAN
guest	BOOLEAN
enrolled	BOOLEAN
enrolled_at	TIMESTAMP
referral_id	STRING
referred_by	STRING
loyalty_tier_membership	RECORD
referral_url	STRING
created_at	TIMESTAMP
updated_at	TIMESTAMP
insights_segment	STRING
rewards_claimed	NUMERIC

3. Loyalty Emails Purpose: To get a list of all the emails and ids Replication: Full Load Replication Key: NA Fields

Name	Data Type
id	NUMERIC
email	STRING

4. Orders Purpose: To get a list of all the orders Replication: Incremental Replication Key: updated_at Fields

Name	Data Type
id	NUMERIC
merchant_id	STRING
merchant_number	STRING
total	STRING
total_tax	STRING
total_shipping	STRING
total_discounts	STRING
total_paid	STRING
total_refunded	STRING
payment_status	STRING
fulfillment_status	STRING
refund_status	STRING
cancellation_status	STRING
customer	RECORD
metadata	RECORD
created_at	TIMESTAMP
updated_at	TIMESTAMP