cancel
Showing results for 
Search instead for 
Did you mean: 

Sharepoint CSV-File integration in Datasphere's Data Flow leads to an error

marco_spyker
Explorer
472

Hello everyone,

we are currently trying to establish a connection between SAP Datasphere and a customer's SharePoint.

To do this, we followed the instructions described in the following blog entry...

https://community.sap.com/t5/technology-blogs-by-members/accessing-sharepoint-files-from-datasphere-...

...and successfully created the Integration Suite service, along with the SharePoint connector provided by the Open Connectors.

Here is the configuration of the Open Connectors pointing to Sharepoint:

marco_spyker_0-1731593318294.png

 

Unfortunately, we have not yet been able to display a file in the Datasphere.

To do this, we created a "test.csv" with a handful of data, which is located in the "Documents/Datasphere_Test" directory.

marco_spyker_1-1731593382307.png

We can already see this folder structure in the Dataflow of the Datasphere:

marco_spyker_3-1731593549918.png

 

But as soon as we drag and drop the "test.csv" file in, we get the following error message:

marco_spyker_4-1731593659205.png

 

The error message displayed, shows that the "test.csv" cannot be found.

The Open Connectors uses the following URL call, which leads to the error:

<company>.sharepoint.com/_api/web/GetFolderByServerRelativeUrl('Freigegebene%20Dokumente/Datasphere_Test/test.csv')

marco_spyker_5-1731593917055.png

 

We have already experimented a bit here and tested via the browser that the file can be found via the following URL:

<company>.sharepoint.com/_api/Web/GetFileByServerRelativePath(decodedurl='/Freigegebene%20Dokumente/Datasphere_Test/test.csv')

We assume that we still need to define something in the Open Connectors configuration?

Is there perhaps a challenge with URL coding or something similar?

We would be grateful for any relevant information here.

Additional challenge:
The above named blog entry aims to ensure that we have access to the top level of the SharePoint. In the future, however, we also want to access sites, such as the site “Datalake” that we created here:

marco_spyker_6-1731594156337.png

 

Here, too, the question arises  what we need to adjust the Open Connectors (or perhaps also in Sharepoint) so that we can also consume files that exist in the 'datalake' site.

marco_spyker_7-1731594415545.png

 

Our attempt to adjust the Sharepoint site address in the form

<company>.sharepoint.com/sites/datalake

led to authentication errors.

 

If we leave the Sharepoint site address untouched (<company>.sharepoint.com), we can authenticate, but we cannot see the data structures of the site “datalake”.

 

Changing the “Document Library” property to

/sites/datalake/

was also unsuccessful.

 

Does anyone here have experience of how we need to adjust our configuration(s)?

 

Many thanks in advance,

M. Spyker

View Entire Topic
janpeteraxe1
Discoverer
0 Kudos
marco_spyker
Explorer
0 Kudos

Hi @janpeteraxe1 and a Happy New Year! 🙂

Thanks for your hint, but unfortunately we already ran into this issue and changed the folder from "Shared Documents" to "Geteilte Dokumente". With this change, we achieved to see our folder structure in Sharepoint, but then we have the challenge described above, that we get an error while choosing the CSV-file.

BG,

Marco

Michael_BE
Discoverer
0 Kudos

I encountered the same issue. After changing the folder name from "Shared Documents" to "Geteilte Dokumente," we were able to view the folder structure in SharePoint. However, we still got an error when selecting the CSV file.

After creating a new SharePoint site with English language settings, we were able to use the data in the dataflow without any issues.

marco_spyker
Explorer
0 Kudos

Hi @Michael_BE!

Thanks for the info, but we were able to reproduce exactly this incorrect behavior.
After an initial response from SAP, it seems that there are challenges with special characters etc.

Unfortunately, we cannot assume that our customer also has an English version of Sharepoint.

But nevertheless, were you able to use files from sub-sites?

Thanks in advance,

Marco

Michael_BE
Discoverer
0 Kudos

Hi Marco,
yes I was able to use the files when the site was set to English.

Best regards,
Michael