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
Para obter mais informações, consulte Conectando-se a aplicativos SAP.
- Preencha as propriedades de conexão obrigatórias.
Forneça um nome para a conexão em Nome da conexão.
Selecione Abrir metadados de conexão para definir metadados para a conexão quando ela for criada.
Clique em Criar.
| Setting | Description |
|---|---|
| Data gateway | Selecione um Gateway Data Movement se for necessário para seu caso de uso. Nota informativa Esse campo não está disponível com a assinatura do Iniciante do Qlik Talend Cloud, pois esta não é compatível com o Gateway Data Movement. Se você tiver outro nível de assinatura e não quiser usar o Gateway Data Movement, selecione Nenhum. Para obter informações sobre os benefícios do Gateway Data Movement e casos de uso que exigem isso, consulte Qlik Data Gateway - Movimentação de dados. |
| Start Date | Digite a data, no formato |
| 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 |