712
Views
20
Comments
Solved
[FileSystem] Uploading and download documents on sharepoint
Question
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

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


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.


Rank: #19723

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.

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.

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-

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

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-

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

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



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


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




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!

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


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/



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

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. 

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. 


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


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.


Rank: #19723

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.

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.

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

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.

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)