on 2024 Nov 14 2:29 PM
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...
...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:
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.
We can already see this folder structure in the Dataflow of the Datasphere:
But as soon as we drag and drop the "test.csv" file in, we get the following error message:
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')
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:
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.
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
Request clarification before answering.
Look to the 3425630 - Sharepoint Open Connectors supports only English language for now - SAP for Me
For us it was the solution
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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
User | Count |
---|---|
50 | |
9 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.