Defining SharePoint Repositories

You can define a URLID that points to a Microsoft SharePoint repository. PeopleSoft uses the URLID and its URL properties to identify the SharePoint repository and to authenticate with Microsoft Graph.

SharePoint repositories can be used with file attachment APIs, such as AddAttachment, PutAttachment, ViewAttachment, DetachAttachment, GetAttachment, and DeleteAttachment, when the URLID used by the API points to SharePoint. The SharePoint repository is accessed through Microsoft Graph REST APIs.

Before defining the SharePoint repository in PeopleSoft, register an application in Microsoft Entra ID and collect the client ID, client secret, and tenant ID information. See Registering an Azure Application for SharePoint Repositories.

Navigation:

PeopleTools, then Utilities, then Administration, and then URLs.

Defining the SharePoint URLID

Use the URL Maintenance page to create a URLID for the SharePoint repository.

See URL Maintenance

Field Description

URL Identifier

Enter a unique URLID for the SharePoint repository.

Description

Enter a description for the SharePoint repository.

URL
Enter the Microsoft Graph endpoint for the SharePoint site. Use this format:
https://graph.microsoft.com/v1.0/sites/<tenant-name>
The URL consists of the following parts:
  • Microsoft Graph endpoint.
  • Microsoft Graph API version.
  • Microsoft Graph resource path for SharePoint sites.
  • SharePoint tenant name, such as <tenant>.sharepoint.com.

Comments

Optionally enter information that identifies the SharePoint site or document library.

Defining URL Properties for SharePoint

After you create the URLID, use URL Properties to define the authentication and repository details required for SharePoint. The URL properties for the SharePoint URLID are listed in this table:

Field Description

CERTALIAS

Specify the certificate alias used for client certificate authentication, if required.

CLIENTID

Specify the Microsoft Entra ID application client ID. Supply a unique identifier (for example, a user name) for the registered app in Azure.

CLIENTSECRET

Specify the client secret generated for the Microsoft Entra ID application. This value should be encrypted, and should be stored securely.

DOCUMENTLIBRARY

Specify the SharePoint document library where files are stored.

KEYSTOREPASSWORD

(Required) For attachments transferred from the PeopleSoft system to the SharePoint repository, the system retrieves the key pair for the client certificate from the digital certificate store and writes them to a file in PKCS12 format with password protection. The value of this property will be used as the password for the PKCS12 file.

The PKCS12 file enables connection and file transfer, and it exists only temporarily in <PS_SERVDIR>\files\<CERT ALIAS NAME> for the duration of the file transfer.

The system deletes the file after the file transfer transaction.

Note: If the system fails to delete the certificate alias file, a message will be written to the application sever log. The maximum number of files that can exist at any time is equal to the total number of FTPS and HTTPS URL identifiers defined in the system.

PROXY

Specify the proxy server (if used).

PROXYPORT

Specify the proxy server port (if used).

SHAREPOINTREPOSITORY

Y: Identifies the repository as a SharePoint repository.

N: Specifies that the URLID does not point to SharePoint.

TENANTID

Enter the Microsoft 365 tenant ID.

VERIFYHOST

0: Do not verify the server for host name.

1: (Default) Checks for a match with the host name in the URL with the common name or Subject Alternate field in the server certificate.

VERIFYPEER

False: Do not verify the peer.

True: (Default) Verify the peer by authenticating the certificate sent by the server.