Hello
We need to work with files larger than 1 GB, and in particular we have two scenarios:
1- A portal made in Angular, where users external to the organisation will attach a document larger than 1 GB. We need this file to reach Appian and then be sent to a sharepoint of the organisation. We have a limitation when receiving the file from the external portal as the appian api only allows 75 MB.
2- The other scenario is that a user in appian wants to attach files larger than 1GB in an appian interface with the uploadfile component, then appian through a web service must send it to sharepoint. We have the problem that the uploadfile component only allows 1GB.
For these two scenarios, what would be the optimal solution?
Discussion posts and replies are publicly visible
External Portal to Appian: Use a cloud storage service like AWS S3 or Azure Blob Storage to store files larger than 75 MB. Then, have Appian retrieve the file from the cloud storage and send it to SharePoint.Appian Interface to SharePoint: Again, use a cloud storage service for files larger than 1 GB. Users upload files to the cloud storage via Appian, and then Appian transfers the file to SharePoint through a web service.Let me know if that works for you?
"Users upload files to the cloud storage via Appian" ... how would you do that?
For scenario 1, the idea we have is as shown in the image.
We have users who are not part of the company and therefore do not have a user in the active directory and cannot connect to the client's VPN. This means that they do not have an Appian user, but we need them to agree to leave us documentation that is over 1 GB in size. For this we have thought of making a customised portal in Angular, so that these users can access from the internet to initiate the request and leave us the documentation. The communication between the angular portal and appian is done through the WSO2 api manager. The challenge is to get the documentation to Appian and then upload it to sharepoint which is the document manager used by the company, but the appian apis do not allow documents larger than 75 MB, so when they call us from the front end to send us the file, we get an error 413 payload too large.
For scenario 2, I show an image with our idea
The problem we have is that appian does not allow to attach in an interface a file bigger than 1GB, so the applications we want to develop where an appian user needs to attach these large files from an interface, are not being able to be done.
Any ideas ?
Did you take a look at this plugin which allows you to upload files up to 15GB directly into Sharepoint (bypassing Appian)?
SharePoint Direct Upload
Hello ,
This could be an option for scenario 2, let's try it.
For scenario 1 I still don't see a valid option, because the appian api limits the size of the files you receive, therefore, the file from angular to appian would never arrive.
For scenario 1, why can't you upload the files to Sharepoint via Angular and then send the Sharepoint file IDs in your Appian API request?
Mathieu Drouin said:this plugin which allows you to upload files up to 15GB directly into Sharepoint
As an aside - do you happen to know whether the linked Sharepoint tool and Connected System require Sharepoint Online like the Appian OOB version does? My company has been asking me how we'll integrate sharepoint but we don't have a compatible cloud version.
You would integrate Appian with the chosen cloud storage service's API to enable users to upload files directly from the Appian interface to the cloud storage.
Mathieu Drouin mentioned it.
This is not possible, because appian has a limit in the uploadfile component, if it is more than 1 GB, you get an error in the interface, so you cannot send from an appian interface a file bigger than 1 GB.
We currently integrate with sharepoint by making use of the REST services exposed by the sharepoint API. We do not use the connected system. In our case it is sharepoint online.