I appear to be unable to to move items between boards while defining the columns to be used.
I have tried moving items with, and without the formula column in make.com and each time I get “[200] Columns mapping is not in the expected format” error message.
I can move items when I do not map any columns. However, I do not want to leave it up to monday’s “best match” for the columns to be transferred correctly.
Here is a sample query where i tried to move just column, and ignore all other columns, it still returned the error.
mutation {
move_item_to_board (
board_id:2066419154,
group_id:"new_group43041",
item_id:2078918789,
columns_mapping: [{source:"name",target:null},
{source:"color_mkt2e6kn",target:null},
{source:"date_mksw4z9a",target:null},
{source:"text_mksw69zy",target:"text_mksw69zy"},
{source:"board_relation_mkswktg5",target:null},
{source:"lookup_mkt4ny2v",target:null},
{source:"lookup_mkt0g869",target:null},
{source:"lookup_mkt0fyrg",target:null},
{source:"lookup_mkt4g7fh",target:null},
{source:"lookup_mksxaze3",target:null},
{source:"lookup_mkt0rp00",target:null},
{source:"text_mksvxcfz",target:null},
{source:"text_mkt095d5",target:null},
{source:"text_mksvgxdt",target:null},
{source:"text_mksvahkf",target:null},
{source:"color_mkswsps8",target:null},
{source:"text_mksva9mh",target:null},
{source:"text_mksvekss",target:null},
{source:"text_mksvy4ta",target:null},
{source:"text_mksvm0nv",target:null},
{source:"date_mksydqga",target:null},
{source:"last_updated",target:null},
{source:"pulse_log_mksw8jaj",target:null},
{source:"text_mkswp7t4",target:null},
{source:"text_mksvb3fx",target:null},
{source:"text_mksvnj2t",target:null},
{source:"text_mksvtyqs",target:null},
{source:"text_mkswzd72",target:null},
{source:"text_mkswrc3b",target:null},
{source:"date_mksvfejk",target:null},
{source:"text_mksvczgd",target:null},
{source:"text_mksvcmt1",target:null},
{source:"text_mksv6ted",target:null},
{source:"text_mksvq0ze",target:null},
{source:"pulse_id_mksx17r0",target:null}]
) {
id
name
}
}
Here is a list of columns of the source board:
**column_id column_type column_title**
name name Name
color_mkt2e6kn status Invoice Status
date_mksw4z9a date Finished At Date
text_mksw69zy text ⭐Year Month
text_mksvxcfz text task_name
text_mkt095d5 text department
text_mksvgxdt text ⭐ task_id
text_mksvahkf text ⭐ property_id
text_mksva9mh text property_name
text_mksvekss text property_status
text_mksvy4ta text assignee_id
text_mksvm0nv text assignee_name
date_mksydqga date ⭐ task_last_updated
last_updated last_updated Last updated
pulse_log_mksw8jaj creation_log Creation log
text_mkswp7t4 text total_time
text_mksvb3fx text rate_type
text_mksvnj2t text started_at
text_mksvtyqs text finished_at
formula_mksx5p6b formula Finish Hour
text_mkswzd72 text ⭐ task_status_stage
text_mkswrc3b text task_status_code
date_mksvfejk date ⭐ schduled_date_time
text_mksvczgd text created_by
text_mksvcmt1 text created_at
text_mksv6ted text task_tags
text_mksvq0ze text breezeway_report_link
pulse_id_mksx17r0 item_id Item ID
Here is a list of columns of the target board:
**column_id column_type column_title**
name name Name
color_mkt2e6kn status Invoice Status
date_mksw4z9a date Finished At Date
text_mksw69zy text ⭐Year Month
board_relation_mkswktg5 board_relation Property
lookup_mkt4ny2v mirror Property Invoiceable Status
lookup_mkt0g869 mirror Price per Clean exVAT GBP
lookup_mkt0fyrg mirror Client Name
lookup_mkt4g7fh mirror Client Invoiceable Status
lookup_mksxaze3 mirror Invoice Frequency
lookup_mkt0rp00 mirror Xero Contact ID
text_mksvxcfz text task_name
text_mkt095d5 text department
text_mksvgxdt text ⭐ task_id
text_mksvahkf text ⭐ property_id
color_mkswsps8 status connect
text_mksva9mh text property_name
text_mksvekss text property_status
text_mksvy4ta text assignee_id
text_mksvm0nv text assignee_name
date_mksydqga date ⭐ task_last_updated
last_updated last_updated Last updated
pulse_log_mksw8jaj creation_log Creation log
text_mkswp7t4 text total_time
text_mksvb3fx text rate_type
text_mksvnj2t text started_at
text_mksvtyqs text finished_at
formula_mksx5p6b formula Finish Hour
text_mkswzd72 text ⭐ task_status_stage
text_mkswrc3b text task_status_code
date_mksvfejk date ⭐ schduled_date_time
text_mksvczgd text created_by
text_mksvcmt1 text created_at
text_mksv6ted text task_tags
text_mksvq0ze text breezeway_report_link
pulse_id_mksx17r0 item_id Item ID
If someone could to show me the exact query I would need to make that would work, that would be much appreciated.