Monday.com

Adicionando o conector

Baseado na documentação da API do Monday.com

Este conector está em modo beta

Requisitos

Siga as instruções abaixo com um usuário administrador (admin) ou desenvolvedor (developer)

Instruções

1) Acesse o site e faça login em monday.com | A new way of working utilizando um usuário com o perfil admin ou developer

Para usuários com outro perfil, os passos serão diferentes e as integrações podem não funcionar como esperado

2) Após fazer login, clique no seu avatar no canto superior direito da tela para abrir o menu suspenso e clique em “Desenvolvedores”

3) Na página de desenvolvedores, vá para “Meus tokens de acesso”, clique em mostrar e copie o valor exibido na caixa da página

4) Faça login na platforma da Kondado, selecione o conector do Monday.com, dê um nome para o seu conector e, em “Access Token”, cole o valor obtido no passo 3

Agora basta clicar em SALVAR para começar a receber dados do Monday.com no seu Data Warehouse, Data Lake ou planilha

Integrações

Índice

Configurações de quadros
Itens de quadro
Itens: Conversas (atualizações)
Logs de atividades
Usuarios

Gráfico de relacionamento

Clique para ampliar

Para as integrações onde é possível deletar registros, você pode escolher utilizar a integração no modo integral no último passo do processo de criação caso queira que estas alterações sejam refletidas em sua integração. Caso contrário, registros removidos continuarão em suas tabelas.

Para a integração de itens de quadros, elementos que exibam o texto de opções selecionadas (por exemplo, para campos do tipo lista de opções), utilizar a integração incremental não irá atualizar o texto já escrito na tabela caso a opção tenha seu texto alterado. Para estes casos, recomendamos utilizar o modo integral

A alteração de alguns campos pode não refletir na data de atualização do registro – por exemplo, para campos alterados de maneira automática ou via integração. Para estes casos, recomendamos utilizar o modo integral

Itens de quadro

Campo	Tipo
id	text	[en] id of the item
updated_at	timestamp
name	text	[pt] Name of the item
state	text	[pt] State of the item
board_id	text	[en] The unique identifier of the board. Configurações de quadros > > board_id
group_id	text	[en] The id of the group that item belongs.
group_title	text	[en] The title of the group that item belongs.
workspace_id	text	[en] The unique identifier of the board's workspace. Returns null for the Main workspace.
parent_item_id	text	[en] If item is a subitem, the id of its parent
property_x	text	[en] an example of a custom property
property_y	float	[en] an example of a custom property
property_z	date	[en] an example of a custom property

Itens: Conversas (atualizações)

Objeto principal

Campo	Tipo
id	text	[en] The update's unique identifier.
item_id	text	[en] The update's item ID. Itens de quadros > > id
text_body	text	[en] The update's text body.
created_at	timestamp	[en] The update's creation date.
creator_id	text	[en] Id of the user that created this update. Usuarios > > user_id
creator_name	text	[en] Name of the user that created this update.

monday_itens_conversations_replies

Campo	Tipo
id	text	[en] The parent update's unique identifier.
replies_body	text	[en] The update's reply text body.
replies_created_at	timestamp	[en] The update's reply creation date.
replies_creator_name	text	[en] The update's reply creator name.
replies_creator_id	text	[en] The update's reply creator id. Usuarios > > user_id
replies_id	text	[en] The update's reply ID.

Logs de atividades

