Forum Discussion
Getting Auth0 Authentication parameters from a config file
I have a powerquery custom connector that authenticates against Auth0. The authentication call has a bunch of parameters (such as clientId, environment, audience, etc...), most of which don't change ...
Hi apdams ,
Try to use a JSON file to store your configuration data. You can then read this file using Power Query's Web.Contents() function and parse the JSON response using the Json.Document() function. To make this configuration file accessible before the user authenticates, you can store the file in a location that is accessible to all users, such as a shared network drive or a cloud storage service. Alternatively, you can embed the configuration data directly in your Power Query code as a variable or a table.
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.