Forum Discussion

DK_OS's avatar
DK_OS
New Contributor
5 months ago
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...
Admin
System
  • MarcusH's avatar
    MarcusH
    5 months ago

    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_") Then

    The 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.

DK_OS's avatar
DK_OS
New Contributor
4 months ago

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?

MarcusH's avatar
MarcusH
Valued Contributor
4 months ago

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