Skip to Content

SharePoint File System connection guide for Jitterbit App Builder

Overview

This guide describes the system requirements and instructions for connecting App Builder to a Microsoft SharePoint File System database server.

Note

The Microsoft SharePoint File System connection is read-only. App Builder can retrieve and display files from SharePoint, but cannot write or modify them through this connector.

Important

As of April 30, 2026, SharePoint File System connections require OAuth authentication. To use OAuth, upgrade to App Builder 4.61 or later and follow the Microsoft SharePoint OAuth connection guide to set up an OAuth security provider before creating a data server.

System requirements

Database server

Microsoft SharePoint File System

Client web browser

  • Chrome: 84+

  • Firefox: 73+

  • Safari: 13.0.1+

  • Edge: 84+

Connection instructions

Adding a data server

  1. Go to IDE > Data Servers.

  2. Click + Server. The Server page opens. Provide the following information:

    • Server Name: Identifiable name for server connection

    • Type: Microsoft SharePoint File System

    • URL: URL associated with SharePoint instance

    • Expand Security Settings:

      • Select the OAuth security provider from the Security Provider list.

  3. Click Save.

Configuring path and directory browsing

After adding the SharePoint data server, configure the following settings so that App Builder looks at the SharePoint root directory and supports directory browsing.

  1. Go to IDE > Data Servers.

  2. Select the SharePoint server you created. A tile appears in the right panel. Double-click the tile or click the icon to see advanced options.

  3. Click Edit.

  4. Expand the File section and confirm the following:

    • Path is blank or null.

    • Directory Browsing is enabled.

  5. If you made any edits, click Save. If not, exit the dialog.

Importing database

  1. Go to IDE > Data Servers.

  2. Select the Microsoft SharePoint File System server. A tile appears in the right panel. Double-click the tile or click the icon to see advanced options.

  3. Click Edit.

  4. Expand the Utilities section.

  5. Click Tables. The Tables dialog opens.

  6. Click the Results icon on any table row to view the records in the file table.

Use case example

One use case is displaying a page that lists SharePoint files and renders the selected file in a panel. Build a page with two panels: a multi-row panel to list files on the left, and a single-row panel to render the selected file on the right.

In this example, a copy of the SharePoint file table is stored in an application SQL data source. The left panel uses the copied SQL table; the right panel uses the SharePoint file table directly.

Use the Embed control type and point it to the Content column to render the file. For more information, see the Control types page.

Important notes

  1. Files must be stored in the Documents directory. App Builder can only access files stored under that directory.

  2. File names are case sensitive when binding between data sources. For example, if the SharePoint file name is file.pdf, it must be referenced as file.pdf in all other data sources. Mismatched casing causes App Builder to not render the content correctly.

  3. When building a path to a directory in a business object, use \\ instead of /. The forward slash causes an error.

    • Example of working path: \documents\employees
    • Example of non-working path: /documents/employees

Troubleshooting

If you experience issues with SharePoint, try the following:

  1. Enable data logging to generate log files that you can download and inspect.

  2. Refer to the CData ADO.NET Provider for Microsoft SharePoint documentation for detailed information.