Express.js with OpenAPI with Azure SQL

• /users
• /api-docs

App Service app settings

When you use the Azure CLI service connector to add a system-assigned identity between the App Service and the Azure SQL server, the process creates 4 environment variables in the App Service:

• Don't change the environment variable names
• Use the environment variables in the mssql configuration object

AZURE_SQL_SERVER=SERVER.database.windows.net
AZURE_SQL_DATABASE=mySampleDatabase
AZURE_SQL_PORT=1433
AZURE_SQL_AUTHENTICATIONTYPE=azure-active-directory-default

Passwordless config

// ./src/config.ts
export const passwordlessConfiguration = {
    server: process.env.AZURE_SQL_SERVER,
    port: +process.env.AZURE_SQL_PORT,
    database: process.env.AZURE_SQL_DATABASE,
    authentication: {
        type: process.env.AZURE_SQL_AUTHENTICATIONTYPE,
    },
    options: {
      encrypt: true // for Azure users
    }
  };