Monday.com
Monday.com is a powerhouse for project management.
Monday.com integration replicates data using the Monday.com API.
See the Schema section for a list of objects available for replication.Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
Depending on your role in the app, the steps to retrieve the API token may vary.
For account admin users:
- Log into your Monday.com account.
- Click your profile picture in the top right corner.
- Click Administration > Connections > Personal API token.
- Copy and paste your API token into a secured file.
For other users:
- Log into your Monday.com account.
- Click your profile picture in the top right corner.
- Select Developers.
- Click API token > Show.
- Copy and paste your API token into a secured file.
Creating the connection
如需詳細資訊，請參閱連線到 SaaS 應用程式。
- 填寫所需的連線屬性。
在連線名稱中提供連線名稱。
選取開啟連線中繼資料以在建立後定義連線的中繼資料。
按一下建立。
| Setting | Description |
|---|---|
| Data gateway | 如您的使用情況有需要，選取 資料移動閘道。 資訊備註 此欄位無法用於 Qlik Talend Cloud 啟動器 訂閱，因為不支援 資料移動閘道。若您有另一個訂閱層級且不想使用 資料移動閘道，選取無。 如需關於 資料移動閘道 福利的資訊以及需要此項的使用案例，請參閱 Qlik 資料閘道 - 資料移動。 |
| Start Date | 以 |
| API Token | API token. |
Schema
Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 2.
Depending on your destination, table and column names may not appear as they are outlined below.
account
The account table contains info about the account data in your Monday.com account.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
assets
The assets table contains info about the assets in your Monday.com account.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
audit_event_catalogue
The audit_event_catalogue table contains info about the supported audit log events in your Monday.com account.
Replication Method | Full Table |
Primary Key | name |
| Useful links |
boards
The boards table contains info about the board data in your Monday.com account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
board_activity_logs
The board_activity_logs table contains info about the activity log data in your Monday.com account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
board_columns
The board_columns table contains info about the column data in your Monday.com account.
Replication Method | Full Table |
Primary Key | id board_id |
| Useful links |
board_groups
The board_groups table contains info about the group data in your Monday.com account.
Replication Method | Full Table |
Primary Key | id board_id |
| Useful links |
board_items
The board_items table contains info about the item data in your Monday.com account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
board_views
The board_views table contains info about the board view data in your Monday.com account.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
column_values
The column_values table contains info about the column value data in your Monday.com account.
Replication Method | Full Table |
Primary Key | id item_id |
| Useful links |
docs
The docs table contains info about the monday doc data in your Monday.com account.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
folders
The folders table contains info about the folder data in your Monday.com account.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
platform_api
The platform_api table contains info about the API usage data in your Monday.com account.
Replication Method | CDC |
Primary Key | daily_analytics.last_update |
| Useful links |
reply
The reply table contains info about other types supported by the monday platform API in your Monday.com account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
tags
The tags table contains info about the tag data in your Monday.com account.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
teams
The teams table contains info about the team data in your Monday.com account.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
updates
The updates table contains info about the updates data in your Monday.com account.
Replication Method | CDC |
Primary Key | id |
| Useful links |
users
The users table contains info about the user data in your Monday.com account.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
workspaces
The workspaces table contains info about the workspace data in your Monday.com account.
Replication Method | Full Table |
Primary Key | id |
| Useful links |