Schema Information of Monday Connector
This topic provides a structured reference to assist you in working with Daton's Monday connector and the associated fields and tables.
Schema Information of Monday Connector
This topic provides a structured reference to assist you in working with Daton's Monday connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Monday connector:
- Boards
- BoardsData
- Users
- Updates
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 |