How to create large file into SharePoint library from Blob storage using HTTP connector in Logic Apps?

Question

Trying to copy files from Azure blob storage to SharePoint library. Using HTTP connector for copying files since connecting SharePoint using 'Active Directory OAuth' through App authentication.

Small files are getting created in SharePoint using below REST api call in HTTP connector. _api/web/GetFolderByServerRelativeUrl('folder__path')/Files/add(url='filename',overwrite=true)

I have enabled allow chunking in the HTTP Connector but still it get failed for creating large files (more than 50 MB) into SharePoint. Any suggestions to create large files into SharePoint library using HTTP connector (REST API) in Logic Apps?

Answer 1

Hi @Suresh Kumar Chermadurai

Per my research

The contents of the file. Pass the content parameter in the request body. The maximum size of a binary file that you can add by using the REST API is 2 GB.
You can refer to the following document
https://learn.microsoft.com/en-us/previous-versions/office/developer/sharepoint-rest-reference/dn450841(v=office.15)?redirectedfrom=MSDN#bk_FileCollectionAdd

The option 4 doesn't limit size of files.Internal testing has shown that a chunk block size of 8 MB works best, but off course this depends on the network connection you're using

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.