Monday
Monday, ETL connector for data replication
Snapshot
Tables/APIs Supported
Generating API key for Monday
To configure Monday, you will need the API token for your account. You can get your API token in following ways:
Admin tab
If you are an admin user on your monday.com account, follow these steps to access your API token:
Log into your monday.com account.
Click on your avatar/profile picture in the top right corner.
Select Administration (this requires you to have admin permissions).
Go to the API section.
Copy your personal token. Please note that you can always regenerate a new token; however, doing so will cause the previous token to expire.
Developer tab
If you are a member user or an admin on your monday.com account, follow these steps to access your API token:
Log into your monday.com account.
Click on your avatar/profile picture in the top right corner.
Select Developer. This will open the Developer Center in another tab.
Click Developer in the top menu.
Select My Access Tokens.
Click on the blue Show button to expose your API token and copy it. Please note that you can always regenerate a new token; however, doing so will cause the previous token to expire.
Integrate Monday with Daton
Sign in to Daton
Select Monday from Integrations page
Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
In the next step you will be asked to enter Monday API key
Post successful authentication you will be prompted to choose required tables from the list
Then select all required fields
Submit the integration
Workflow
Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Monday Data
Boards
Purpose: This API gives all the the meta data about different boards present. It contains data of board names, ids, creator, owners, different columns present in the board etc.
Source API Documentation: https://developer.monday.com/api-reference/docs/boards
Replication: Full Replication
Replication Key: N/A
Fields
BoardsData
Purpose: This API is used to fetch the items or values of all columns within the boards. If each board is equivalent to a table then item is a single row in that table. Boards Data table will fetch all the column values present in every board.
Source API Documentation: https://developer.monday.com/api-reference/docs/column-values
Replication: Full Replication
Replication Key: N/A
Fields
Users
Purpose: This API is used to fetches details of all the users part of account or organisation.
Source API Documentation: https://developer.monday.com/api-reference/docs/users
Replication: Full Replication
Replication Key: N/A
Fields
Updates
Purpose: This API is used to return all updates across an account
Source API Documentation: https://developer.monday.com/api-reference/docs/updates
Replication: Full Replication
Replication Key: N/A
Fields
Last updated