# Monday

## Snapshot

| Features                        | Details                                           |
| ------------------------------- | ------------------------------------------------- |
| Release Status                  | Released                                          |
| Source API Version              | v2                                                |
| Table Selection                 | Yes                                               |
| Column Selection                | Yes                                               |
| Edit Integration                | Yes                                               |
| Replication Type Selection      | No                                                |
| Authentication Parameters       | Api Key                                           |
| Replication Type                | <p>Key Based Replication,<br>Full Replication</p> |
| Replication Key                 | Date                                              |
| Suggested Replication Frequency | 1 hour                                            |

## **Tables/APIs Supported**

| Boards     |
| ---------- |
| BoardsData |
| Users      |
| Updates    |

## Generating API key for Monday

To configure Monday, you will need the API token for your account. You can get your API token in following ways:

### Admin tab

If you are an **admin** user on your monday.com account, follow these steps to access your API token:

1. Log into your monday.com account.
2. Click on your avatar/profile picture in the top right corner.
3. Select **Administration** (this requires you to have admin permissions).<br>

   <div align="left"><figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FMnnwcAzg7Bu3vxaOYA2s%2FScreenshot%202023-06-28%20at%2011.31.42%20PM.png?alt=media&#x26;token=458bb0fd-a105-4a93-b121-b66d42e36ec7" alt="" width="375"><figcaption></figcaption></figure></div>
4. Go to the *API* section.
5. Copy your personal token. **Please note** that you can always regenerate a new token; however, doing so will cause the previous token to expire.

### Developer tab

If you are a **member user** or an **admin** on your monday.com account, follow these steps to access your API token:

1. Log into your monday.com account.
2. Click on your avatar/profile picture in the top right corner.
3. Select **Developer**. This will open the *Developer Center* in another tab.<br>

   <div align="left"><figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FPccCoxLLtxYGrrbS5fOU%2FScreenshot%202023-06-28%20at%2011.37.58%20PM.png?alt=media&#x26;token=d1287105-ca38-4626-b2c9-f57d5963d384" alt="" width="375"><figcaption></figcaption></figure></div>
4. Click **Developer** in the top menu.
5. Select **My Access Tokens**.<br>

   <div align="left"><figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2F9klURMQvAOuYxhi8CfNp%2FScreenshot%202023-06-28%20at%2011.41.22%20PM.png?alt=media&#x26;token=3f0ca384-e839-4d2e-94c4-5a676ee5edfe" alt="" width="272"><figcaption></figcaption></figure></div>
6. Click on the blue **Show** button to expose your API token and copy it. **Please note** that you can always regenerate a new token; however, doing so will cause the previous token to expire.

## Integrate Monday with Daton

1. Sign in to Daton
2. Select Monday from Integrations page
3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
4. In the next step you will be asked to enter Monday API key
5. Post successful authentication you will be prompted to choose required tables from the list
6. Then select all required fields
7. Submit the integration

## Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
2. Users would be able to edit/pause/re-activate/delete integration anytime
3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

## Monday Data

### Boards <a href="#billable-items" id="billable-items"></a>

Purpose: This API gives all the the meta data about different boards present. It contains data of board names, ids, creator, owners, different columns present in the board etc.

Source API Documentation: <https://developer.monday.com/api-reference/docs/boards>

Replication: Full Replication

Replication Key: N/A

**Fields**

| Name              | Data Type |
| ----------------- | --------- |
| board\_folder\_id | NUMERIC   |
| board\_kind       | STRING    |
| creator           | RECORD    |
| groups            | RECORD    |
| id                | NUMERIC   |
| item\_terminology | STRING    |
| items\_count      | NUMERIC   |
| name              | STRING    |
| owners            | RECORD    |
| permissions       | STRING    |
| state             | STRING    |
| subscribers       | RECORD    |
| top\_group        | RECORD    |
| type              | STRING    |
| updated\_at       | TIMESTAMP |

### BoardsData <a href="#billable-items" id="billable-items"></a>

Purpose: This API is used to fetch the items or values of all columns within the boards. If each board is equivalent to a table then item is a single row in that table. Boards Data table will fetch all the column values present in every board.

Source API Documentation: <https://developer.monday.com/api-reference/docs/column-values>

Replication: Full Replication

Replication Key: N/A

**Fields**

| Name       | Data Type |
| ---------- | --------- |
| boardid    | NUMERIC   |
| boardname  | STRING    |
| groupid    | STRING    |
| grouptitle | STRING    |
| itemid     | NUMERIC   |
| itemname   | STRING    |

### Users <a href="#billable-items" id="billable-items"></a>

Purpose: This API is used to fetches details of all the users part of account or organisation.

Source API Documentation: <https://developer.monday.com/api-reference/docs/users>

Replication: Full Replication

Replication Key: N/A

**Fields**

| Name                   | Data Type |
| ---------------------- | --------- |
| account                | RECORD    |
| birthday               | DATE      |
| country\_code          | STRING    |
| created\_at            | TIMESTAMP |
| current\_language      | STRING    |
| email                  | STRING    |
| enabled                | BOOLEAN   |
| id                     | NUMERIC   |
| is\_admin              | BOOLEAN   |
| is\_guest              | BOOLEAN   |
| is\_pending            | BOOLEAN   |
| is\_view\_only         | BOOLEAN   |
| is\_verified           | BOOLEAN   |
| last\_activity         | TIMESTAMP |
| location               | STRING    |
| name                   | STRING    |
| phone                  | NUMERIC   |
| photo\_original        | STRING    |
| photo\_small           | STRING    |
| photo\_thumb           | STRING    |
| photo\_thumb\_small    | STRING    |
| photo\_tiny            | STRING    |
| time\_zone\_identifier | STRING    |
| title                  | STRING    |
| url                    | STRING    |
| utc\_hours\_diff       | NUMERIC   |

### Updates <a href="#billable-items" id="billable-items"></a>

Purpose: This API is used to return all updates across an account

Source API Documentation: <https://developer.monday.com/api-reference/docs/updates>

Replication: Full Replication

Replication Key: N/A

**Fields**

| Name        | Data Type |
| ----------- | --------- |
| id          | NUMERIC   |
| created\_at | TIMESTAMP |
| creator\_id | NUMERIC   |
| item\_id    | NUMERIC   |
| text\_body  | STRING    |
| updated\_at | TIMESTAMP |