How to update columns of an item, without item id

We have uploaded a list of patients, including the patient_id (Unique identifier for finding the patient) to a board. We need to update the patient columns via API, using the patient_id. How we can do this flow.

Hello @akhilg,
At the moment, you cannot update items using column values. You will have to query the items to get their ids and then use those ids to them the items

Hello there @akhilg and welcome to the community!

I hope you like it here :muscle:

As @kolaai said, you will need to query for the item ID of each of these items using the patient ID you have, and then use the item ID to mutate data in the item.

How to get the item ID this with API version 2023-07: Items by column values

How to get the item ID with API version 2023-10: Items page by column values

Let me know if you have any other questions :slightly_smiling_face:


Thanks @kolaai and @Matias.Monday for the response,

Also we have more than 20k records, so the record might split into different boards, So I there any we can update an item without knowing the board_id.

The ultimate goal is update an item record. And we only have patient_id.
For using this Items page by column values it requires both board_id and item_id. So how effectevely use this…

Hello again @akhilg,

If you only have the patient ID, and that item can be in any board, in that case you would need to check ALL the items in ALL your boards. You have to know that this might take a very long time to do each time:

  boards(ids: [1234567890, 1122334455, ... THE ID OF ALL YOUR BOARDS]) {
    items(limit: 100, page: 1) {
      column_values {

and then you would iterate through all the pages until the result is empty.

This is not a great flow to have. It would be much better if you could save the board ID of each item to know where to look for it.


1 Like