Update multiple dropdowns in one call

monday Apps & Developers
,
1

Hi all,

I’m trying to update multiple dropdowns in the same item as once. Which each drop down containing multiple values.

I got this to work for one of them: {
“query”: “mutation {change_simple_column_value (item_id: 123456789, board_id: 123456789, column_id:"dropdown__1", value: "Frankie, Cupcake", create_labels_if_missing: true) {id}}”
}

{
“query”: “mutation {change_multiple_column_values (item_id: 123456789, board_id: 123456789, column_values: "{\"dropdown__1\": {\"value\": \"IFM - Non-Productized FM, LA - Lease Administration - Financial Management, OPM - Space & Occupancy Planning, PDS - WD Outsourcing, TM - Transaction Management - Transaction Management Essentials\"}, \"dropdown5__1\": { \"value\": \"Integrated Facilities Management, Lease Administration, Occupancy Planning & Management, Project and Development Services, Transaction Management\"}}", create_labels_if_missing: true) {id}}”
}

What am I missing? The call works and I get a status of 200, but the item doesn’t actually look to be touched.

TIA

2 
mutation {
  change_multiple_column_values(item_id:9876543210, board_id:1234567890, column_values: "{\"dropdown\":{\"labels\":[\"My label\", \"My Other Label\"]}}") {
    id
  }
}

note the structure of the column values, its serialized JSON. But I see you’re using “value” keys in this JSON, when you need “label” keys in the object for each column (for dropdowns). The value of these is an array of labels, not comma separated list.

I really suggest creating the change_values object as an actual object, then serializing it to JSON then including it within the query. (or better investigate using GraphQL variables, easily learned via a google search).

1 Like
4

Thank you! And yes, I’m using variables. :slight_smile: