Monday

Monday, ETL connector for data replication

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	Key Based Replication, Full Replication
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).

   
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.

   
4. Click Developer in the top menu.

5. Select My Access Tokens.

   
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

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

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

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

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