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

![](https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FO6Fsc7C4g7aRVBj7Z7Ae%2Fimage.png?alt=media\&token=ff24729e-a8d4-4d36-afd4-b1140ce3f834)

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.

![](https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FEQt9eA2pV7mgwr3pJpD4%2Fimage.png?alt=media\&token=4a09d86b-0cf7-4615-859c-ec0eee14be84)

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

![](https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FsN6la7jxvAJGcWfOmJWf%2Fimage.png?alt=media\&token=5a91b923-c0c9-4141-85e6-631cb5454d13)

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

![](https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2F9JqKwC0ir8JWBOEMtKjo%2Fimage.png?alt=media\&token=a076badb-caf6-4a21-99fa-8fd8828a5729)

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

![](https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FGRa0Y1KKRENVm32dNFKr%2Fimage.png?alt=media\&token=9262bb24-efb7-47e3-8fd0-8782ce5f9ad5)

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;