How to get a connection string environment variable in an Azure function running locally?

Question

I am trying to setup an Azure Function to run locally on my development environment. I wish to connect to a MongoDb database instance.

In my local.settings.json file I have added:

"ConnectionStrings": {
    "DB_CONNECT_STRING": "mongodb://localhost:27017/MyDatabase"
}

In my function I then have:

module.exports = function (context, myTimer) {
    console.log(process.env.DB_CONNECT_STRING);
    context.done();
};

process.env.DB_CONNECT_STRING is undefined.

I assume I need to add some kind of prefix to the environment variable, but I can't find this documented anywhere. How do I specify a connection string and reference it in the function code?

Can you try process.env.ConnectionStrings.DB_CONNECT_STRING or process.env.ConnectionStrings["DB_CONNECT_STRING"]? — Gaurav Mantri
– Gaurav Mantri, Commented Jul 12, 2017 at 10:40
What happens if you add it in Values instead of ConnectionStrings? — Matt Mason
– Matt Mason, Commented Jul 12, 2017 at 16:58

Aaron Chen · Accepted Answer · 2017-07-13 04:37:55Z

6

Matt Mason is right.

In Node.js, we should specify app settings in the Values collection. These settings can then be read as environment variables by using process.env.

{
  "IsEncrypted": false,
  "Values": {
    "AzureWebJobsStorage": "",
    "DB_CONNECT_STRING": "mongodb://localhost:27017/MyDatabase"
  }
}

Then use process.env.DB_CONNECT_STRING to get the value.

edited Jul 13, 2017 at 4:37

answered Jul 13, 2017 at 4:30

Aaron Chen

9,9701 gold badge20 silver badges30 bronze badges

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

Comments

slayer3600 · Accepted Answer · 2021-02-19 00:38:58Z

0

For the purists out there, I found it. I set a breakpoint and evaluated "process.env" and found my connection string in this format:

ConnectionStrings:<ConnectionName>

So if my local.settings.json looks like this:

{
  "IsEncrypted": false,
  "Values": {
    "AzureWebJobsStorage": "",
    "FUNCTIONS_WORKER_RUNTIME": "node",
  },
  "Host": {
    "CORS": "http://localhost:8080"
  },
  "ConnectionStrings": {
    "Prod": "MyConnString"
  }
}

Then I would access it like this:

 const sqlConnString = process.env['ConnectionStrings:Prod'];

You have to use bracket notation because of the colon.

answered Feb 19, 2021 at 0:38

slayer3600

3231 silver badge12 bronze badges

Collectives™ on Stack Overflow

How to get a connection string environment variable in an Azure function running locally?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related