Schema Information
This subtopic provides a structured reference to assist you in working with Daton's LoyaltyLion connector and the associated fields and tables.
Schema Information
This subtopic provides a structured reference to assist you in working with Daton's LoyaltyLion connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the LoyaltyLion connector:
- Activities
- Customers
- Loyalty Emails
- Orders
Source documentation: https://developers.loyaltylion.com/api/resources/customers
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 |
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 |
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 |
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 |