InvalidColumnIdException: This column ID doesn't exist for the board

monday Apps & Developers
, ,
1

Hello,

I am having some trouble changing the values of items via API. I am trying to change three columns, the name, duration, and number26. My request looks like this:

{ 
	"query": 
		"mutation {change_multiple_column_values( item_id:6062965817, board_id:6062799445, 
		column_values: "{
			"duration":"5",
			"numbers26":"3",
			"name":"Receive (LV PCBA Parallel Path)"
			}" ) {id}
		}" 
}

When I submit the request, I get an odd error about the column not existing for the board:

{
  "error_code": "InvalidColumnIdException",
  "status_code": 200,
  "error_message": "This column ID doesn't exist for the board",
  "error_data": {
    "column_id": "duration",
    "board_id": null,
    "error_reason": "store.monday.automation.error.missing_column"
  }
}

This is a subitem in the board and have verified that duration is the name of the column using the developer tools:

image

Can someone help me figure out how to update this column?

  • I verified the request just changing the name, and that worked.
  • Should the board_id be null in the response? That seems odd.
  • Is my syntax correct for updating multiple items concurrently?
  • Is the process for editing subitems different than editing items?

Thank you for any help!

E

2

UPDATE: Now, just when updating the name, the API return seems to indicate that the item cannot be found at all. Here is the return message:

{
    "error_code": "ResourceNotFoundException",
    "status_code": 404,
    "error_message": "Item not found in board",
    "error_data": {
        "resource_type": "item",
        "item_id": 5867901791,
        "pulse_id": 5867901791,
        "board_id": 5800924762,
        "error_reason": null
    }
}

When looking at the URL of the item, the IDs seem to all match:

https://oxos.monday.com/boards/5800924762/pulses/5867901791?term=Determine%20images%20needed%20for%20lower%20extremity%20set

Any insight would be much appreciated!

Thank you,

E

1 Like
3

Subitems have a different board ID than the main board ID.

When you query an item for subitems, return the board{id} on the subitems.

Additionally you can do

{
 boards(ids: $mainboardId){
  columns(ids: ["subitems"]) {
   id
   settings_str
  }
 }
}

the settings_str is JSON which will contain a reference to the subitem board ID.

You can also just query the item for its board ID first (at some point in the process)

{
  items(ids: $itemIds) {
   board {
    id
   }
 }
}
1 Like
5

Hey Cody,

This was exactly the problem. Thanks for the tip!

E

1 Like
6

Thank you @anon29275264 !!