How to fetch column and values for each item in a board

Platform discussions
, , , ,
1

I need to fetch the columns name, deadline, channel and type for every item under the board. Also how to get the list of all items under each board

Am using cURL.

what in the API reference should I refer to fetch them,

I used below,

https://api.monday.com/v2?query=query { items (ids: [1622835100]) {name}}

Am able to fetch the name of the item but apart from that the other columns am unable to. Please help. New to platform.

2

hi @Dhivya

Welcome to the community. What you need to do is to query the column_balues of that item. For example: this one give me the data for that item stored in the column with columnId “date4”.

{
  items(ids: 123456789) {
    id
    column_values(ids: "date4") {
      value
      text
    }
  }
}

If you don’t specify the columnId you get all values for all columns. For example this one gives all values and column names (title) for that item

{
  items(ids: 123456789) {
    id
    column_values {
      title
      value
    }
  }
}