Skip to main content

Hi

I have following requirement to have ceolins user info. in SharePoint O365 excel file

 

Step1: Download & Upload all Celonis User Information in Excel File in office 365 

(Do we have any database table for this user information, like when the onboarding was done, when user was locked and which user groups and permission we assigned to this user, I want to see that information in SharePoint excel file.)

 

Step2: Every Onboarding, off-boarding and locking of user get updated by action flow in Excel file in Office 365.

 

Celonis User Database --> Update in O365 Excel file on any change in Celonis user

 

Thanks

Animesh

Hello,

 

I would break down such process into steps:

A) You'll need to send API request to get Dataframe for celonis users on hourly basis (put it on schedule). More details can be found here:

Link 1: https://www.celopeers.com/s/question/0D50700000dYo4DCAS/hi-allis-there-any-table-which-stores-the-celonis-users-list-in-it-like-all-users-list-who-have-access-to-celonis-ibc-the-only-option-to-get-user-list-is-to-export-from-team-settings-users

 

Link 2: https://www.celopeers.com/s/question/0D50700001hpKPsCAM/hi-i-wanted-get-to-extraction-logs-through-api

 

B) You'll have to authentificate to MS graph in order to:

1) Create excel file if that not exist

2) If excel exist: load it and compare with current users DF. If there's difference - then you can add new row to that excel fie.

 

More on MS graph authentication can be found here: https://www.celopeers.com/s/question/0D50700001g8miRCAQ/connection-to-sharepoint-site-to-get-a-custom-file-and-then-use-it-in-data-model

 

I think there's no possibility to trigger python script by updating user details - you can only schedule it very frequently to track these changes every hour or so.

 

Best Regards,

Mateusz Dudek


Reply