Generic Error when moving item via move_item_to_board

monday Apps & Developers
, , , , , , ,
1

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

2

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 :smile:

Cheers,
Matias

3

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

4

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 :smile:

5

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
    }
    ]
}
6

Happy to help @JoelMorl !!