My goal: Display data from a backend query in a table
Issue: Only one column is visually rendering, always in the second spot (in editor mode), and if I reorder or delete columns, sometimes the column that is showing up changes.
Steps I've taken to troubleshoot:
Opened in "preview mode": I get the error 'unable to retrieve information about the query "[failing query]". Still only one column header renders, but "no rows found". Note that in editor mode, the query runs just fine and I can see the query response, it looks normal. I switched back and forth between editor and preview mode several times and got a consistent result. I was able to find this post Randomly receive "Unable to retrieve information about the query" which marks that as a bug fixed last year.
Verify that the query response looks normal
Delete any columns that contain lists in case that was the rendering problem
Delete any columns with null values in case that was the rendering problem
Additional info: (Cloud or Self-hosted, Screenshots)
Table (editor mode):
Hey @emmamack , could you please provide further details on how are you defining the request? For example, I've just created a test for it using the public URL https://jsonplaceholder.typicode.com/users. I've created a RestAPI request (GET) and It's showing the content on the table correctly.
Hi Marcus,
I'm not entirely sure how to answer your question, but it should interest you to know that was able to "fix" the rendering problem by changing the data source of the table to something random, then changing it back to the data source that was incorrectly rendering before.
Very confused by the error message, we definitely do not see that a lot. That was very odd that the query was working fine in editor mode but not in preview mode.
Thank you for sharing that the fix was changing the data source to something else and then back to the query
