Glide API: Can I only get rows from Big Tables?

Ask for Help
1

I’m trying to get all rows from a regular Glide table, but keep getting this error:

Glide API get rows error
Glide API get rows error1440×795 106 KB

I have double (triple even) checked the URL, table ID, bearer token, and whatever else I could have inout incorrectly.
I find mixed messages in the community and Glide API docs about whether I can actually get rows from a regular Glide table or not.
Any help would be appreciated :pray:t3:

2

A couple of things stick out at me:

  • Firstly, the Glide API only supports POST requests. GET is not supported.
  • Secondly, your endpoint URL looks wrong. Where did you get that from? It should be https://api.glideapp.io/api/function/queryTables

A regular Glide table will return all rows (max 10,000).
With Big Tables you can apply filters to the returned results.
Refer to the below:

1 Like
3

Thanks for the quick reply, Darren.

Much appreciated!

I got the URL from ChatGPT tbh :flushed:

I swapped the URL for the one you so kindly provided and changed the request method which gave me a status code of 200 and a bunch of rows to work with.

However, it seems that not all columns of the table are being extracted. And here I refer to basic columns as well as computed columns.

Anything you’ve experienced before?

4

Do the missing columns have data in them?
Any columns that are empty will not be returned. If you need them to show up for the purposes of configuring your Make scenario, add some dummy data.

5

Computed columns are not available for the API.

2 Likes
6

What I mean is that in my request response, I’m missing several basic columns like text and number columns @ThinhDinh.

I’ve checked now, @Darren_Murphy, and it is indeed the case, that empty columns don’t show up.

Thank you both for helping me out here :hugs:

2 Likes
7

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.