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

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
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
Last modified 3mo ago