Sharepoint Location

This file location type enables access to files that are stored in a Sharepoint location.

The following file types are supported. Click to jump to the related documentation.

Sharepoint files can be accessed for extracts and loads. Note that MFA (Multi Factor Authentication) is not supported.

To access Sharepoint, the Microsoft Graph API permissions Sites.Read.All and Sites.ReadWrite.All must be assigned. These permissions grant the connection read and write access to every site and document library in the tenant.

As a least-privilege alternative, the connection also supports the Sites.Selected permission, which grants access only to the specific sites that an administrator assigns to the app registration. See the notes below for the resulting differences in behavior.

Depending on the type of file, some of the following parameters must be filled out:

Setting Description
Type Sharepoint
File name The name of the file in Sharepoint. Use relative paths for files that are located within folders.
User name The username for access to Sharepoint. This field is optional when "Use token connection" is checked.
Password The password for access to Sharepoint.
Use token connection Selecting this checkbox enables the connection to be authenticated with an OAuth2 token. An OAuth Token connection is required in addition to the file connection in Sharepoint. See OAuthToken Connection for details.

The endpoint in OAuthToken connection should be configured this way:

Only for common OAuth endpoint:

Note: if the Use token connection checkbox is selected, the user name field can remain empty.
Azure application ID The application ID in Azure Active Directory (also called App-ID or Client-ID). This ID must be obtained from your IT department.
Site The name of the Sharepoint site can be found at the top of the screen in Sharepoint (see screenshot below). To see sites that you have access to, you can click on My Sites in the side navigation bar of your Sharepoint homepage, also indicated below.

When setting up the Sharepoint connection, you may need to create a new site in Sharepoint. Click on the Create Site icon in the side navigation. Note that there may be a delay after creating a new site ID before it appears in Sharepoint and Jedox.

If the connection uses the Sites.Selected permission, the Site field cannot be populated automatically, so the site name must be entered. See Notes below for more information.
Document library

The name of the document library in Sharepoint you are connecting to. Click on Site contents in the site's menu (indicated in red below) to see all document libraries in the site:

Document libraries can be identified by type in the site contents:

CSV Settings

Header If set, the entries of the first line of source data are used as column headers.
Data delimiter Separators between the columns in the text file, e.g. ",".
  • comma (default)
  • Tab as data delimiter: \t
  • For blank value (" ") as data delimiter: #space
  • semicolon

Any other character is also valid.
Enclosure character The enclosure character of the columns. Possible enclosure characters are:
  • #none (no enclosures)
  • double quotes (")
  • single quotes (')

If no enclosure character is defined, by default double quotes (") is used.
Encoding The most common character encodings are UTF-8 (default), ASCII, and latin1 (Windows standard).

A list of all character codes can be found at http://docs.oracle.com/javase/8/docs/technotes/guides/intl/encoding.doc.html
From this list you can also enter manually a character code into the field ‘Encoding’. Note that this connection only supports file encodings as provided by the Java Runtime Environment.
Use escape character If set, the character “\” invokes an alternative interpretation of the subsequent character.
Example: “1\”Hello\”2” is interpreted as 1”Hello”2

Notes

  • When the connection uses the Sites.Selected permission, the Site dropdown is not populated automatically, because listing all sites in the tenant requires tenant-wide permission. The Document library dropdown still populates automatically once a valid site has been entered.
  • Requesting a site that has not been explicitly granted to the app registration under Sites.Selected returns an Access denied error.

Updated October 19, 2026