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
Weitere Informationen finden Sie unter Herstellung einer Verbindung zu SaaS-Anwendungen.
- Füllen Sie die erforderlichen Verbindungseigenschaften aus.
Geben Sie einen Namen für die Verbindung in Verbindungsname ein.
Wählen Sie Verbindungsmetadaten öffnen aus, um nach der Erstellung Metadaten für die Verbindung zu definieren.
Klicken Sie auf Erstellen.
| Setting | Description |
|---|---|
| Data gateway | Wählen Sie ein Data Movement Gateway aus, wenn dies für Ihren Anwendungsfall erforderlich ist. Informationshinweis Dieses Feld ist für das Qlik Talend Cloud Starter-Abonnement nicht verfügbar, da dieses Abonnement Data Movement Gateway nicht unterstützt. Wenn Sie eine andere Abonnementstufe haben und Data Movement Gateway nicht verwenden möchten, wählen Sie Keine. Weitere Informationen zu den Vorteilen von Data Movement Gateway und den Anwendungsfällen, in denen es erforderlich ist, finden Sie unter Qlik Data Gateway – Datenbewegung. |
| Start Date | Geben Sie das Datum im Format |
| 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 |