Move Item to Board

monday Apps & Developers Feature Requests - API and Apps Framework
,
21

Has anyone got this to work?

I just receive

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

whenever I try to use the columns_mapping argument.

EDIT: Okay so I have managed to get columns_mapping working for basic boards. It seems that all the columns require some sort of value. However, this becomes more complex with larger boards. For instance, we probably shouldn’t map autonumber, mirror, or formula columns, but we do want to map connect boards columns etc.

Mapping all the columns doesn’t work, but there is little guidance on which ones to remove.

I’ll keep updating if I can figure this out through testing.

EDIT2: Some progress:

  • Formula - Do not include
  • Name - Do not include
  • Subitems - They have their own mapping (subitems_columns_mapping). Do not try and include the “subitems” column that is returned by the API.
  • Auto Number - Include
  • Creation Log - Include
  • Mirror - Include
  • Integration (e.g. Salesforce) - Include

Naturally, you’ll want to set any of the above inclusions to null. No idea if you could map the Salesforce column.

There may be more rules to this but I have had success following the rules above. Great!