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.
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
Hello there @tlgemp and welcome to the community!
I hope you like it here 💪
Have you tried using something like this:
query {
items (ids:[1234567890]) {
column_values {
... on BoardRelationValue {
linked_items{
name
id
}
}
}
}
}
Cheers,
Matias
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
I’ve tested it on the playground against one of our item ids, but it looks like the result is empty:
{
“data”: {
“items”: i
{
“column_values”: m
{},
{},
{
“linked_items”:
},
{},
{},
{},
{},
{},
{
“linked_items”: >
{
“name”: “John Doe”,
“id”: “1010101010101010”
}
]
},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{
“linked_items”:
},
{},
{},
{},
{
“linked_items”:
},
{}
]
}
]
},
“account_id”: 111111111
}
Would anyone have any idea how to simply pull all the rows and their values from a given board?
Thanks,
Theo
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 😁
Let me know if you have any questions!
Cheers,
Matias
