Trouble updating to V 2023-10 especially with display_value

We are ‘citizen developers’ and new to Monday. We created two simple python API calls this spring that were working perfectly to return a really small board - until a week (or so) ago. Now we’re trying to update and running into issues.

We got the call working for the simplest of our calls - the one where we don’t need mirrored column values, etc.

But implementing the fragments for the display_value for data from a mirrored board is problematic. We have tried a multitude of variations in different versions in both the developer and the regular API playgrounds.

Our current non-working version of the query looks like:

query
{
boards (ids: 4304082965) {
name
id
description
items_page {
items {
name
column_values {
… on MirrorValue {
display_value
}
}
}
}
}
}
}

What are we missing?

Looks like there is one closing curly bracket to many

yes, I have edited this code too much and left one too many in. If you delete it, the code still doesn’t work.

“Doesn’t work” is a little vague :). Do you get syntax errors, no data, unexpected data?

It works as expected on my side, did you select the correct API version?

1 Like

Great question.


We are using the 2023-10 version. Without the extra curly backet, I get the following error:
{
“errors”: [
{
“message”: “Failed to fetch”,
“stack”: “TypeError: Failed to fetch\n at https://monday.com/nhp/_next/static/chunks/d310b1ebcb21564b607af0377ef0e1240c79bee0.dd6c8b0f89ced6ba8a82.js:1:13303\n at https://monday.com/nhp/_next/static/chunks/pages/_app-ab15d2840bcd3b6ed58e.js:1:30591\n at o (https://monday.com/nhp/_next/static/chunks/pages/_app-ab15d2840bcd3b6ed58e.js:1:28829)\n at s (https://monday.com/nhp/_next/static/chunks/93.badb5f455bbfb66c2af5.js:1:55344)\n at https://monday.com/nhp/_next/static/chunks/93.badb5f455bbfb66c2af5.js:1:90422\n at https://monday.com/nhp/_next/static/chunks/a4fa5d88.ff8502a98e6e980b00cf.js:1:353625\n at onClick (https://monday.com/nhp/_next/static/chunks/a4fa5d88.ff8502a98e6e980b00cf.js:1:424554)\n at Object.$e (https://monday.com/nhp/_next/static/chunks/framework.a8576a85e587f36374fa.js:1:48831)\n at Ye (https://monday.com/nhp/_next/static/chunks/framework.a8576a85e587f36374fa.js:1:48985)\n at https://monday.com/nhp/_next/static/chunks/framework.a8576a85e587f36374fa.js:1:67192\n at _r (https://monday.com/nhp/_next/static/chunks/framework.a8576a85e587f36374fa.js:1:67286)\n at Cr (https://monday.com/nhp/_next/static/chunks/framework.a8576a85e587f36374fa.js:1:67701)\n at https://monday.com/nhp/_next/static/chunks/framework.a8576a85e587f36374fa.js:1:73354\n at De (https://monday.com/nhp/_next/static/chunks/framework.a8576a85e587f36374fa.js:1:149213)\n at https://monday.com/nhp/_next/static/chunks/framework.a8576a85e587f36374fa.js:1:69162\n at Or (https://monday.com/nhp/_next/static/chunks/framework.a8576a85e587f36374fa.js:1:69192)\n at Jt (https://monday.com/nhp/_next/static/chunks/framework.a8576a85e587f36374fa.js:1:57263)\n at Zt (https://monday.com/nhp/_next/static/chunks/framework.a8576a85e587f36374fa.js:1:56489)\n at t.unstable_runWithPriority (https://monday.com/nhp/_next/static/chunks/framework.a8576a85e587f36374fa.js:1:3875)\n at $l (https://monday.com/nhp/_next/static/chunks/framework.a8576a85e587f36374fa.js:1:77554)\n at Ie (https://monday.com/nhp/_next/static/chunks/framework.a8576a85e587f36374fa.js:1:148952)\n at Xt (https://monday.com/nhp/_next/static/chunks/framework.a8576a85e587f36374fa.js:1:56281)\n at HTMLDivElement.s (https://monday.com/nhp/_next/static/chunks/d310b1ebcb21564b607af0377ef0e1240c79bee0.dd6c8b0f89ced6ba8a82.js:1:95852)”
}
]
}

And on this other playground site I get the following error:
{
“errors”: [
{
“message”: “Unexpected token ‘u’, "upstream r"… is not valid JSON”,
“stack”: “SyntaxError: Unexpected token ‘u’, "upstream r"… is not valid JSON”
}
]
}
There has to be something simple we’re doing wrong?

Looks like a monday issue to me. I recommend to reach out to appsupport@monday.com with this one

1 Like

Thank you!!! Appreciate your help!

I’ve seen this sort of thing happen when you have a text editor that starts formatting text. Like in your query the ... has been replaced by a single ellipsis character for the ... on MirrorValue fragment. Or other invisible characters (em space, en space, etc.) get in there (which may be the case) This kind of thing happens if you let MS Word come anywhere near code.

Also from the documentation, the samples have a copy button in them that appears if you mouse over the sample box. If you select and copy its possible to pick up stray invisible characters.

1 Like

Thank you @basdebruin and @codyfrisch,

@Cary if you still have issues with this do send us an email if you haven’t already and we will be happy to take a look!

Cheers,
Matias

1 Like

Thank you @codyfrisch and @Matias.Monday. We are starting to think it might be because, while we’re only planning on pulling in a few records at a time, the board itself includes a large number of mirrored columns, cast columns, connected boards, etc.

We did reach out to support last night and have started the process today.

1 Like

Hello again,

We will be happy to help via email then :grin:

1 Like

Actually, @Matias.Monday, we haven’t heard back from anyone in support via email since we added authorization for them to login as me.
We did find the last example Dipro spent a few seconds covering in his presentation last week very helpful and are trying to work through implementing it now.

Hello again @Cary,

I see you are interacting with our team today :grin:

I’ll leave you to it over there with Bill!

Cheers,
Matias

2 Likes

Did you get any resolution on this because I have exactly the same error message on a 2023-10 display_value query - and a relatively small table (<100 items)…

We were able to get past this issue. We basically had to limit what we pull to just the fields we needed. Doing this allowed us to grab up to a whopping 5 records at a time (we have a lot of mirrored columns that made the call too complex) and took quite a while.

We ended up using ‘Column Magic’ to recreate the mirrored columns we needed. All this allows us to pull in a very large number of records (I’m not completely sure what the limit is - we have yet to need more 20) very quickly.

This is the query we’re currently using:
query = ‘’’
{
items_page_by_column_values(
limit: 50
board_id: 4304082965
columns: [{column_id: “status9”, column_values: [“In Progress”]}]
) {
cursor
items {
id
name
column_values(
ids: [
“text35”, “date”, “dropdown2”, “check2”, “text197”, “text430”, “text99”,
“text948”, “text26”, “long_text7”, “franking_approval__”, “text96”, “text654”,
“status4”, “text65”, “status9”, “label_2”, “status”, “status22”
]
) {
text
… on MirrorValue {
display_value
}
}
}
}
}
‘’’
data = {‘query’: query}

1 Like

Thanks for using Column Magic! Fortunately, at this time, we’re not as badly affected by this bug since we only get a single mirror at a time. I hope they get it fixed soon.

But the new API does open up some enhancements to Column Magic in the new year!

2 Likes