Security users adding/removing

Satish  - I am afraid that you can access the system tables from 3rd party tool. rather you can use API trigger user management. Ex if you have 3rd party API to create a User then call in OS then pass the JSON response to BRAPI to create user. Basically 3rd party API -> JSON -> BRAPI (OS). Hope this helps.

Hi Satish

I think you would be better and safer off developing OneStream business rules to perform your security management that can then be executed from your third party tool. There are REST API end points to allow you to execute OneStream DM jobs.

- Daniel

Also look at Provision Request Manager (PRM) on Solution Exchange. It allows you to automate provisioning by updating a relational table rather than writing custom code. If you still choose the custom code route, it can provide good code examples. PRM is moving to OpenPlace in August. 

Satish​ were you able to automate the security provisioning. i am also trying for that. do you mind share a sample code for Provisioning and is there any option to extract all user with their group and few other details into a CSV. i am able to extract seperatly as GROUP and USERS. but not together. also i have issue extracting the "External Provider User Name" detail (unable to extract and unable to update this field in OS using API). not sure i am using corret API

Hi DK,
Yes, was able to achieve by using RESTAPI.

Thanks
Satish P