Original Message:
Sent: Wed May 24, 2023 11:57 AM
From: Jagan Sampath
Subject: Sterling B2B Integrator authentication for SharePoint Online
Hi Andrew,
I have requirement to download a file from SharePoint through sterling integrator. if you have done this already Could you Please help share the BP if possible.
Thanks
Jagan S
------------------------------
Jagan Sampath
Original Message:
Sent: Sun March 20, 2022 10:39 PM
From: Andrew Plumb
Subject: Sterling B2B Integrator authentication for SharePoint Online
Hi Manuel,
I am trying to list the contents of a SharePoint Online (SPO) document library and then download the files from the list. When I call the API to download the file, the return is a HTTP 302 / redirect which points to our SPO site dns name ( not the graph api host ) hence requires a secondary connection. (as per your example for the PUT).
I also got the TCP reset from the SPO host for the secondary connection... and noticed the below in the Wireshark analysis of the TCP dump.
Primary Connection - protocol for the beginning of the HTTPS session shows as "TLSv1.2":
------------------------------
Regards,
Andrew Plumb
Original Message:
Sent: Thu March 17, 2022 05:13 AM
From: Manuel Frank
Subject: Sterling B2B Integrator authentication for SharePoint Online
Hi,
one addition if you use the http client adapter to upload.
Be sure to replace blanks with "%20" in folder and filename string.
Otherwise there will be a "Bad request" response from SharePoint.
Best regards
Manuel
------------------------------
Manuel Frank
Integration Architect
Andreas STIHL AG & Co. KG
Waiblingen
Original Message:
Sent: Wed March 09, 2022 01:14 AM
From: Manuel Frank
Subject: Sterling B2B Integrator authentication for SharePoint Online
Hello,
as promised some final BP code which we use to authenticate and put a file to a SPO site as the put was the hardest to implement :-)
In the put you will see a choice segment where we use either CLA with curl or HTTP adapter. This is a workaround because sometimes the MS SharePoint server sends a TCP RST immediately after the TLS Client Hello of the HTTP adapter and we have no indication why it works sometimes and sometimes not.
Feel free to ask any question.
Best regards
Manuel
Edit: Some typos...
------------------------------
Manuel Frank
Integration Architect
Andreas STIHL AG & Co. KG
Waiblingen
Original Message:
Sent: Thu February 03, 2022 07:18 AM
From: RICHARD CROSS
Subject: Sterling B2B Integrator authentication for SharePoint Online
Thank you Manuel! Very much appreciated.
Best regards,
Richard.
------------------------------
RICHARD CROSS
Original Message:
Sent: Wed February 02, 2022 08:07 AM
From: Manuel Frank
Subject: Sterling B2B Integrator authentication for SharePoint Online
Hi Richard,
as soon as I have a clean BP I can share the details.
Attached the json2xml java code which we use.
Yes, but as we are on 6.0.2 it does not support a auth bearer.
Best regards
Manuel
------------------------------
Manuel Frank
Integration Architect
Andreas STIHL AG & Co. KG
Waiblingen
Original Message:
Sent: Wed February 02, 2022 06:33 AM
From: RICHARD CROSS
Subject: Sterling B2B Integrator authentication for SharePoint Online
Hi Manuel,
Any chance you could share your BP and java code (anything secret removed of course) please? :-)
Lots of demand for this.
Have you tried with the REST Client service? https://www.ibm.com/docs/en/b2b-integrator/6.1.1?topic=SS3JSW_6.1.1/integrating/integrating/integrator/REST_Client_Adapter.html
Thanks,
Richard.
------------------------------
RICHARD CROSS
Original Message:
Sent: Wed February 02, 2022 01:45 AM
From: Manuel Frank
Subject: Sterling B2B Integrator authentication for SharePoint Online
Hi Andrew,
unfortunately basic auth is not possible, as with most "modern" APIs.
A good start is to look at MS documentation here.
First your O365 admin has to register an app and provide the client id and client secret with the permission to use the API.
In your BP call login.microsoftonline.com to get an auth bearer and use this to call graph.microsoft.com with the correct parameters to your SPO site.
Based on what you want you have to call it several times e.g. until you can download a file (get site id, get drives, get files in that drive, doownload file from drive).
As Graph works with JSON structure you have to convert the responses/requests always and also set some HTTP header with the MIME service.
Just a hint, the JSON2XML service in the BP is in our version 6.0.2 still buggy, we had to write a little java code to use inside the BP.
Let me know if you want something in more detail.
Best regards
Manuel
------------------------------
Manuel Frank
Integration Architect
Andreas STIHL AG & Co. KG
Waiblingen
Original Message:
Sent: Tue February 01, 2022 06:07 PM
From: Andrew Plumb
Subject: Sterling B2B Integrator authentication for SharePoint Online
Hi Manuel,
Thanks for the reply. Would you by any chance care to share any details about how you were able to achieve this ? (Are you using basic authentication ? )
Any help would be greatly appreciated.
------------------------------
Regards,
Andrew Plumb
Original Message:
Sent: Mon January 31, 2022 04:43 AM
From: Manuel Frank
Subject: Sterling B2B Integrator authentication for SharePoint Online
Hello,
just found this.
We are currently implementing the Graph API to exchange files with SPO.
Yes, it's possible to use the standard HTTP Client adapter.
Best regards
Manuel
------------------------------
Manuel Frank
Original Message:
Sent: Thu October 08, 2020 10:41 PM
From: Andrew Plumb
Subject: Sterling B2B Integrator authentication for SharePoint Online
Hi Srini,
Unfortunately, I have not found any solution for this so far.
Regards,
Andrew.
------------------------------
Andrew Plumb
Original Message:
Sent: Mon October 05, 2020 03:15 PM
From: Srini Parise
Subject: Sterling B2B Integrator authentication for SharePoint Online
Hi Andrew,
Have you found any solution for your issue? I have similar use case to down load files from Citrix Share File ( https://api.sharefile.com/rest/) and load them in B2B user's mail box.
Any one tried to call REST APIs with OAuth2 authentication with SI?
Thanks
Srini
------------------------------
Srini Parise
Original Message:
Sent: Sun July 26, 2020 09:19 PM
From: Andrew Plumb
Subject: Sterling B2B Integrator authentication for SharePoint Online
Thanks Rajasekhar,
Basic Authentication is not supported on the particular server I seed to connect to, so I am not able to use this.
Regards,
Andrew.
------------------------------
Andrew Plumb
Original Message:
Sent: Fri July 24, 2020 04:59 AM
From: Rajasekhar Muthamsetty
Subject: Sterling B2B Integrator authentication for SharePoint Online
Hi Andrew,
I believe OAuth is not yet supported by Sterling B2Bi.
Did you try downloading files with regular authentication either with HTTP or REST API?
------------------------------
Rajasekhar Muthamsetty
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.
Confidential communication
Westpac Banking Corporation (ABN 33 007 457 141, AFSL 233714)
Westpac Institutional Bank is a division of Westpac Banking Corporation
#B2BIntegration
#SupplyChain