Column Values for Connected Boards are an empty string for api

monday Apps & Developers
, , ,
1

I am running a script for grab some data from the api. However, not all the data is coming through. Particularly for the connected_board columns.

The data only comes over if I return one record by id at a time. This would be inefficient to loop through each item by row id.

Example 1 graphQL:
query {
boards(ids:%s) {
name
id
groups{
title
items(limit:5, page:1){
name
column_values{
title
id
text
}
}
}
}
}
This returns:
image

Example 2 graphQL with ID:
query {
boards(ids:%s) {
name
id
groups{
title
items(ids:%s){
name
column_values{
title
id
text
}
}
}
}
}
image

How can I get the column values to come though in example 1?

For the second example the same item with the same pulse id comes up in multiple groups. How is that possible when the board only shows the record in one group?

Thanks for the assistants!

2

I was searching for a solution on this issue when I found your post. I just did a lot of troubleshooting and found that removing subitems from the query seems to be a workaround to some sort of bug.

If you have subitems on your board, remove those ids from your query string and see if that helps.

3

Hi,

I am unable to retrieve some values that are originally stored in a connected board. They simply show up as None in my query. Would anyone here have a solution for this issue?

Thanks,

Theo

4

Hello there @tlgemp and welcome to the community!

I hope you like it here :muscle:

Have you tried using something like this:

query {
  items (ids:[1234567890]) {
    column_values {
      ... on BoardRelationValue {
        linked_items{
          name
          id
        }
      }
    }
  }
}

Cheers,
Matias

5

Thanks, Matias. No, I haven’t. Is there no way to just query a board and get all the rows with their values for each column as they appear on the UI?

Cheers,

Theo

6

I’ve tested it on the playground against one of our item ids, but it looks like the result is empty:

{
“data”: {
“items”: [
{
“column_values”: [
{},
{},
{
“linked_items”:
},
{},
{},
{},
{},
{},
{
“linked_items”: [
{
“name”: “John Doe”,
“id”: “1010101010101010”
}
]
},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{
“linked_items”:
},
{},
{},
{},
{
“linked_items”:
},
{}
]
}
]
},
“account_id”: 111111111
}

7

Would anyone have any idea how to simply pull all the rows and their values from a given board?

Thanks,

Theo

8

Hello again @tlgemp,

I see the response you sent is not really empty. It just has few values.

You can use a query like this one:

{
  boards(ids: 1234567890) {
    items_page(limit: 500) {
      items {
        name
        id
        column_values {
          text
          value
          ... on BoardRelationValue {
            linked_items {
              name
              id
            }
          }
        }
      }
    }
  }
}

Depending on the amount of items and columns you have, you might have to use a bigger or smaller limit.

And you might need to paginate through results as explained here :grin:

Let me know if you have any questions!

Cheers,
Matias