topic Re: How to upload a file on microsoft sharepoint online in Talend Studio

How to upload a file on microsoft sharepoint online

Anonymous — Thu, 28 May 2020 11:10:20 GMT

Hello,

Just to share my experience to upload a file to sharepoint online.

To connect to sharepoint, you need to realize a sequence of REST call. A little schema below to explain...

The call fails because during the redirection process the tRESTClient receive some cookie but the component don't set the cookie for the next call, thus impossible to finish the step 3.

Finally, I find a solution, see below

I explain a little :
tRESTClient (callMicrosoft) : We check "Convert response to DOM document" to use tXMLMap.
tRESTClient (callSiteButRedirect) : The tRESTClient don't update cookie in the process of redirect. Thus, we made the process of redirect manually. We uncheck "Die on Error" to retrieve HTTP Headers.
tJavaRow (extractCookies) : We extract the two cookies to reuse after.
tRESTClient (callSiteAfterRedirect) : We check "Follow redirects" and "Allow non-same host redirects".
tRESTClient (callForDigest) : We check "Convert response to DOM document" to use tXMLMap.
tFileFetch (loadFile) : We use all the info before and upload the file.

And it's good for me.

Enjoy

Dimitri

Re: How to upload a file on microsoft sharepoint online

Anonymous — Thu, 28 May 2020 11:11:16 GMT

It's ok

Re: How to upload a file on microsoft sharepoint online

manodwhb — Thu, 28 May 2020 12:46:27 GMT

@dherla ,please share the solution,so that it would be helpful to others.

Re: How to upload a file on microsoft sharepoint online

Anonymous — Thu, 28 May 2020 13:31:44 GMT

The first post is the solution...

Re: How to upload a file on microsoft sharepoint online

Jeff4 — Tue, 09 Jun 2020 13:37:33 GMT

Hi,

Thanks a lot for this trick ! I managed to make it work with postman but i didn't think about the redirect management with talend.

Could you upload en example of your job ? It will be interessing to see how you manage the building of input for tRESTCLIENT.

Re: How to upload a file on microsoft sharepoint online

Anonymous — Wed, 10 Jun 2020 06:10:14 GMT

Hello,

I don't understand your question. I make nothing special to create the input of tRESTClient.

But if you need more help for one step just ask.

Regards

Dimitri

Re: How to upload a file on microsoft sharepoint online

jay_t0 — Tue, 29 Sep 2020 17:39:17 GMT

Hi Dimitri,

Thank you for sharing details on SAML authentication. I am working on a new assignment where i have download/extract data from sharepointonline list.

Is it possible to share screenshots/details of each component? tRESTClient has lot of different options and it will help if you share what worked for you.

Re: How to upload a file on microsoft sharepoint online

AIjel — Sun, 08 Nov 2020 16:58:02 GMT

Hi,

it would be very useful if you share screenshots of your jobs, as you see from previous message, lots of people are fighting with sharepoint online authentification.

thanks

Re: How to upload a file on microsoft sharepoint online

ccat1604932141 — Thu, 17 Dec 2020 09:16:11 GMT

Hello, thanks for the post.

I am not very good at java, is it possible to have an example of tjavarow to retrieve cookies?

Thanks

Re: How to upload a file on microsoft sharepoint online

sidd — Fri, 09 Jul 2021 15:26:21 GMT

Dherla - I am working on the same request. is it possible to export the job you created and share it with us?

Re: How to upload a file on microsoft sharepoint online

chnet1 — Mon, 25 Oct 2021 04:18:02 GMT

Hi guys - has anyone of you build this solution is able to export and share the job here?

Many Thanks in advance!

Christian