Skip to main content

Good afternoon,


I am having trouble with the move_item_to_board mutation.


Query


mutation MoveDuplicateRequestItem
($board: ID!, $group: ID!, $item: ID!, $columnMapping: [ColumnMappingInput!])
{
move_item_to_board (
board_id: $board,
group_id: $group,
item_id: $item,
columns_mapping: $columnMapping ) {
id
}
}

Variables:


{
"board": 7,
"group": "group_title",
"item": 7,
"columnMapping": [
{
"source": "files__1",
"target": "files__1"
},
{
"source": "person",
"target": "person"
},
{
"source": "text__1",
"target": null
},
{
"source": "link__1",
"target": null
},
{
"source": "status",
"target": null
},
{
"source": "priority__1",
"target": null
},
{
"source": "label__1",
"target": null
},
{
"source": "label2__1",
"target": null
},
{
"source": "label_1__1",
"target": "type__1"
},
{
"source": "text3__1",
"target": "workflow_name__1"
},
{
"source": "text5__1",
"target": "workflow_id__1"
},
{
"source": "link7__1",
"target": "workflow_link__1"
},
{
"source": "long_text9__1",
"target": "long_text__1"
},
{
"source": "dropdown__1",
"target": "tags__1"
},
{
"source": "numbers__1",
"target": "time_savings__1"
},
{
"source": "ldate4",
"target": null
},
{
"source": "long_text__1",
"target": "notes__1"
},
{
"source": "files_1__1",
"target": "documentation__1"
},
{
"source": "checkbox__1",
"target": null
}
]
}

I am not getting any syntax warnings before the query but I am getting back:


{
"error_message": "Columns mapping is not in the expected format",
"error_code": "GraphqlGeneralError",
"error_data": {},
"status_code": 200,
"account_id": 1
}

All columns are mapped, and I have triple checked ID’s.

I have tried removing the double quotes from around source and target in the columnMapping variables, this does through a syntax error. This particular item has sub items. Does these have to be mapped out as well? Any help would be appreciated.


Thank you

Hello there @JoelMorl,


Are the connect boards columns in both boards configured in the exact same way?


Also, I see an ID that says “ldate4”. Is that correct or is it “date4”?


Looking forward to hearing from you 😀


Cheers,

Matias


Can we integrate Whatsapp to import all incoming messages and requests but be tagged back to an Item or Board?. @JoelMorl @Matias.Monday @Jessie_Plumpton @linhle @Jodi


Hello there @Izzy, please open a new topic for that question or fill this form so we can tackle said question there and not in this unrelated topic 😀


That was definitely an issue but no the issue. That type caused me to go back one by one and the target: workflow_name__1 was an old column that had since been removed. My brain just kept adding it back in for some reason.


Once I removed that mapping and the typo it sent without any issue.


Thanks Matias


{
"board": 7,
"group": "new_group",
"item": 7,
"columnMapping": [
{
"source": "files__1",
"target": "files__1"
},
{
"source": "person",
"target": "person"
},
{
"source": "text__1",
"target": null
},
{
"source": "link__1",
"target": null
},
{
"source": "status",
"target": null
},
{
"source": "priority__1",
"target": null
},
{
"source": "label__1",
"target": null
},
{
"source": "label2__1",
"target": null
},
{
"source": "label_1__1",
"target": "type__1"
},
{
"source": "text3__1",
"target": null
},
{
"source": "text5__1",
"target": "workflow_id__1"
},
{
"source": "link7__1",
"target": "workflow_link__1"
},
{
"source": "long_text9__1",
"target": "long_text__1"
},
{
"source": "dropdown__1",
"target": null
},
{
"source": "numbers__1",
"target": "time_savings__1"
},
{
"source": "date4",
"target": null
},
{
"source": "long_text__1",
"target": "notes__1"
},
{
"source": "files_1__1",
"target": "documentation__1"
},
{
"source": "checkbox__1",
"target": null
}
]
}

Happy to help @JoelMorl !!


Reply