Sharepoint connector (Sharepoint front connector added new Sites return type)

  • 239 Views
  • Last Post 21 February 2020
Eric Rutgers posted this 20 February 2020

Hello Scanshare,

 

In the update of V4.10: KB000038 is a note about the option to get a return type 'Sites'.

What exactly is the new option?

 

For a costumer I have to make a search option for sites and the in the site show all the folders of a librarie.

See the uploaded file for more information.

 

Kind regards,

Eric Rutgers

Attached Files

Order By: Standard | Newest | Votes
luigi.zurolo posted this 20 February 2020

Hi Erik,

your graph doesn't make much distinction about what node is a site and what is a library, however it looks like yes whatever they are.

"Sites" means just the Sharepoint Site, as you know Sharepoint can have multiple sites and subsites and every site can have libraries and each library can have folders. We support to browser all levels of this hierarchy so that you can potentially create a workflow full dynamic according the specific customer case.

  • Liked by
  • Eric Rutgers
Eric Rutgers posted this 20 February 2020

Hi Luigi Zurolo,

Thank you for your comprehensive answer.

Now I see in Sharepoint that there is no use of subsites but hubsites.

Is there an option to request all hub sites of a site in DN?

 

Kind regards,

Eric

luigi.zurolo posted this 21 February 2020

Hi Eric,

hub sites may not appear in the list, however they are not part of the DN connector scope since you need anyway a library in order to upload the document and the libraries are part of the sites merged into the hub site, at this scope you will need anyway to select the site (merged in the hug) to which the target library belongs.

Eric Rutgers posted this 21 February 2020

Hello Luigi,

 

I have make a Powershell script to get all Hubsite from a site:

CLS

$userName = "admin@contosnmicrosoft.com"

$passWord = "contosopassword"

$encPassWord = convertto-securestring -String $passWord -AsPlainText -Force

$cred = new-object -typename System.Management.Automation.PSCredential -argumentlist $userName, $encPassWord

Connect-PnPOnline -Url "https://contoso-admin.sharepoint.com/" -Credentials $cred

#Getting the hub site id for which we want to generate the report - those are connected to this hub site.

$hubSiteURL="https://contoso.sharepoint.com/sites/contoso"

$hubSite = Get-PnPTenantSite $hubSiteURL  

$hubSiteId = $hubSite.HubSiteId

write-host "Hub Site URL: " $hubSiteURL

$associatedSites = @()

#Get all sites associated to the hub site(in the above hub site)

$sitesTenant = Get-PnPTenantSite -Detailed 

# Create a new XML File

[System.XML.XMLDocument]$oXMLDocument=New-Object System.XML.XMLDocument

[System.XML.XMLElement]$oXMLRoot=$oXMLDocument.CreateElement("sites")

$oXMLDocument.appendChild($oXMLRoot) 

$sitesTenant | select url | % {$oneSite = Get-PnPTenantSite $_.url 

  if($oneSite.hubsiteid -eq $hubSiteId)

  {

     if(![string]::IsNullOrEmpty($oneSite.title)) {

        write-host "HUBSITE: " $oneSite.title

        [System.XML.XMLElement]$oXMLSystem=$oXMLRoot.appendChild($oXMLDocument.CreateElement("site"))

        $oXMLSystem.SetAttribute("sitenaam", $oneSite.title)

        $oXMLSystem.SetAttribute("siteurl", $oneSite.url)

        }

   }

}

# Save File

$oXMLDocument.Save("c:\temp\sharepointsites.xml")

 

And the above XML I use in DN.

 

Kind regards,

Eric

 

Close