Skip to main content

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

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

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


GraphQL API

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

   }

 }

}

Hey Cody,


This was exactly the problem. Thanks for the tip!


E

Thank you @anon29275264 !!

Reply


Terms & ConditionsCookie settings