Campo	Tipo
id	text	[en] The unique identifier of the activity log event.
account_id	text	[en] The unique identifier of the account that initiated the event.
created_at	timestamp	[en] The time of the event.
entity	text	[en] The entity of the event that was changed: pulse or board.
event	text	[en] The action that took place.
user_id	text	[en] The unique identifier of the user who initiated the event. Usuarios > > user_id
action_record_id	text	[en] The id of a pulse transference from boards availabe when the event is one of: move_pulse_from_board, move_pulse_into_board, move_pulse_from_group, move_pulse_into_group
board_id	text	[en] The board id, used in all types of logs Configurações de quadros > > board_id
column_id	text	[en] The colum id (string), availabe when the event is one of: create_column change_column_settings, update_column_name, delete_column, restore_column
column_title	text	[en] The column title, availabe when the event is one of: create_column, change_column_settings, update_column_name, delete_column, restore_column
column_type	text	[en] The column type, availabe when the event is one of: create_column, change_column_settings, update_column_name, delete_column, restore_column
dest_board_id	text	[en] Id of the board that will receive the moved item, availabe when the event is one of: move_pulse_from_board, move_pulse_into_board
dest_board_kind	text	[en] The type of board to which the pulse was moved, used in move_pulse_from_board, move_pulse_into_board
dest_board_name	text	[en] The name of board to which the pulse was moved, used in move_pulse_from_board, move_pulse_into_board
dest_group_color	text	[en] The color of the group to which the pulse was moved, used in move_pulse_from_group, move_pulse_into_group
dest_group_id	text	[en] The id of the group to which the pulse was moved, used in move_pulse_from_group, move_pulse_into_group
dest_group_is_top_group	boolean	[en] The hierarchy of the group to which the pulse was moved, used in move_pulse_from_group, move_pulse_into_group
dest_group_title	text	[en] The title of the group to which the pulse was moved, used in move_pulse_from_group, move_pulse_into_group
group_color	text	[en] The group color, availabe when the event is one of: move_pulse_from_group, move_pulse_into_group, create_group, update_group_name, update_group_color, delete_group, archive_group, restore_group and create_pulse
group_id	text	[en] The group id, availabe when the event is one of: move_pulse_from_group, move_pulse_into_group, create_group, update_group_name, update_group_color, delete_group, archive_group and restore_group
group_name	text	[en] The group name, availabe when the event is one of: move_pulse_from_group, move_pulse_into_group, create_group, update_group_name, update_group_color, delete_group, archive_group and restore_group
group_title	text	[en] The group title, availabe when the event is one of: move_pulse_from_group, move_pulse_into_group, create_group, update_group_name, update_group_color, delete_group, archive_group and restore_group
is_batch_action	boolean	[en] When this is a batch action, availabe when the event is one of: move_pulse_from_board, move_pulse_into_board, move_pulse_from_group, move_pulse_into_group
is_column_with_hide_permissions	boolean	[en] Whenever a colum has hide permissions
is_top_group	boolean	[en] Whenever has more than one group, one stay on top, used in create_group, update_group_name, update_group_color, delete_group, archive_group, restore_group
is_undo_action	boolean	[en] When this is an undo action, availabe when the event is one of: restore_pulse, board_view_restored, restore_group, restore_column
item_id	text	[en] The item id, availabe when the event is one of: subscribe or add_owner Itens de quadros > > id
item_name	text	[en] The item name, availabe when the event is one of: subscribe or add_owner
item_type	text	[en] The item type, availabe when the event is one of: subscribe or add_owner
previous_value_color	text	[en] The old value of color, availabe when the event is : update_group_color
previous_value_hidden	boolean	[en] When a board nickname was modified, this represents if is a hidden val
previous_value_labels	text	[en] The old value of labes availabe when the event is: update_column_name
previous_value_name	text	[en] The old name value availabe when the event is one of: update_board_nickname, update_name, update_group_name, update_column_name
previous_value_permission	text	[en] When a permission was updated, this is the new value, availabe when the event is one of:update_board_permissions, update_board_view_permissions
previous_value_plural	text	[en] The old name in plural availabe when the event is one of: update_board_nickname, update_name, update_group_name, update_column_name
previous_value_preset_type	text	[en] The old preset type availabe when the event is one of: update_board_nickname, update_name, update_group_name, update_column_name
previous_value_singular	text	[en] The old name in singular availabe when the event is one of: update_board_nickname, update_name, update_group_name, update_column_name
previous_value_state	float	[en] The old value state value of a pulse availabe when the event is one of: delete_pulse, archive_pulse, restore_pulse
pulse_id	text	[en] The id of the pulse, availabe when the event is one of: subscribe, add_owner, create_pulse, delete_pulse, archive_pulse, restore_pulse, move_pulse_from_board, move_pulse_into_board, move_pulse_from_group or move_pulse_into_group
pulse_name	text	[en] The name of the pulse, availabe when the event is one of: subscribe, add_owner, create_pulse, delete_pulse, archive_pulse, restore_pulse, move_pulse_from_board, move_pulse_into_board, move_pulse_from_group or move_pulse_into_group
source_board_id	text	[en] The if of board, availabe when the event is one of: move_pulse_from_board, move_pulse_into_board, move_pulse_from_group, move_pulse_into_group
source_board_kind	text	[en] The kind of the source board, availabe when the event is one of: move_pulse_from_board, move_pulse_into_board, move_pulse_from_group, move_pulse_into_group
source_board_name	text	[en] The name of the source board, availabe when the event is one of: move_pulse_from_board, move_pulse_into_board, move_pulse_from_group, move_pulse_into_group
source_group_color	text	[en] The color of the source board, availabe when the event is one of: move_pulse_from_board, move_pulse_into_board, move_pulse_from_group, move_pulse_into_group
source_group_id	text	[en] The id of the source board, availabe when the event is one of: move_pulse_from_board, move_pulse_into_board, move_pulse_from_group, move_pulse_into_group
source_group_is_top_group	boolean	[en] When a pulse is moved from a board, if it comes from a top group availabe when the event is one of: move_pulse_from_board, move_pulse_into_board, move_pulse_from_group, move_pulse_into_group
source_group_title	text	[en] The source board title availabe when the event is one of: move_pulse_from_board, move_pulse_into_board, move_pulse_from_group, move_pulse_into_group
subscribed_id	text	[en] The user id availabe when the event is one of: subscribe, unsubscribe
textual_value	text	[en] Text value availabe when the event is: update_column_value
value_board_view_id	text	[en] The id of the view availabe when the event is: board_view_added, board_view_deleted, board_view_changed, board_view_enabled, board_view_disabled, board_view_regenerate_token, board_view_restored, board_view_duplicated
value_color	text	[en] New color availabe when the event is: update_group_color
value_labels	text	[en] The new value of labes availabe when the event is: update_column_name
value_name	text	[en] The new value of name availabe when the event is one of: create_pulse, delete_pulse, archive_pulse, restore_pulse, move_pulse_from_board, move_pulse_into_board, move_pulse_from_group, move_pulse_into_group
value_permission	text	[en] The neu permission availabe when the event is one of: update_board_permissions, update_board_view_permissions
value_plural	text	[en] The plural name of field availabe when the event is one of: update_board_nickname, update_group_name, update_column_name, update_name
value_preset_type	text	[en] The preset name of field availabe when the event is one of: update_board_nickname, update_group_name, update_column_name, update_name
value_singular	text	[en] The singular name of field availabe when the event is one of: update_board_nickname, update_group_name, update_column_name, update_name
value_state	float	[en] New pulse state availabe when the event is one of: delete_pulse, archive_pulse, restore_pulse.
value_value	text	[en] The new value availabe when the event is one of: update_column_value, update_name, update_board_nickname, create_update, update_group_name, update_group_color, update_column_name, update_board_permissions, update_board_view_permissions
value_view_type	text	[en] The new view type availabe when the event is one of: update_board_view_permissions, board_view_added, board_view_deleted, board_view_changed, board_view_enabled, board_view_disabled, board_view_regenerate_token, board_view_restored, board_view_duplicated
raw_data	text	[en] The item's column values.

