Forum Discussion

DK_OS's avatar
DK_OS
New Contributor
28 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
20 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
    20 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