Skip to main content
Question

Extractor configuration for data transfer from MS Sharepoint to Celonis

  • January 8, 2025
  • 3 replies
  • 192 views
thomas.guerr
Level 7
Forum|alt.badge.img+1

Hello,
I am trying to get data from a Microsoft sharepoint list to the Celonis Platform.
According to the Flowchart provided by the API-Team - When to use the Standard Data Ingestion API (and other methods) - the extractor builder should be used for a Sharepoint data transfer, since the REST API is exposed.
I tried to set up the connection, but I fail when configuring the endpoint, since I get xml-data even if I specify that I would like to have a json structure (Request Parameter - Accept: application/json;odata=verbose)

Does anyone have experience with connecting the MS universe with the Celonis universe?

I also found a workaround that works (Push CSV to Data Integration), but I would rather orchestrate all the data loads in the Data Integration environment instead of using Process Automation modules to make a data transfer.

Thanks for your support!

BR THomas

3 replies

steffi.van.d12
Level 1
Forum|alt.badge.img+11

Hi ​@thomas.guerr I hope you are doing well. Did you manage to get it working with the extractor builder in the end? I am facing the exact same tradeoff at the moment between using Action Flow or the preferred way to have everything in Data Integration, so any challenges and/or solutions you would be able to share are much appreciated.

Thank you in advance, 

Steffi

thomas.guerr
Level 7
Forum|alt.badge.img+1
  • thomas.guerr
  • Author
  • Level 7
  • May 24, 2025

Hi ​@steffi.van.d12 
following to this I got in touch with an expert through our VE.
They confirmed that they would recommend using the Action Flow (and since the AF-module works with the Graph API this only allows identification with an actual user - so it is not possible to have a generic access to the SharePoint data as far as i know). So this is actually not ideal in terms of Business Continuity...

I also tried to look into the new connector builder experience (it will go into general availability soon or it maybe is already), but this will apparently only be a remake of the frontend with the same functionality).
Though, I keep reading on various sites, that an access (specifically to Sharepoint Lists) should be possible through the REST API and not only the Graph API. So I will look into this as soon as our SharePoint specialist have time for looking into this issue.

I will keep you posted on this.

BR Thomas

thomas.guerr
Level 7
Forum|alt.badge.img+1
  • thomas.guerr
  • Author
  • Level 7
  • November 7, 2025

Hello ​@steffi.van.d12 ,
short update on this topic: the connection with the extractor is apparently still no option.
I work with Action Flows that extract data from MS Sharepoint and push the data in Celonis via ingestion API.
The extraction of data via Action Flows is restricted to 1000 entries in a Sharepoint list and you get a follow-up URL from the Sharepoint module, so i work with repeaters.

It is a workaround, but it does the job.
I hope to get a solution to this topic sooner or later


BR Thomas

Community Code of ConductAccessibility statement