Usuarios

Objeto principal

Campo	Tipo
user_id	text	[en] The user's unique identifier. Configurações de quadros > users_subscribers > users_subscribers_id
account_id	text
account_name	text
birthday	text	[en] The user's date of birth.
country_code	text	[en] The user's country code.
created_at	timestamp	[en] The user's creation date
current_language	text	[en] The user's language.
email	text	[en] The user's email.
enabled	boolean	[en] Returns true if the user is enabled.
is_admin	boolean	[en] Returns true if the user is an admin.
is_guest	boolean	[en] Returns true if the user is a guest.
is_pending	boolean	[en] Returns true if the user didn't confirm their email yet.
is_verified	boolean	[en] Returns true if the user verified their email.
is_view_only	boolean	[en] Returns true if the user is only a viewer.
join_date	timestamp	[en] The date the user joined the account
last_activity	timestamp	[en] The last date and time the user was active
location	text	[en] The user's location.
mobile_phone	text	[en] The user's mobile phone number.
name	text	[en] The user's name.
out_of_office	text	[en] The user's out-of-office status.
phone	text	[en] The user's phone number.
photo_original	text	[en] Returns the URL of the user's uploaded photo in its original size.
photo_small	text	[en] Returns the URL of the user's uploaded photo in a small size (150×150 px).
photo_thumb	text	[en] Returns the URL of the user's uploaded photo in thumbnail size (100×100 px).
photo_thumb_small	text	[en] Returns the URL of the user's uploaded photo in a small thumbnail size (50×50 px).
photo_tiny	text	[en] Returns the URL of the user's uploaded photo in tiny size (30×30 px).
sign_up_product_kind	text	[en] The product the user first signed up to.
time_zone_identifier	text	[en] The user's timezone identifier.
title	text	[en] The user's title.
url	text	[en] The user's profile URL.
utc_hours_diff	float	[en] The user’s UTC hours difference.

monday_users_teams

Campo	Tipo
user_id	text	[en] The user's unique identifier.
teams_id	text
teams_name	text

Configurações de quadros

Objeto principal

Campo	Tipo
board_id	text	[en] The board's unique identifier.
board_folder_id	text	[en] The unique identifier of the folder that contains the board(s). Returns null if the board is not in a folder.
board_kind	text	[en] The type of board: public, private, or share.
creator_id	text
description	text	[en] The board's description.
item_terminology	text	[en] The nickname for items on the board. Can be a predefined or custom value.
items_count	float	[en] The number of items on the board.
name	text	[en] The board's name.
permissions	text	[en] The board's permissions: everyone, collaborators, assignee, or owners.
state	text	[en] The board's state: all, active, archived, or deleted.
top_group_id	text
type	text	[en] The board's object type: board, sub_items_board, document, or custom_object.
updated_at	timestamp	[en] The last time the board was updated.
workspace_id	text	[en] The unique identifier of the board's workspace. Returns null for the Main workspace.
workspace_name	text	[en] The name from that workspace.

monday_boards_columns

Campo	Tipo
board_id	text	[en] The board's unique identifier.
columns_id	text
columns_title	text

monday_boards_users_subscribers

Campo	Tipo
board_id	text	[en] The board's unique identifier.
users_subscribers_email	text	[en] The user's email.
users_subscribers_id	text	[en] The user's unique identifier.
users_subscribers_name	text	[en] The user's name.
users_subscribers_title	text	[en] The user's title.