Your configuration
<assign to="applicationid">Application ID Here</assign>
Application Id is not configured. Go through the "Prerequisites for Configuring the SharepointClientadapter" in above documentation.
You need to register application through Microsoft Entra. Get the TenantId, Application id from Microsoft Entra.
Attach a public certificate (could be self signed)to the application. Give necessary permission.
Create document library. Assuming you already have Sharepoint Site you are trying to access.
<assign to="certificateid">b2bappq01:node1:1974574e544:991</assign>
These are the CA certificates from Microsoft. It uses multiple CA certificate, different for different sites.
Certificate are different for Entra Id authentication and for sharepoint. Include CA certs for below CN
DigiCert Global Root CA
DigiCert SHA2 Secure Server CA
Microsoft Azure RSA TLS Issuing CA
Also ensure that, certificate are valid and not expired. Check
<assign to="systemcertid">b2bappq01:node1:19923ad05ea:1934369</assign>
The public certificate attached to the application registered in Microsoft Entra, Create pfx file with key and cert.
Upload the pfx file in B2BI system certificate and use that systemcertid in the field. This is used to authenticate with Sharepoint.
------------------------------
Varada Thakur
------------------------------
Original Message:
Sent: Wed October 08, 2025 09:59 AM
From: Leo Delarosa
Subject: Sterling B2B Integrator authentication for SharePoint Online
Hello everyone. I seem to be in a simalar situation here. We are currently using Sterling B2Bi ver 6.2.0.3 and we are trying to get the Sharepoint adapter to work. For our Service adapter we were given the Sharepoint URL, Sharepoint Tenant ID. We reference a Self Signed Certificate in the System Certificate section. In the CA Certificate we reference a Leaf certificate that we received from the Sharepoint admin.
To test this we created a quick SharePoint list service test BP.
<process name="SGWS_Test_Sharepoint_ListService"> <sequence name="Sequence Start"> <operation name="SharepointClientBeginSessionServiceType"> <participant name="SharepointClientBeginSession"/> <output message="SharepointClientBeginSessionServiceTypeInputMessage"> <assign to="." from="*"></assign> <assign to="applicationid">Application ID Here</assign> <assign to="certificateid">b2bappq01:node1:1974574e544:991</assign> <assign to="sharepointclientadapter">SharepointClientAdapter</assign> <assign to="systemcertid">b2bappq01:node1:19923ad05ea:1934369</assign> </output> <input message="inmsg"> <assign to="." from="*"></assign> </input> </operation> <operation name="SharepointClientListServiceType"> <participant name="SharepointClientList"/> <output message="SharepointClientListServiceTypeInputMessage"> <assign to="." from="*"></assign> </output> <input message="inmsg"> <assign to="." from="*"></assign> </input> </operation> </sequence></process>
When we execute this BP we receive this error message:
[Error fetching token : com.microsoft.aad.msal4j.MsalClientException: javax.net.ssl.SSLHandshakeException: com.ibm.jsse2.util.l: PKIX path building failed: com.ibm.security.cert.IBMCertPathBuilderException: unable to find valid certification path to requested target]
has anyone experienced this error message and gotten a way past it?
Thanks for your help and support.
------------------------------
Leo Delarosa
Original Message:
Sent: Thu August 14, 2025 02:10 PM
From: Bibhudatta Panda
Subject: Sterling B2B Integrator authentication for SharePoint Online
Could someone please help with integrating Sterling Integrator with Sharepoint? We have the Sharepoint adapter but Is the trusted certificate the only prerequisite for configuring the SharePoint adapter? I was reviewing the IBM documentation, and it appears that both the System and CA certificates are required
------------------------------
Bibhudatta Panda
Original Message:
Sent: Mon August 05, 2024 04:04 PM
From: Rodrigo Ricardo Pérez memije
Subject: Sterling B2B Integrator authentication for SharePoint Online
I just saw the thread and I hope you have resolved the issue. I also faced a similar development. To solve it, I created a JavaTask and integrated it into the BP. Since I was using a myriad of libraries, some of which Microsoft does not have the .jar files for, I created my own jar using Maven and converted it to a jar to execute in Sterling. However, it seems that there are things that the Sterling compiler cannot understand, so my solution was to use a CLA (Command Line Adapter) to call a script where my Java code was and execute it from the server. If you want, I can send you part of the code via message. Honestly, using Graph is terrible because you need to understand many things to use it. With CLA, if it returns the execution result, I was worried about not having feedback, but it does return it
------------------------------
Rodrigo Ricardo Pérez memije
Original Message:
Sent: Wed July 22, 2020 10:33 PM
From: Andrew Plumb
Subject: Sterling B2B Integrator authentication for SharePoint Online
Hi all,
Wondering if anyone has any experience with connecting from Sterling B2B Integrator to Office 365 SharePoint / SharePoint Online to download documents.
I believe this requires "Modern Authentication", which seems to be an implementation of OAuth2.
Can this be done with the Sterling Integrator HTTP Client Adapter ?
Regards,
Andrew.
#SupplyChain
#B2BIntegration