How to get all column_values fields? API v2

monday Apps & Developers
,
1

Hi. I want to get all data from all boards. Now I know how to get all boards and items ids, but what about columns?

I try use this:

query {
boards(ids:XXX) {
id
name
items(ids:XXX) {
name
id
creator {
id
name
}
created_at
column_values {
title
value
text
}
}
}
}

This three fields, is everything what i found here:

  • title
  • value
  • text

And it looks like some of them contain null values. For example, some column values is collection of labels. And some values is calendar date.

How do I get them all?

Thank you.

2

Hey @danetportal,
Your query is correct. Null values may appear for columns values that are client side calculated, such as item id, creation log… for most column values the “text” field will display the actual value. For special columns like the formula and percentage columns there will be no value displayed.
Collections of labels should be by their ID’s in the “value” field and by their display name in the “text” field. Dates should works in both “text” and “value”.
Are there specific columns you’re not getting as expected?

3

Ok. I got it.

But now i have another issue.

query {
boards{
id
name
}
}

I have access to more than 50 boards in my profile, but on this request I get only 25 of them. Why is that?

Also about API limitations - if I exceed them, will I just increase the query execution time or will it immediately break?

4

Our default limit is 25. You can override it using the limit parameter like so:

query {
  boards (limit: 60) {
    id
    name
  }
}

If you will be using a high complexity query that the limit doesn’t work with you can also use our pagination mechanism like so:

query {
  boards (limit: 20, page: 1) {
    id
    name
  }
}
5

Thank you very much for your help and assistance.

What about

Also about API limitations - if I exceed them, will I just increase the query execution time or will it immediately break?
?

Also, we have a lot of data in the info boxes, but it looks like I can’t get it through the API?

I try uselimit:100 to get all data, but will get response like:

monday.com is having some technical issues

Can i somehow avoid this?

6

  1. If you exceed API limits then it will break and you will get a message letting you know the complexity of your query.

  2. Info boxes are not supported in API v2.

  3. if the limit 100 fails I would suggest using smaller limits with pagination like so:

     query {
   boards (limit: 20, page: 1) {
     id
     name
   }
 }