LoyaltyLion
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.
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 |
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 |
Last modified 1yr ago