Forum Discussion

DK_OS's avatar
DK_OS
New Contributor
13 days ago

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
DK_OS's avatar
DK_OS
New Contributor
5 days 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
5 days 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