Do you want to share the Hub Site documents on your associated sites? If so, then this article is for you! Follow the simple steps listed below and you will be able to connect to the documents of your Hub Site on the associated sites.


So, let’s start.


Step 1: Determine the Department ID property


Either in your Hub Site or in your Associated site, open the Developer Tools Console.

In the Chrome browser, you can do this by simply pressing the F12 key. 


Alternatively, you can click the right mouse button anywhere on the page and perform these two steps:


1. Select Inspect from the drop-down list.

2. The Developers Tools panel will appear. Inside the Developer Tools, switch to the Console tab and type: _spPageContextInfo.hubSiteId


Your Department ID will now appear below the command. It contains numbers and letters divided by dashes in the format: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx (for example, 98b99eb0-ae82-abda-4fa7-a4e87defb95be).


Copy and paste the Department ID into a text editor and save for later.


Step 2: Prepare the REST API URL


The REST API URL is given below, but before we use it we must make two changes.


The Department ID you have copied in Step 1 should be pasted twice into the URL (replace parts highlighted with blue).


https://tenantname.sharepoint.com/_api/search/query

?querytext='ContentTypeId:"0x0101*" AND IsDocument:True AND (DepartmentId:{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx} OR DepartmentId:xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)'&rowlimit=1000&sourceid='40f080a5-da63-4dce-b33a-fdad0dc83d1c'&refinementfilters='fileExtension:or("docx","wmv","pdf","doc","xls","xlsx","ppt","pptx","mpp","csv","txt")'


Additionally, please substitute the part highlighted in red with your tenant name. Here is an example of what we have used in our case:


https://myawesomecompany.sharepoint.com/_api/search/query

?querytext='ContentTypeId:"0x0101*" AND IsDocument:True AND (DepartmentId:{98b99eb0-ae82-abda-4fa7-a4e87defb95be} OR DepartmentId:98b99eb0-ae82-abda-4fa7-a4e87defb95be)'&rowlimit=1000&sourceid='40f080a5-da63-4dce-b33a-fdad0dc83d1c'&refinementfilters='fileExtension:or("docx","wmv","pdf","doc","xls","xlsx","ppt","pptx","mpp","csv","txt")'


Congratulations. Your REST API URL is now ready. This query is used to get all the items from your libraries/site collections.


Step 3: Insert a ShortPoint Element


From the ShortPoint Page Builder, select File Lists element and press Insert.




Step 4: Connect


Open the File Lists settings by pressing the cog wheel.


Switch to the Connect tab and choose Rest API:


Paste the Rest API URL as created in Step 2 and click Connect.


The Connect button will turn to red Disconnect button if you follow all the steps correctly as shown in the picture.


Step 5: Map the fields


Switch to the Items tab and use the chain icon buttons at the right end of the fields to connect the items. 

Choose the necessary columns from the drop down and press Preview to check how your result will look like and/or Update to save the changes.

Note: if you want the file types icons to be displayed, select the option File type in the Link field: 



Result


After you save the page, you will see the connected File Lists:


Useful Filters

You can use the below-mentioned queries if you want to skip any file type from the list of documents or if you want to exclude a site collection/ specific document library from the search result.


Filter file type, remove not required ones from fileExtension

Simply delete the file type from the query (e.g., "txt", "ppt", "xlsx"). 

Below is the example of a query, which returns us all the files except PowerPoint presentations (file types: .ppt and .pptx):

https://tenantname.sharepoint.com/_api/search/query?querytext='ContentTypeId:"0x0101*" AND IsDocument:True AND (DepartmentId:{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx} OR DepartmentId:xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)'&rowlimit=1000&sourceid='40f080a5-da63-4dce-b33a-fdad0dc83d1c'&refinementfilters='fileExtension:or("docx","wmv","pdf","doc","xls","xlsx","mpp","csv","txt")'

Note: do not forget to change your DepartmentId and your tenant name.

Exclude a site collection or a specific document library from the search result

Replace the "SiteName" part in the query with your site collection you would like to exclude:

https://tenantname.sharepoint.com/_api/search/query?querytext='ContentTypeId:"0x0101*" AND IsDocument:True AND AND NOT Path:"https://tenantname.sharepoint.com/sites/SiteName/" (DepartmentId:{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx} OR DepartmentId:xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)'&rowlimit=1000&sourceid='40f080a5-da63-4dce-b33a-fdad0dc83d1c'&refinementfilters='fileExtension:or("docx","wmv","pdf","doc","xls","xlsx","ppt","mpp","csv","txt")'

Replace the "DocumentLibraryName" part in the query with your document library you would like to exclude:


https://tenantname.sharepoint.com/_api/search/query?querytext='ContentTypeId:"0x0101*" AND IsDocument:True AND AND NOT Path:"https://tenantname.sharepoint.com/DocumentLibraryName/" (DepartmentId:{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx} OR DepartmentId:xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)'&rowlimit=1000&sourceid='40f080a5-da63-4dce-b33a-fdad0dc83d1c'&refinementfilters='fileExtension:or("docx","wmv","pdf","doc","xls","xlsx","ppt","pptx","mpp","csv","txt")'


Note: do not forget to change your DepartmentId and your tenant name.

Related articles: