Table only rendering some columns, potentially related error message "unable to retrieve information about the query ..."

[emmamack]

1. My goal: Display data from a backend query in a table
2. 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.
3. 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

4. Additional info: (Cloud or Self-hosted, Screenshots)
   Table (editor mode):
   
   
   
   Table settings (editor mode):
   
   
   
   Query looking normal (editor mode):
   
   
   
   Table (preview mode):
   
   

[Marcus_Santos]

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.