How to get progress columns values

Hi, I;m failing to get progress columns value.
Here is what I did.

Request Query: 

query {
boards(ids:[5xxxxxxxxx], limit:1) {
items {
name
group {
id
}

  column_values {
    id
    value
    text
  }
}

}
}

Response Data:

{
“id”: “progress”,
“value”: null,
“text”: “”
}

Hi @Nir-Jetpack,

Welcome to the developer community!

Unfortunately, there are a few column types that aren’t able to be retrieved using the API at this stage. This is because the value of this column is calculated on the client-side.

Your best option at this stage would be to query all of the status columns and calculate the progress in your application.

1 Like

Ok thanks. Is this the same for number of votes? In votes column…

Hey there Nir,

That’s a great question!

Based on what I could come up with after querying one of my boards with a Vote column, it seems like you should be able to get the Vote values from items, even including the users who have cast the vote. Here’s what I’m seeing on my end:

I’m sure you are already making more complex queries than I am, but here’s what I’ve used to get the result above:


    {
      boards(ids: 640319898)
      {name
      id
        items{
          name
          column_values{
            value
            text
            type
          }
        }
      }
    } 

In that case, you can also see which of the users within your account have voted for a particular item. For example, [9603417] stands for my user ID. Does that make sense?

There was also a similar question asked here. I recommend checking the community topics, in general, to find out if your questions have been answered already. Then, you can get the solutions you need faster :slight_smile:

-Alex

1 Like

Got it! Thanks Alex!

Just to expand on what @mitchell.hudson noted about certain column types being calculated client-side - you can find a list of those column types here - https://monday.com/developers/v2#column-values-section-auto-calculated-column

As of the time of posting this, those current column types are:

  • Progress tracking column
  • Auto number column
  • Item ID column
  • Last updated column
  • Creation log column
  • Formula column
2 Likes