Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to upload a file on microsoft sharepoint online

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...

0683p000009MZu3.png

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

0683p000009Ma64.png
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

Labels (4)
10 Replies
chnet1
Contributor
Contributor

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

 

Many Thanks in advance!

 

Christian