This web service is used in a F5 ILX workflow to return an email address for a given user id.

It leverages SQL for the backend, and relies on a stored procedure that accepts a string and returns the following fields:

• UserName
  • Type: String
• EmailAddress
  • Type: String

The following environment variables must exist in order for the API to work.

• PORT - Port for the API to listen on.
• SQLPORT - Port that SQL is listening on.
• SQLSERVER - Hostname or IP of SQL Server.
• SQLUSER - SQL User account. (Cannot be Windows user, local SQL user.)
• SQLPASS - SQL User Password.
• SQLDB - DB Name
• SQLPROC - Stored Procedure name.

A status endpoint is available once launched:

• /v1/status - Will return a status of running if successful.

  • "status": "running"

• /v1/user/:username - Replacing :username with a real username will return that users email. (/v1/user/bob)

  • [email protected] - Simple string response, you can pull the body of the response in for use int he F5.

To launch this API with docker, use the following. You may swap in a docker environment file if you choose, replacing values with real values. docker run -d -p 3001:3001 -e "SQLPORT=1433" -e "SQLSERVER=172.0.0.1" -e "SQLUSER=username" -e "SQLPASS=userpassword" -e "SQLDB=dbname" -e "SQLPROC=storedprocname"