Hi guys, I am using 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] Make “Get Row” module [Screenshot 2024-08-03 at 17.13.17] 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?

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.

Thanks Darren, once again :slight_smile: 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?

Is there a reason you need to retrieve columns where there’s not a value?

There are a couple of undocumented endpoints that you can use to query table meta data. See below: [image] List of Column names in a Table with type Ask for Help 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

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.

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.

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.

[image] 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.

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.

Glide Get Row API not returning app basic columns

Ask for Help

Darren_Murphy August 4, 2024, 1:43am 5

There are a couple of undocumented endpoints that you can use to query table meta data. See below:

Topic		Replies	Views
Bug: Cannot retrieve all column of Users native table with GET API query Report a Bug api , call-api	4	224	April 21, 2024
Glide API: Can I only get rows from Big Tables? Ask for Help api	5	134	February 2, 2025
Constructing API Request Help Ask for Help	3	68	March 6, 2025
List of Column names in a Table with type Ask for Help	3	103	July 22, 2024
Is there a way to send only few rows in glide api get response? Ask for Help	13	187	August 30, 2024

Glide Get Row API not returning app basic columns

Related topics