Skip to main content

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

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


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


Reply