# API token authorisation
**URL:** https://community.glideapps.com/t/api-token-authorisation/67048
**Category:** Ask for Help
**Created:** [October 17, 2023, 12:09pm UTC](https://community.glideapps.com/t/api-token-authorisation/67048 "2023-10-17T12:09:36Z")
**Posts on this page:** 19
**Page:** 1
### Author:  [@Thierno](https://community.glideapps.com/u/Thierno)
#### Post date: [October 17, 2023, 12:09pm UTC](https://community.glideapps.com/t/api-token-authorisation/67048/1 "2023-10-17T12:09:36Z")
Hello everyone, I need help with glide and make. I would like to retrieve a glide table in make, I have done the webhook and I have managed to link my glide application to my make scenario. The action that follows the trigger is an HTTP(make a request) to retrieve the glide table. I copied the API of the table I want to retrieve and put it in my HTTP make action. When I run the scenario I find this error in the OUTPUT cookie headers Data {“message”: “API key cannot query tables”}. After some research I’ve realised that the problem is linked to the authorisation of the API key. How can I manage this?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 17, 2023, 12:18pm UTC](https://community.glideapps.com/t/api-token-authorisation/67048/2 "2023-10-17T12:18:21Z")
Are you on Business/Enterprise? Only API keys for teams on Business/Enterprise can query tables.
---
### Author:  [@Thierno](https://community.glideapps.com/u/Thierno)
#### Post date: [October 17, 2023, 12:21pm UTC](https://community.glideapps.com/t/api-token-authorisation/67048/3 "2023-10-17T12:21:25Z")
I’m in the pro version
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 17, 2023, 12:21pm UTC](https://community.glideapps.com/t/api-token-authorisation/67048/4 "2023-10-17T12:21:54Z")
Then the query action is not available for API key.
---
### Author:  [@Thierno](https://community.glideapps.com/u/Thierno)
#### Post date: [October 17, 2023, 12:23pm UTC](https://community.glideapps.com/t/api-token-authorisation/67048/5 "2023-10-17T12:23:52Z")
Thanks !
---
### Author:  [@Thierno](https://community.glideapps.com/u/Thierno)
#### Post date: [October 17, 2023, 12:25pm UTC](https://community.glideapps.com/t/api-token-authorisation/67048/6 "2023-10-17T12:25:56Z")
Can you suggest another solution to my problem?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 17, 2023, 1:58pm UTC](https://community.glideapps.com/t/api-token-authorisation/67048/7 "2023-10-17T13:58:52Z")
What are you trying to do with the query function?
---
### Author:  [@Thierno](https://community.glideapps.com/u/Thierno)
#### Post date: [October 17, 2023, 2:09pm UTC](https://community.glideapps.com/t/api-token-authorisation/67048/8 "2023-10-17T14:09:16Z")
I would like to select elements in my application, change their status and make them invisible.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 18, 2023, 12:14am UTC](https://community.glideapps.com/t/api-token-authorisation/67048/9 "2023-10-18T00:14:31Z")
And your action must be initiated outside of Glide?
---
### Author:  [@Thierno](https://community.glideapps.com/u/Thierno)
#### Post date: [October 18, 2023, 8:41am UTC](https://community.glideapps.com/t/api-token-authorisation/67048/10 "2023-10-18T08:41:17Z")
no the action is initiated by a button in glide
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 18, 2023, 10:09am UTC](https://community.glideapps.com/t/api-token-authorisation/67048/11 "2023-10-18T10:09:58Z")
If it’s triggered from Glide, why can’t you change the values directly with a Set Column Values action?
---
### Author:  [@Thierno](https://community.glideapps.com/u/Thierno)
#### Post date: [October 18, 2023, 10:36am UTC](https://community.glideapps.com/t/api-token-authorisation/67048/12 "2023-10-18T10:36:55Z")
Because with set column value I can only change the status of a single element, but I want to change the status of all the elements that are checked.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 18, 2023, 11:41am UTC](https://community.glideapps.com/t/api-token-authorisation/67048/13 "2023-10-18T11:41:58Z")
You can send the list of rowIDs from the rows that need to be changed, and then use a batch HTTP call in a third party service like [Make.com](http://Make.com) to change them.
---
### Author:  [@Thierno](https://community.glideapps.com/u/Thierno)
#### Post date: [October 18, 2023, 11:45am UTC](https://community.glideapps.com/t/api-token-authorisation/67048/14 "2023-10-18T11:45:24Z")
thanks, i’ll try this
---
### Author:  [@Thierno](https://community.glideapps.com/u/Thierno)
#### Post date: [October 18, 2023, 11:56am UTC](https://community.glideapps.com/t/api-token-authorisation/67048/15 "2023-10-18T11:56:52Z")
I specify that I am on glide pro
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 18, 2023, 12:02pm UTC](https://community.glideapps.com/t/api-token-authorisation/67048/16 "2023-10-18T12:02:10Z")
Yeah, you should be able to change rows’ values on Pro.
---
### Author:  [@Thierno](https://community.glideapps.com/u/Thierno)
#### Post date: [October 18, 2023, 1:50pm UTC](https://community.glideapps.com/t/api-token-authorisation/67048/17 "2023-10-18T13:50:56Z")
I try this
---
### Author:  [@Thierno](https://community.glideapps.com/u/Thierno)
#### Post date: [October 20, 2023, 1:59pm UTC](https://community.glideapps.com/t/api-token-authorisation/67048/18 "2023-10-20T13:59:56Z")
I found the solution to the problem that I asked you about. I retrieved all the data that I wanted to modify in Json in a column and then I sent it to make to modify it.
I was inspired by this video Loqode [https://www.youtube.com/watch?v=b7\_k3\_brusQ](https://www.youtube.com/watch?v=b7_k3_brusQ)
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [October 27, 2023, 2:00pm UTC](https://community.glideapps.com/t/api-token-authorisation/67048/19 "2023-10-27T14:00:33Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.