Greetings everyone. I’ve just started building a quite simple application in which I created a table with some fields as “Name”, “Last Name”, among others. When I try to use the API to get a table’s rows, I get the following error independently of using Bash, Python or JS: {'message': 'API key cannot query tables'} I’m using the following python script: # Get rows requires Business plan or above import requests r = requests.post( "https://api.glideapp.io/api/function/queryTables", headers={"Authorization": "Bearer xxxxxxxxxx"}, json={ "appID": "xxxxxxxx", "queries": [ { "tableName": "native-table-xxxxxx" } ] } ) result = r.json() print(result) Also, I’m using the following Bash script: Get rows requires Business plan or above curl --request POST 'https://api.glideapp.io/api/function/queryTables' \ --header 'Content-Type: application/json' \ --header 'Authorization: Bearer xxxx-xxxx-xxxx-xxx-xxxx' \ --data-raw '{ "appID": "xxxxxx", "queries": [ { "tableName": "native-table-xxxxxx" } ] }' Both approaches return exactly the same error as mentioned above. I’ve tried using another one of the API endpoint, specifically the Add Rows. By using the following python script, I’m successfully able to add rows to my table: import requests r = requests.post( "https://api.glideapp.io/api/function/mutateTables", headers={"Authorization": "Bearer xxxx-xxxx-xxxx-xxxx-xxxx"}, json={ "appID": "xxxxx", "mutations": [ { "kind": "add-row-to-table", "tableName": "native-table-xxxxxx", "columnValues": { "Name": "new name by api call", "AGK0b": "new lst name", "Email": "aaa@ubidots.com", "m8C8b": "1993", "Photo": "Photo" } } ] } ) result = r.json() print(result) This is the result ( I executed the script twice) [image] Given the fact that I can add rows to this table, leads me to think that there is nothing wrong with my API key permissions to edit said table. With that in mind, I really can’t tell what am I missing over here regarding this subject. Help is greatly appreciated. Best regards

Perhaps a silly question, but do you have a Business Plan?

I think this might be the likeliest source of the problem, to be honest.

Greetings @Darren_Murphy and @ThinhDinh. As you mention, I possess a Business Plan.

Then that’s weird. I would suggest submitting a ticket. [image] How to open a support ticket? Ask for Help 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. To create a Support Ticket: Open the App that is giving you problems, and go to Settings → Contact Support: [CleanShot 2023-08-16 at 16.24.33@2x] Glide will prompt you to create a support link for your App. Click on Create Link: [CleanShot 2023-08-16 at…

Hi Juan, has Glide managed to fix this for you yet? I am having the same issue. Russ

After implemented the code and had same problem then came here to realize that reading rows doesn’t work in pro plan :neutral_face: and only for wealthy Business plan users, like comon!.. and really, why reading rows is “Advanced API”

I believe that it might cost Glide more to run that, since the standard call will return all rows in the table. It might be costly for them to do that query on the firebase side. Just my guess.

yes thats true, but maybe give me raw data (without computed fields) with basic reads as normal API and put full reads with computed columns behind the paywall and that would make more sense to me. I know firebase is pretty generous with their plans in such scenarios because at then end of the day, I just bypassed glideAPI and went directly to talk to gsheets through googleapis

Tables : Get Rows API error: API Key cannot query tables

Ask for Help

ThinhDinh April 11, 2023, 11:58pm 5

Then that’s weird. I would suggest submitting a ticket.

Topic		Replies	Views
Glide Big Tables API! Get your big table to your google sheet! Community Resources tutorial	4	952	October 25, 2023
Import your Glide Table into any Google Sheet, with 1 formula! Project Showcase	18	1190	July 15, 2023
Get All Rows Glide Table Ask for Help	3	578	October 17, 2022
Can you read from glide tables using Glide API? Ask for Help	2	251	February 23, 2023
Error When Retriving Tables via API Make.com Report a Bug	3	58	June 18, 2025

Tables : Get Rows API error: API Key cannot query tables

Related topics