Our goal is to write files on Sharepoint. Therefore, we used the Sharepoint Online Connector transformer, whereat the connection to Sharepoint works fine, but we currently have the following issue: The specific site we want to connect to does not show in the sites list within the transformer. We already checked the rights, but everything looks correct.
What are the preconditions that a specific site is listed in the site list and can be used by the Sharepoint Online Connector transformer?
Having the same experience and also would like to know how to fix this.
I recently created a new sharepoint site and couldn't find it in the list. The next day I tried again and it appeared in the list. Currently I can't find it anymore and I need to look for the old workspace to copy the transformer from to get it to work.
Finding the guid's and enter them manually is an acceptable workaround for me.
Has this not been answered? I'm having the same issue. Can see all sites in the org except for the one I need. I have owner rights through OSA so it cannot be permissions issue. Am i missing a setting?
Has this not been answered? I'm having the same issue. Can see all sites in the org except for the one I need. I have owner rights through OSA so it cannot be permissions issue. Am i missing a setting?
My workaround is to add
/_api/site/idat the end of the url of the sharepoint site, so you get
https://myorg.sharepoint.com/sites/mysite/_api/site/idYou will then get an XML with a GUID:
<d:Id xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices"
xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"
xmlns:georss="http://www.georss.org/georss"
xmlns:gml="http://www.opengis.net/gml"
m:type="Edm.Guid">c59d2bd7-6a23-4dde-a181-b8fc01d74eba</d:Id>Now take your org root url and the guid and put them together like
myorg.sharepoint.com,c59d2bd7-6a23-4dde-a181-b8fc01d74ebaand put this string in the Site field in the SharePointOnlineConnector.
Has this not been answered? I'm having the same issue. Can see all sites in the org except for the one I need. I have owner rights through OSA so it cannot be permissions issue. Am i missing a setting?
My workaround is to add
/_api/site/idat the end of the url of the sharepoint site, so you get
https://myorg.sharepoint.com/sites/mysite/_api/site/idYou will then get an XML with a GUID:
<d:Id xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices"
xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"
xmlns:georss="http://www.georss.org/georss"
xmlns:gml="http://www.opengis.net/gml"
m:type="Edm.Guid">c59d2bd7-6a23-4dde-a181-b8fc01d74eba</d:Id>Now take your org root url and the guid and put them together like
myorg.sharepoint.com,c59d2bd7-6a23-4dde-a181-b8fc01d74ebaand put this string in the Site field in the SharePointOnlineConnector.
Thanks for this - this also works if you’ve only been given access to a subset of a SharePoint site (i.e. not its entire contents) - the site wouldn’t appear on my ‘list’ of sites to connect to, but this worked and I was able to see the contents i had been granted access to.