Can Azure Functions written in Node.js access Connection Strings?

Question

The App Settings for an Azure Function App contain values for database connection strings that can be set in the portal. In C# they can be accessed using

ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString

For an Azure Function written in JavaScript, is there an equivalent construction that has access to the connection strings? I understand that they can be stored in the application settings, but since there is a section on the portal devoted to connection strings, I am asking if this has any application to Node.js functions.

Possible duplicate of How to get a connection string environment variable in an Azure function running locally? — Vova Bilyachat
– Vova Bilyachat, Commented Jan 2, 2018 at 23:06

David Ebbo · Accepted Answer · 2018-01-02 23:16:13Z

8

The distinction between app settings and connection strings makes sense in .NET, but not as much in Node. When using Node, the suggestion is to use app settings for all your secrets and connection strings. You can them access them using process.env.YourAppSetting.

And to answer your question directly, there is no easy way to access connection strings in Node, unless you start making assumptions on prefixes that are not guaranteed to work forever.

answered Jan 2, 2018 at 23:16

David Ebbo

43.3k8 gold badges111 silver badges122 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Allen Tellez · Accepted Answer · 2018-01-02 23:12:20Z

5

try

process.env['YOUR_APP_SETTING'];

Microsoft Documentation

answered Jan 2, 2018 at 23:12

Allen Tellez

1,2111 gold badge11 silver badges14 bronze badges

4 Comments

Aidan Over a year ago

Thanks, this works for the Application Settings for the Function App, but there is another section in the Azure portal called Connection Strings, I am asking how we can retrieve these values.

Allen Tellez Over a year ago

Oh yea, I see what you mean. Hmm.

Allen Tellez Over a year ago

It's not elegant but, I suppose you could duplicate the connection string as an app setting. Microsoft does not appear to give a way to access the connection string directly that I can find.

maracuja-juice Over a year ago

So this means I have to save my connection string as an appsetting?

jithu reddy · Accepted Answer · 2018-06-19 08:30:03Z

4

I ran into same issue and I was under the same impression that we cannot access connection strings in NodeJs application through Runtime Environment variable.

But after thorough checking in the Microsoft documentation, got to know that we can access the connection strings in Node JS, PHP, etc., which are of custom type as below

CUSTOMCONNSTR_<connection_string>

Ref: https://learn.microsoft.com/en-us/azure/app-service/web-sites-configure#connection-strings

answered Jun 19, 2018 at 8:30

jithu reddy

1,6192 gold badges14 silver badges20 bronze badges

Collectives™ on Stack Overflow

Can Azure Functions written in Node.js access Connection Strings?

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related