Column Values for Connected Boards are an empty string for api

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!