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