public override async Task <ActionResponse> ExecuteActionAsync(ActionRequest request) { string server = request.DataStore.GetJson("SqlCredentials")["Server"].ToString(); string user = request.DataStore.GetJson("SqlCredentials").SelectToken("User")?.ToString(); string password = request.DataStore.GetJson("SqlCredentials").SelectToken("Password")?.ToString(); var auth = request.DataStore.GetJson("SqlCredentials")["AuthType"].ToString(); SqlCredentials credentials = new SqlCredentials() { Server = server, Username = user, Password = password, Authentication = auth.EqualsIgnoreCase("Windows") ? SqlAuthentication.Windows : SqlAuthentication.SQL }; var response = SqlUtility.GetListOfDatabases(credentials, true); return(response.Count == 0 ? new ActionResponse(ActionStatus.Failure, JsonUtility.GetEmptyJObject(), "NoDatabasesFound") : new ActionResponse(ActionStatus.Success, JsonUtility.CreateJObjectWithValueFromObject(response))); }