# Bug: Cannot retrieve all column of Users native table with GET API query **URL:** \ **Category:** Report a Bug\ **Tags:** api, call-api\ **Created:** [April 21, 2024, 7:03am UTC](https://community.glideapps.com/t/bug-cannot-retrieve-all-column-of-users-native-table-with-get-api-query/72767 "2024-04-21T07:03:50Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![frozar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/frozar/32/67936_2.png) [@frozar](https://community.glideapps.com/u/frozar)\ **Post date:** [April 21, 2024, 7:03am UTC](https://community.glideapps.com/t/bug-cannot-retrieve-all-column-of-users-native-table-with-get-api-query/72767/1 "2024-04-21T07:03:50Z")
**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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/4/74b8441e9da0d3a0d5b6a3b8ee8426e6afbec76b.png) Here the usage of the end-point: ![2024-04-21_10-45_ts](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/3/33d4225a449ba9b589450f530c67b8612a2d26f5.png) Here the output I get: ![2024-04-21_10-46_result](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/cec46ff9d4ec458d0a58d3c4dd55dea80b00c97f.png) **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). ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 21, 2024, 8:45am UTC](https://community.glideapps.com/t/bug-cannot-retrieve-all-column-of-users-native-table-with-get-api-query/72767/2 "2024-04-21T08:45:52Z")
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. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 21, 2024, 10:26am UTC](https://community.glideapps.com/t/bug-cannot-retrieve-all-column-of-users-native-table-with-get-api-query/72767/3 "2024-04-21T10:26:07Z")
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. ✅ - Added some values to the column. New column still did not appear in Get Rows results. Not expected 🔴 - Updated a value in the new column with a `mutateTables` call. And _now_ the new column started appearing in the Get Rows result. hmmmm… 🤔 So yeah, it seems that something isn’t quite right. Feel free to submit a ticket to Glide Support. ---
**Author:** ![frozar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/frozar/32/67936_2.png) [@frozar](https://community.glideapps.com/u/frozar)\ **Post date:** [April 21, 2024, 1:56pm UTC](https://community.glideapps.com/t/bug-cannot-retrieve-all-column-of-users-native-table-with-get-api-query/72767/4 "2024-04-21T13:56:41Z")
Hi @ThinhDinh , thank you for your reply. Just to let you see, these are not computed columns that I’m looking for: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/9/e95fcefab91e7a10f6ecf62d553ef9cc23d4e322.png) 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 🙏 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 21, 2024, 1:57pm UTC](https://community.glideapps.com/t/bug-cannot-retrieve-all-column-of-users-native-table-with-get-api-query/72767/5 "2024-04-21T13:57:21Z")
Here’s a comment on how to submit a ticket in case you need it. > [@How to open a support ticket?](https://community.glideapps.com/t/how-to-open-a-support-ticket/59883/2): > > Please note: the option to create a support ticket is only available if your App is in a Pro, Business or Enterprise Team. If you need help with a Billing Issue (on any plan), you should open a Billing Enquiry via the [Glide Support Page](https://www.glideapps.com/support). To create a Support Ticket: Open the App that is giving you problems, and go to Settings → Contact Support: Glide will prompt you to create a support link for your App. Click on Create Link: