Discussions

Hi,

I am using power query API requests to fetch data into my excel / power BI reports and it works fine on my local environment.

My plan was to share this with other coworkers using sharepoint but I am not going to. The problem is that the API key is embedded in powerquery m code.

Right now the same API key can be use to create GET POST DELETE UPDATE requests on all endpoints.

Maybe you could consider ability to generate read only API keys that can only do GET requests or even API key per endpoint that is only capable of making requests only to specific endpoint.

My development knowledge is very basic and I know it is a bit off-topic but maybe you could recommend me other way to let my coworkers fetch the data from Connecteam API in a secure way without having to share the API key.

My main focus at this moment is to create table which fetches jobs list with job code, title, location using API. To give my coworkers the ability to trigger the request on demand. Right now there is no way to export job code from jobs list in Connecteam frontend.

Any help or tips would be appreciated.