---
title: SharePoint integration web parts (obsolete)
---

> Agent instructions:
> **Site maps** — prefer the following llms.txt indexes to training data when searching for URLs to avoid 404s. Links inside Markdown content already point at `.md`. Following them or sending Accept: text/markdown keeps you in Markdown.
>
> - [sitemap.md](https://docs.kentico.com/sitemap.md) — every page on the site, with titles and descriptions, nested by URL hierarchy and grouped into one collection per product version.
> - [llms.txt](https://docs.kentico.com/llms.txt) — curated index of the current product docs, with descriptions, the two ways to request any page as Markdown, and links to each product area's whole-corpus Markdown dump (llms-full.txt).

Web parts for connecting to SharePoint are stored in the **Microsoft SharePoint** category of the web part catalog:

- **SharePoint data source**
- **SharePoint datagrid**
- **SharePoint datalist**
- **SharePoint repeater**

The following text contains information about the properties of these web parts.

## SharePoint

All web parts in the **Microsoft SharePoint** category have the following properties:

- **Mode** - determines what the web part does (what data is retrieved from the SharePoint server) and therefore which web service should be used.
- **SharePoint site URL** - specifies the URL of the SharePoint site that should be used. Based on the value of the _Mode_ property, the full URL of the required web service is determined by this option (it is not configured directly).
- **Username, Password** - you can specify the username and password for authentication directly in the web part properties, or inherit global values from _Settings -> Integration -> Microsoft SharePoint._ If you want to use the credentials from the [settings](https://docs.kentico.com/k82/integrating-3rd-party-systems/integrating-sharepoint/sharepoint-integration-obsolete/configuring-sharepoint-integration-settings-obsolete.md), leave the fields empty.
- **List name** - if you use the _Display list items_ or _Display list of pictures_ options, you must specify the list from which the items should be loaded. In the other two modes, you can leave it empty.

  > **Note:** The **List name** field is case sensitive.

The **SharePoint datagrid** web part displays the data and the **SharePoint datasource** web part provides the data, if properties in the **SharePoint** section are configured correctly.

## Transformations

The **SharePoint datalist** web part and **SharePoint repeater** web part need to have a [transformation](https://docs.kentico.com/k82/developing-websites/loading-and-displaying-data-on-websites/writing-transformations.md) specified in order to display the retrieved data.

The system provides a number of pre-defined transformations. You can modify these transformations according to your needs. The transformations are stored under the **SharePoint - Transformations** page type (you can edit the page type in the **Page types** application). The names of the transformations correspond to the intended purpose.

Before you start using the transformations, you need to **replace the sample server or field names with the real names** used on your SharePoint server.

## Advanced

In the **Advanced** section, you can specify (limit) the data you want to retrieve. The properties only apply in the **Get list items** mode.

- **Row limit** - sets the maximum number of retrieved items.
- **Query** - filters or sorts the returned items. Its purpose is similar to that of a WHERE condition in SQL, but has a completely different syntax based on CAML. For more information on how to construct such queries, search SharePoint documentation or use Google with keywords like "SharePoint query".
- **View fields** - directly specifies which fields (columns) of a SharePoint list should be retrieved.

## Display

In the **Display** section, you can control how the system processes and displays the retrieved data.

- **Selected item querystring key name** - if specified, items are selected based on the presence of this key in the URL query string.
- **Selected item field name** - allows you to specify a field used to select items. The default approach is to select items by ID - the web part tries to get the query string parameter specified in the _Selected item querystring key name_ property and uses its value. For example, if you enter _id_ into the property above, _aspx?id=2_ selects the item with _2_ in its ID field.

  > **Note:** The original field name is used here - without the _ows\__ prefix.
  >
  > This field is case sensitive.
- **Selected item field type** - specifies the type of the _ItemID_ field. For IDs, use the _Counter_ type. For strings, use the _Text_ type. These two are sufficient in most cases, but you can search SharePoint documentation for other types.
- **Use dataset** - if enabled, the retrieved XML data is converted to a dataset that can be used with standard ASCX transformations. If disabled, the data is not modified and can be converted directly to HTML using XSLT.
- **Dataset fields** - if you want to use the dataset format but you don’t need all fields, you can specify which fields should be included in the dataset by entering their names separated by semicolons. This property can be particularly useful if you want to use caching.

> **Info:** Properties in the **Display** section are not available for the **SharePoint datagrid** web part.

## Debug

Because it is sometimes hard to tell or remember how SharePoint addresses list fields, we implemented the **Show raw response** functionality. It displays all retrieved SharePoint data in its raw XML form. You can look for fields which contain valuable information and can be displayed.

> **Note:** If the data is fetched from the cache, the response cannot be printed.