DXP
Digital Experience Platform Squiz Marketplace

Supercharge your Squiz DXP with components, templates, extensions, and more.

Multiple use cases for Funnelback & Sharepoint (Office 365)

A range of the most common Funnelback and Sharepoint use cases in a single recipe - just delete what you don’t need

Implement this recipe to enable some of the key Funnelback / Sharepoint use cases. It’s easy to delete flows for use-cases you don’t need, and you can customise flows if you have additional requirements.

  • Retrieve list of files from a Sharepoint document folder and push them to a Funnelback collection for search
  • Retrieve the file metadata with permission detail from a Sharepoint document folder and push it to a Funnelback collection for search. This flow constructs the permission detail as the document lock string and push to a Funnelback push collection.

Note: This recipe provides a starting point for Funnelback to index Sharepoint documents via Connect,  it doesn't cover the end to end solution for supporting document level security which will involve an additional search query interface and key-lock string matching functionality outside the Connect platform

Sharepoint Funnelback Use case

It’s easy to integrate using a Recipe. All you need is the right credentials to connect. We recommend you test the integration with a Sandbox account before using it in production.

  1. Click the Activate recipe button to deploy this Recipe in Squiz Connect.
  2. Sign into Squiz Connect if you’re not already signed in.
  3. Follow the on screen instructions to finish deploying the Recipe.

Setting up the integration

There are 4 key steps to setting up this integration - both of which are explained in greater detail below:

  1. Configure Microsoft Azure App registration to get the credentials for Sharepoint
  2. Activate the recipe in Connect by adding or selecting credentials for Sharepoint and Funnelback
  3. Provide configurations for the Sharepoint settings
  4. After the recipe is activated, point the flow to connect to your selected Sharepoint site

Provide configurations for the Sharepoint and Funnelback settings

At the recipe activation step 5, you need provide configurations for the Sharepoint settings. Below is a template that you can copy and paste into the configuration credential field, and just replace the minimal three value fields in bold.

{
  "sharepoint": {
    "path": "",
    "folderId": "root",
    "options": {
      "orderBy": "",
      "select": "",
      "top": "",
      "skipToken": ""
    }
  }
}

Set up flows to connect to your selected Sharepoint site

Once you have activated the recipe, review the flows that have been created and delete any flows you don't need. For the flows you do need, you can now edit them to point to the correct Sharepoint site.

Go to the Sharepoint step of the flow to select the Site Identity. The dropdown list shows the sample Sharepoint sites from the recipe. Click the reload icon to refresh the list from your Sharepoint instance.

reload sharepoint site dropdown

TypeRecipe
For  Squiz Connect
Flows 2
  Documentation