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
Pour plus d'informations, consultez Connexion à des applications SaaS.
- Complétez les propriétés de connexion requises.
Fournissez un nom pour la connexion dans Nom de la connexion.
Sélectionnez Ouvrir les métadonnées de connexion pour définir les métadonnées de la connexion lors de sa création.
Cliquez sur Créer.
| Setting | Description |
|---|---|
| Data gateway | Sélectionnez une Passerelle de déplacement des données si cela est nécessaire pour votre cas d'utilisation. Note Informations Ce champ n'est pas disponible avec l'abonnement Démarreur Qlik Talend Cloud, car il ne supporte pas Passerelle de déplacement des données. Si vous avez un autre niveau d'abonnement et si vous ne souhaitez pas utiliser Passerelle de déplacement des données, sélectionnez Aucune. Pour des informations sur les avantages de Passerelle de déplacement des données et les cas d'utilisation qui la nécessitent, consultez Passerelle de données Qlik - Déplacement des données. |
| Start Date | Saisissez la date, au 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 |