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:

  1. Log into your monday.com account.

  2. Click on your avatar/profile picture in the top right corner.

  3. Select Administration (this requires you to have admin permissions).

  4. Go to the API section.

  5. 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:

  1. Log into your monday.com account.

  2. Click on your avatar/profile picture in the top right corner.

  3. Select Developer. This will open the Developer Center in another tab.

  4. Click Developer in the top menu.

  5. Select My Access Tokens.

  6. 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

  1. Sign in to Daton

  2. Select Monday from Integrations page

  3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

  4. In the next step you will be asked to enter Monday API key

  5. Post successful authentication you will be prompted to choose required tables from the list

  6. Then select all required fields

  7. Submit the integration

Workflow

  1. 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

  2. Users would be able to edit/pause/re-activate/delete integration anytime

  3. 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