# Glide Get Row API not returning app basic columns **URL:** \ **Category:** Ask for Help\ **Tags:** api\ **Created:** [August 3, 2024, 3:14pm UTC](https://community.glideapps.com/t/glide-get-row-api-not-returning-app-basic-columns/75400 "2024-08-03T15:14:17Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![evazivanovic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/evazivanovic/32/83692_2.png) [@evazivanovic](https://community.glideapps.com/u/evazivanovic)\ **Post date:** [August 3, 2024, 3:14pm UTC](https://community.glideapps.com/t/glide-get-row-api-not-returning-app-basic-columns/75400/1 "2024-08-03T15:14:17Z")
Hi guys, I am using [Make.com](http://Make.com) to run a scheduled automation and I ran into an issue. Looking at Glide API, I should be getting all basic columns into Make. While I am getting just a portion of them. Any ideas why? Glide API ![Screenshot 2024-08-03 at 17.12.40](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/2/12e28910fccd2e6fdaa6fdf2e4843439f5f687d7.png) Make “Get Row” module ![Screenshot 2024-08-03 at 17.13.17](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/0/509079cbbfc142caecf7e5c0aba8600686563d95.png) I am missing quite a few core ones, and I have managed to retrieve the field types before on other tables (boolean, date-time, number, etc.) Is this a known bug? ---
**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:** [August 3, 2024, 3:32pm UTC](https://community.glideapps.com/t/glide-get-row-api-not-returning-app-basic-columns/75400/2 "2024-08-03T15:32:28Z")
Any columns that are empty won’t show up. If that’s the case, you can temporarily add some dummy values into those columns and then they should show up. ---
**Author:** ![evazivanovic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/evazivanovic/32/83692_2.png) [@evazivanovic](https://community.glideapps.com/u/evazivanovic)\ **Post date:** [August 3, 2024, 3:43pm UTC](https://community.glideapps.com/t/glide-get-row-api-not-returning-app-basic-columns/75400/3 "2024-08-03T15:43:18Z")
Thanks Darren, once again 🙂 You’ve been of great help on the last few posts I had. Is this by design? Are there any updates coming to this? If no, where can I submit a feature request? ---
**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:** [August 4, 2024, 12:08am UTC](https://community.glideapps.com/t/glide-get-row-api-not-returning-app-basic-columns/75400/4 "2024-08-04T00:08:57Z")
Is there a reason you need to retrieve columns where there’s not a value? ---
**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:** [August 4, 2024, 1:43am UTC](https://community.glideapps.com/t/glide-get-row-api-not-returning-app-basic-columns/75400/5 "2024-08-04T01:43:48Z")
There are a couple of undocumented endpoints that you can use to query table meta data. See below: > [@List of Column names in a Table with type](https://community.glideapps.com/t/list-of-column-names-in-a-table-with-type/75005/2): > > GET https://functions.prod.internal.glideapps.com/api/apps/APP\_ID/tables gets you all tables for an app GET https://functions.prod.internal.glideapps.com/api/apps/APP\_ID/tables/TABLE\_ID/schema gets all columns for a table ---
**Author:** ![evazivanovic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/evazivanovic/32/83692_2.png) [@evazivanovic](https://community.glideapps.com/u/evazivanovic)\ **Post date:** [August 4, 2024, 9:20am UTC](https://community.glideapps.com/t/glide-get-row-api-not-returning-app-basic-columns/75400/6 "2024-08-04T09:20:04Z")
Yeah in fact there is. So basically I am working with a client that wants to automatically assign yearly leave. And for one of the types the condition varies depending on whether they have children or not. So true/false here is important because they take different routes. If I can’t retrieve the field, I can’t configure routes. I updated it into a text field, but boolean fields are a lot less dynamic and would work better. ---
**Author:** ![evazivanovic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/evazivanovic/32/83692_2.png) [@evazivanovic](https://community.glideapps.com/u/evazivanovic)\ **Post date:** [August 4, 2024, 9:20am UTC](https://community.glideapps.com/t/glide-get-row-api-not-returning-app-basic-columns/75400/7 "2024-08-04T09:20:35Z")
Thanks Darren! ---
**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:** [August 4, 2024, 12:18pm UTC](https://community.glideapps.com/t/glide-get-row-api-not-returning-app-basic-columns/75400/8 "2024-08-04T12:18:56Z")
I believe you can have conditions for it whether it exist or not in the payload. If fieldName is true then go this route, if fieldName is not true or fieldName does not exist then go this route. ---
**Author:** ![evazivanovic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/evazivanovic/32/83692_2.png) [@evazivanovic](https://community.glideapps.com/u/evazivanovic)\ **Post date:** [August 4, 2024, 1:28pm UTC](https://community.glideapps.com/t/glide-get-row-api-not-returning-app-basic-columns/75400/9 "2024-08-04T13:28:22Z")
True although then I need to get those fields in first. If boolean is false for all records right now I have to create dummy data to design the flow and with multiple boolean fields in multiple tables that feels unnecessary inefficient. Glad there’s a workaround though I would prefer to not have to have a workaround if you know what I mean. ---
**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:** [August 4, 2024, 2:08pm UTC](https://community.glideapps.com/t/glide-get-row-api-not-returning-app-basic-columns/75400/10 "2024-08-04T14:08:49Z")
> [@evazivanovic](#): > > True although then I need to get those fields in first You can copy an existing field name, paste that somewhere, and then edit to the field name you want to refer to. ---
**Author:** ![evazivanovic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/evazivanovic/32/83692_2.png) [@evazivanovic](https://community.glideapps.com/u/evazivanovic)\ **Post date:** [August 4, 2024, 2:35pm UTC](https://community.glideapps.com/t/glide-get-row-api-not-returning-app-basic-columns/75400/11 "2024-08-04T14:35:51Z")
Yeah I think’s fine. I am more saying my point is if the API call would by default return everything, workarounds wouldn’t be needed. Happy you guys helped me find a way, just wish there was a way without the workaround, is all. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [August 11, 2024, 2:36pm UTC](https://community.glideapps.com/t/glide-get-row-api-not-returning-app-basic-columns/75400/12 "2024-08-11T14:36:43Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.