The SharePoint Agent imports contacts from a list located on a SharePoint Server into an address list. The agent uses a default mapping of list fields to vCard fields, but a custom mapping can also be configured.
The SharePoint Agent configuration example shows a sample configuration of the SharePoint agent. The agent will connect to the SharePoint web site http://intranet.messageconcept.com and fetch all contacts from the list named “Suppliers”. No custom field mapping is defined; instead, the default mapping is being used. The credentials used for the connection are stored in the action account named “SharePoint Action Account”.
Requirements
The following requirements must be met by the source system:
-
Microsoft Office 365 SharePoint Online OR
-
Microsoft SharePoint 2010 and higher
Configuration
The SharePoint Agent uses the following configuration parameters:
SharePoint URL: The SharePoint Site’s base URL, not the URL to the list directly. Example: http://intranet.msio.de, https://extranet.msio.de
SharePoint Edition: SharePoint on premise or SharePoint Online.
Auth Scheme: The authentication mechanism for connecting to SharePoint. Default is NTLM. For SharePoint Online, AzureServicePrincipalCert must be used.
Account: An account that has the right to view the content of the list.
List Name: The name of the List. Example: “Clients”
Filter Conditions: A list of filter conditions. Blank, if no conditions are specified. The following operators may be used:
-
And
-
Or
-
Equals / Does not equal
-
Is less than / Is less than or equal to
-
Is greater than / Is greater than or equal to
-
Contains / Not Contains (Use Wildcard Operator ‘%’)
-
IN / NOT IN
-
Begins With / Ends With
SharePoint Online
To connect PeopleSync to SharePoint Online, an app registration that utilizes certificate-based authentication must be used. PeopleSync facilitates this process by providing an Entra ID App Certificate.
Starting from 05/01/2026, IDCRL authentication is disabled and will no longer be supported for SharePoint Online connections. To ensure continued access, you must use an Entra ID App Certificate for authentication from this date forward.
To connect to SharePoint Online, complete the following steps:
-
Create an App registration with certificate authentication as explained in 6.2.3 Entra ID App Certificate.
-
In a browser, navigate to https://portal.azure.com, then go to Entra ID.
-
On the left-hand side, select App registrations, then open the relevant app registration in the list.
-
In API Permissions, click on “Add a permission”.
-
Select SharePoint API:
-
Choose Application permissions.
-
Choose Sites.Read.All and Sites.Selected permissions.
-
Click on “Add permissions”.
-
Grant admin consent for the permissions.
-
Use the Entra ID App Certificate in your SharePoint Agent.
Make sure Auth Scheme is set to AzureServicePrincipalCert.
Field Mapping
All SharePoint fields may be freely mapped to contact fields. A default mapping is provided for contact lists.
The field mapping shows the names of the vCard fields as field names. The corresponding name of the source field must be entered into the text box next to the vCard field.
In the field mapping, the following special parameters can be configured:
Image: The source field for the image data
Image Type: The image’s type. One of the following:
-
Automatic: The Agent automatically determines the type of the field.
-
File Name: The source field contains a file name. If it is a relative path, the Image Folder parameter must be set to the base directory.
-
Binary Data: The source field contains binary data.
-
Base64 Data: The source field contains base64-encoded data.
Image Folder: The image file’s base directory. When importing images of type File Name and the attribute value is a relative path, this must be set to the image’s base directory.
Debugging: Enables debug logging to a file in the service account’s temp folder. Enable only if requested by messageconcept support.
Phone Number Mapping
Phone number mapping is supported by this agent. See chapter Phone Number Mapping for details.
Verify the configuration
After completing the configuration:
-
Confirm that the application or account can access the configured SharePoint site and list.
-
Run the agent against a test or controlled address list.
-
Review the agent log for authentication, site, list, and field-mapping errors.
-
Compare several imported list items and photos with SharePoint.
Expected result: The configured SharePoint list is read successfully and its fields map to the expected contacts.