Bug: Cannot retrieve all column of Users native table with GET API query

Report a Bug
,
1

Team ID:

  • In the Glide dashoard URL:
    https://go.glideapps.com/o/LXK2m1RVgSR20fTzq2OU

App ID:

  • In the Glide builder URL:
    https://go.glideapps.com/app/EvqQIQnnJxPxWYXwzCnO/layout

Description

Hi Gliders,

We subscribed to the Business plan and so we are able to do GET queries on any table. GET queries allow my to retrieve all data from any table except on the Users table. On this table, I can only retrieve a really few of its columns. I use a simple typescript program to do the queries.

Here the schema of the Users table:

2024-04-21_10-44_api
2024-04-21_10-44_api719×464 57.5 KB

Here the usage of the end-point:
2024-04-21_10-45_ts

Here the output I get:

2024-04-21_10-46_result
2024-04-21_10-46_result761×525 42.6 KB

My question:
Why I cannot retrieve all the columns of the Users table?

How to replicate

  • Create a new project,
  • Setup Users table to have more than 4 columns,
  • Run a GET query against the Users table (even curl one).
2

Are you trying to query computed columns, or are you sure you are not seeing all basic columns? I believe computed columns will not be returned using the GET API query.

3

One thing to be aware of is that the API will not return columns that are empty. So if you’ve added new columns, but not added any data to those columns, you won’t see them with a Get Rows call.

That said, I was just doing some testing and there does appear to be some inconsistent behaviour. This is what I observed:

  • Add a non-computed column and left it empty. New column did not appear in Get Rows result. Expected. :white_check_mark:
  • Added some values to the column. New column still did not appear in Get Rows results. Not expected :red_circle:
  • Updated a value in the new column with a mutateTables call. And now the new column started appearing in the Get Rows result. hmmmm… :thinking:

So yeah, it seems that something isn’t quite right. Feel free to submit a ticket to Glide Support.

2 Likes
4

Hi @ThinhDinh , thank you for your reply. Just to let you see, these are not computed columns that I’m looking for:

image
image1138×123 12.5 KB

Hi @Darren_Murphy , thank you for taking the time to reproduce this bug, and definitely I will report it through a support ticket (now I know how to do it). Also, I didn’t know that empty column will not be retrieved: good to know this behavior.
Finally, thank you very much for all the answers you gave across this forum. I read a LOOOOOT from you :pray:

2 Likes
5

Here’s a comment on how to submit a ticket in case you need it.