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
Mer information finns i Koppla till SaaS-program.
- Ange de kopplingsegenskaper som krävs.
Ange ett namn på kopplingen i Kopplingsnamn.
Välj Öppna kopplingsmetadata för att definiera metadata för kopplingen när den har skapats.
Klicka på Skapa.
| Setting | Description |
|---|---|
| Data gateway | Välj en Gateway för dataflytt om det krävs för ditt användningsfall. Anteckning om information Detta fält är inte tillgängligt med Qlik Talend Cloud Starter-prenumerationen eftersom den inte stöder Gateway för dataflytt. Om du har en annan prenumerationsnivå och inte vill använda Gateway för dataflytt väljer du Inget. Information om fördelarna med Gateway för dataflytt och användningsfall som kräver det finns i Qlik Data Gateway – dataflytt. |
| Start Date | Ange det datum, i formatet |
| 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 |