Forum Discussion
Solved
What IMPORT should i use for the SECURITY updates for BRApi
Hi All,
i am new to OneStream, i tried creating BR for Security automation. below is my entire code in OS-BR.
Imports System Imports System.Collections.Generic Imports System.Data Imports Syst...
You have requested a single security group:
Dim allGroups As GroupInfo = BRApi.Security.Admin.GetGroup(si, "QA_Admin")So the error is saying that you are treating the return allGroups as a collection ie you think it contains List(Of GroupInfo) when it is a single GroupInfo. Get rid of the For loop. And as sameburn says MessageBox is not valid - use api.LogMessage for Finance BRs. And you then will be checking the name like this:
If allGroups.Member.Name.StartsWith("QA_") ThenThe message is a bit pointless though except to confirm that the security group QA_Admin exists. If you want all the security groups you want something like this:
Dim allGroups As List(Of Group) = BRApi.Security.Admin.GetGroups(si)Note the return is a list of Group not GroupInfo.
Instead of using the API, can i able to pull these details directly from backend data base. i am wondering since this is a cloud based applciation. does it possible?
You can access the backend database with cloud applications through the Business Rules. The security groups are held in the Framework database in the table SecGroup which has 4 columns:
[UniqueID] [uniqueidentifier] NOT NULL
[Name] [nvarchar](100) NOT NULL
[Description] [nvarchar](200) NOT NULL
[XmlData] [nvarchar](max) NOT NULL