> For the complete documentation index, see [llms.txt](https://daton-sarasanalytics.gitbook.io/daton/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/saas-integrations/loyaltylion.md).

# 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**

![](/files/ah0uGeI5FIJXfaVL0yMu)

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.

![](/files/kXJBckw9iLxMVtEovDJr)

2\.       After logging in, click on **manage**

![](/files/qNyQ7knOqk08jaLaSXVf)

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

![](/files/S0ReZpxkYcr4t3F3pIl8)

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

![](/files/BCtlgU3dLGWqT0fykp2X)

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                | <p>Key based incremental<br>Full Load</p> |
| 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**

| <p> </p><p><strong>Name</strong></p><p> </p> | <p> </p><p><strong>Data Type</strong></p><p> </p> |
| -------------------------------------------- | ------------------------------------------------- |
| id                                           | NUMERIC                                           |
| merchant\_id                                 | STRING                                            |
| value                                        | NUMERIC                                           |
| state                                        | STRING                                            |
| rule                                         | RECORD                                            |
| customer                                     | RECORD                                            |
| created\_at                                  | TIMESTAMP                                         |

&#x20;

**2.       Customers**\
Purpose: To get a list of all the customers\
Replication: Incremental\
Replication Key: updated\_at\
\
**Fields**<br>

| <p> </p><p><strong>Name</strong></p><p> </p> | <p> </p><p><strong>Data Type</strong></p><p> </p> |
| -------------------------------------------- | ------------------------------------------------- |
| 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                                           |

&#x20;

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

| <p> </p><p><strong>Name</strong></p><p> </p> | <p> </p><p><strong>Data Type</strong></p><p> </p> |
| -------------------------------------------- | ------------------------------------------------- |
| id                                           | NUMERIC                                           |
| email                                        | STRING                                            |

&#x20;

**4.       Orders**\
Purpose: To get a list of all the orders\
Replication: Incremental\
Replication Key: updated\_at\
\
**Fields**

| <p> </p><p><strong>Name</strong></p><p> </p> | <p> </p><p><strong>Data Type</strong></p><p> </p> |
| -------------------------------------------- | ------------------------------------------------- |
| 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                                         |

&#x20;