ContributionsMost RecentMost LikesSolutionsRe: What IMPORT should i use for the SECURITY updates for BRApi 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] [...Re: Execute Excel book and save excel file in shared folder You can execute a book from Business Rules (the Parcel Service solution has an example - OPS_SolutionHelper) and from there you can call it from a Data Management step. Re: How do we write a BRApi code for SetDataCells? There is a good example and explanation by Henning here: https://community.onestreamsoftware.com/t5/Rules/Rule-to-write-to-Cell-Details/td-p/36303 Re: How to export data out of BR I did a quick search for Business Rule training courses. Here are two I found (I have not attended either of them and I have no knowledge about them): https://keyteach.com/component/content/article/...Re: How to export data out of BR I don't know why you are making things complicated. sameburn gave you a great starting point. I have updated your script. Try ' Get all security groups Dim groupsObj As List(Of Group) = BRApi.Se...Re: What IMPORT should i use for the SECURITY updates for BRApi 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 colle...Re: Function to get the workflow to which an entity is assinged? All the api functions approach from the workflow aspect to show the hierarchy and the workflow attributes. And the Entity is an attribute of the workflow. The options you have are to use the existing...Re: Workflow Profile Hierarchies: Security Model | Application Security Roles v Workflow Security The basic set up for managing Workflow Profiles is that the user must have Application User Interface: WorkflowProfilesPage. Then if you give the user the Application Security Role ManageWorkflowProf...Re: Matrix data load with entities in columns The matrix Data Source will need to have the maximum possible number of Entity columns. You would then need to have a Transformation Rule to handle empty Entities so that they are set to Bypass (eg s...Re: Where are journal attachments stored in OneStream? Journal attachments are not saved to a folder in OneStream. You are correct in that they are saved to the table Attachments. They are accessed from the Journals module - the Journal UniqueId is used ...