title: Environment variables in Azure WebApp with Node.js
body: <p>I have successfully run a Node.js Webapp on Azure, which is connecting to an Azure SQL DB. Everything is working fine when entering the DB details manually into the code.</p>
  
  <p>The issue comes when I try and use the connection details as environment variables.</p>
  
  <p>My Node.js connection looks like this:</p>
  
  <pre><code>const config = {
  user: `${APPSETTING_user}`,
  password: `${APPSETTING_pw}`,
  server: `${APPSETTING_host}`,
  database: `${APPSETTING_db}`,
  options: 
   {
    encrypt: true
   }
  };
  </code></pre>
  
  <p>In the Azure Webapp, I have done the following:</p>
  
  <ul>
  <li>Application Settings > App Settings </li>
  </ul>
  
  <p>Entered the following:</p>
  
  <ul>
  <li>Key: user, Value: {db user login}</li>
  <li>Key: pw, Value: {my password} </li>
  <li>Key: host, Value: {SQL server address} </li>
  <li>Key: db, Value: {db name>}</li>
  </ul>
  
  <p><em>Correct working values in plain text without curly brackets obviously.</em> </p>
  
  <p>I am getting an error on load that is cannot find db server: <code>${APPSETTING_host}</code></p>
  
  <p>I have been looking through documentation and tutorials, which is limited or out of date on this - however from what I have read apparently I am doing it correctly?</p>