Patson Davison Jumbi
Rank: #4234
712Views
20Comments
Solved
[FileSystem] Uploading and download documents on sharepoint
Question
Forge
FileSystem
Forge component by João Portela
33
Published on 21 Feb 2019

Good day 

I wanted to ask for help, is it possible to upload and download documents online (sharepoint)?

If so how can i do this?


Thank you

0
0
on 2018-05-09
Copy link to comment
Chris Johnson
Rank: #786
Solution

Please read my article here first:  https://kolaberate.com/Articles/2018/08/22/integrating-sharepoint-with-outsystems/


It should help you get everything setup correctly.  Make sure to modify the outsystems project with your clientid and clientsecret.


Chris

Kolaberate.com


See solution in context
0
0
on 2019-08-22
Copy link to comment
Alex Lima
Rank: #3934

Chris Johnson wrote:

Please read my article here first:  https://kolaberate.com/Articles/2018/08/22/integrating-sharepoint-with-outsystems/


It should help you get everything setup correctly.  Make sure to modify the outsystems project with your clientid and clientsecret.


Chris

Kolaberate.com


I´m using your article already. I´m having problems trying to get the TenantId from 

OutsystemsSharepointGetTenantId

One thing I did not understand was: How get this TenantId just calling the webservice: https://<MySite>.sharepoint.com/_vti_bin/client.svc/ since I did not pass anything to it.


1
0
on 2019-08-22
Copy link to comment
Andy Yan
Rank: #19723

Replying to Alex Lima's comment on 22 Aug 2019 19:56:15

Hi Alex. I got stuck in the issue like you. May I ask if you have resolved it? to be honest, Chris's article didn't specify on this bit. Thanks.

0
0
on 2020-11-24
Copy link to comment
Andy Yan
Rank: #19723

Hi Chris, I did read your article. a good one. But like Alex, I got stuck in the get tenant ID step. I assume that we would need to make use of the Client ID and secret generated in previous steps in the URL, wouldn't we? But in your article, there is no sign of the appId or secret when calling the REST API. Mind specifying more on this? Thanks heap.

0
0
on 2020-11-24
Copy link to comment
Pramod Jain
mvp_badge
MVP
Rank: #50

HI Patson,

Can you make your question more clear , what do you mean by upload\download docs from sharepoint?

If i am correct , you have an Outsystems application which you want to integrate with Sharepoint ?



Regards

-PJ-

0
0
on 2018-05-09
Copy link to comment

I have and outsystems application and i want to upload documents using that the application but share them on SharePoint 

0
0
on 2018-05-09
Copy link to comment
Pramod Jain
mvp_badge
MVP
Rank: #50

Hi Patson,

Check this forge component sharepoint-integration-made-easy  this may help you to achieve what you want.


Regards

-PJ-

0
0
on 2018-05-09
Copy link to comment

Thank you i will try it out then i will update you

0
0
on 2018-05-09
Copy link to comment
Poovalagan J
Rank: #24599

Patson Jumbi wrote: Dear Patson,


Are you able to achieve it with the "sharepoint-integration-made-easy" component. ? . It seems the component was deprecated to the latest versions.


Kindly share your input will be more helpful.

Thank you i will try it out then i will update you



0
0
on 2018-06-06
Copy link to comment

Poovalagan J wrote:

Patson Jumbi wrote: Dear Patson,


Are you able to achieve it with the "sharepoint-integration-made-easy" component. ? . It seems the component was deprecated to the latest versions.


Kindly share your input will be more helpful.

Thank you i will try it out then i will update you



No it didn't work for what i wanted to use it for


0
0
on 2018-06-06
Copy link to comment
Poovalagan J
Rank: #24599

Patson Jumbi wrote: Even i am unable to achieve it. Requested for the further help from OutSystems support team. awaiting for the solution. 

Poovalagan J wrote:

Patson Jumbi wrote: Dear Patson,


Are you able to achieve it with the "sharepoint-integration-made-easy" component. ? . It seems the component was deprecated to the latest versions.


Kindly share your input will be more helpful.

Thank you i will try it out then i will update you



No it didn't work for what i wanted to use it for




0
0
on 2018-06-06
Copy link to comment
Chris Johnson
Rank: #786

Hi all.  Where can i get the latest sharepoint connector for Outsystems?  I want to achieve the same thing, (Basically upload and download documents to sharepoint.)  thank you!

1
0
on 2018-06-20
Copy link to comment
Chris Johnson
Rank: #786

Just to let you all know that I created a sharepoint connector project.  It's in the forge at:  https://www.outsystems.com/forge/Component_Details.aspx?ProjectId=4114

This will show you exactly how to connect to SharePoint via Your OutSystems application.


Chris


2
0
on 2018-08-22
Copy link to comment
Chris Johnson
Rank: #786

Here is the article on how to connect to SharePoint via your OutSystems application:  https://intrinsicinnovation.com/Articles/2018/08/22/integrating-sharepoint-with-outsystems/



1
0
on 2018-08-22
Copy link to comment
Paul Schmeddes
mvp_badge
MVP
Rank: #211

Chris Johnson wrote:

Here is the article on how to connect to SharePoint via your OutSystems application:  http://intrinsicinnovation.com/Articles/2018/08/22/integrating-sharepoint-with-outsystems/



 

 This link is not working anymore

0
0
on 2020-08-19
Copy link to comment

Good day Chris


i keep on getting 403 error, i am not sure is it the permissions from sharepoint or from outsystems, if possible will you be able to assist to resolve this? I'm trying to call a sharepoint rest service using the credentials of the active user in the application. But I keep getting a 401 when using the IntegratedAuthentication action in the OnBeforeRequestAdvanced. 

0
0
on 2018-11-16
Copy link to comment
Alex Lima
Rank: #3934

Hi Chris.


I´ve just get the ClientId and ClientSecret and gave the permissions. But when I try do use the very first REST

OutsystemsSharepointGetTenantId

I get the "401 Unauthorized" error. 


0
0
on 2019-08-22
Copy link to comment
Chris Johnson
Rank: #786
Solution

Please read my article here first:  https://kolaberate.com/Articles/2018/08/22/integrating-sharepoint-with-outsystems/


It should help you get everything setup correctly.  Make sure to modify the outsystems project with your clientid and clientsecret.


Chris

Kolaberate.com


0
0
on 2019-08-22
Copy link to comment
Alex Lima
Rank: #3934

Chris Johnson wrote:

Please read my article here first:  https://kolaberate.com/Articles/2018/08/22/integrating-sharepoint-with-outsystems/


It should help you get everything setup correctly.  Make sure to modify the outsystems project with your clientid and clientsecret.


Chris

Kolaberate.com


I´m using your article already. I´m having problems trying to get the TenantId from 

OutsystemsSharepointGetTenantId

One thing I did not understand was: How get this TenantId just calling the webservice: https://<MySite>.sharepoint.com/_vti_bin/client.svc/ since I did not pass anything to it.


1
0
on 2019-08-22
Copy link to comment
Andy Yan
Rank: #19723

Replying to Alex Lima's comment on 22 Aug 2019 19:56:15

Hi Alex. I got stuck in the issue like you. May I ask if you have resolved it? to be honest, Chris's article didn't specify on this bit. Thanks.

0
0
on 2020-11-24
Copy link to comment
Andy Yan
Rank: #19723

Hi Chris, I did read your article. a good one. But like Alex, I got stuck in the get tenant ID step. I assume that we would need to make use of the Client ID and secret generated in previous steps in the URL, wouldn't we? But in your article, there is no sign of the appId or secret when calling the REST API. Mind specifying more on this? Thanks heap.

0
0
on 2020-11-24
Copy link to comment
Marvei Paña
Rank: #472

Hi alex lima, you can get the tenant ID by using the get response of https://<MySite>.sharepoint.com/_vti_bin/client.svc/ you just need to find where to get it,


Cheers...

0
0
on 2019-10-04
Copy link to comment
Andy Yan
Rank: #19723

Hi Marvei,


hope all is well. May I ask for your help to specify more re your comment back to Alex?

I was actually stuck in the same issue here. By following the instruction in Chris's article, he said by using the appId and Secret from that registered Add-in we can fetch back the tenant ID. However, in that step, he didn't specify how to make use of them along with the URL.

Thanks in advance.

0
0
on 2020-11-24
Copy link to comment
Ben J
Rank: #84549

I have a UNC path for SharePoint 2013. When I try to read an excel file using File_ReadBinary I get the below error. The UNC path looks like this 

\\abc.def.gh.ij\sites\corp\abc\ABC REports\AB0001_-_Active_Work_Order_Backlog.xlsx\

Win32Error: 53
System.IO.IOException: The network path was not found.

   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
   at System.IO.File.Open(String path, FileMode mode, FileAccess access, FileShare share)
   at OutSystems.NssFileSystem.CssFileSystem.MssFile_ReadBinary(String ssPath, Byte[]& ssContent, String ssDomain, String ssUsername, String ssPassword, String& ssError_message)

0
0
on 2019-11-07
Copy link to comment