Hello
Is there a way that switch can connect and upload artwork to an windows Sharepoint?
Regards Ben
Is there a way that switch can connect and upload artwork to an windows Sharepoint?
-
magnussandstrom
- Advanced member
- Posts: 510
- Joined: Thu Jul 30, 2020 6:34 pm
- Location: Sweden
- Contact:
Re: Is there a way that switch can connect and upload artwork to an windows Sharepoint?
Hi! We have flows in place to handle this, but it's not a completely straightforward solution.
At first glance, it might seem like you could simply use Microsoft's SharePoint REST API and be done. However, the SharePoint REST API has a file size limit of around 20 MB, and many of our files exceed that limit.
Here’s how we’ve addressed it:
File Upload to Azure Blob Storage
• Files are first uploaded to an Azure Blob Storage container using an HTTP request from Switch.
• Switch then sends an HTTP request to an Azure Logic App (Triggering the Logic App). This request includes the path to the file in Azure Blob Storage and the target destination in SharePoint.
Logic App Processing:
The Logic App retrieves the file from Blob Storage and uploads it to SharePoint (via the SharePoint connector).
This approach works well for files up to approximately 400 MB.
However, since Azure Logic Apps have a memory limit around 400 MB, processing larger files will cause failures. To work around this, we implemented chunked processing: When files exceed the 400 MB threshold, the Logic App calls an Azure Function we built.
This function uses the SharePoint Graph API, which supports chunked uploads.
It reads the file in parts from Blob Storage, uploads the chunks to SharePoint, and assembles them there. This solution has proven effective for handling larger files.
In retrospect we should rather hire a Switch app-builder to build a SharePoint Switch app that is utilizing the SharePoint Graph API with chunking embedded. This would exclude the extra complexity involving Azure blob storage and Azure Logic Apps. But you work with what you have I guess.
We also built flows to do the opposite, sending files from Sharepoint to Switch, but thats another story.
At first glance, it might seem like you could simply use Microsoft's SharePoint REST API and be done. However, the SharePoint REST API has a file size limit of around 20 MB, and many of our files exceed that limit.
Here’s how we’ve addressed it:
File Upload to Azure Blob Storage
• Files are first uploaded to an Azure Blob Storage container using an HTTP request from Switch.
• Switch then sends an HTTP request to an Azure Logic App (Triggering the Logic App). This request includes the path to the file in Azure Blob Storage and the target destination in SharePoint.
Logic App Processing:
The Logic App retrieves the file from Blob Storage and uploads it to SharePoint (via the SharePoint connector).
This approach works well for files up to approximately 400 MB.
However, since Azure Logic Apps have a memory limit around 400 MB, processing larger files will cause failures. To work around this, we implemented chunked processing: When files exceed the 400 MB threshold, the Logic App calls an Azure Function we built.
This function uses the SharePoint Graph API, which supports chunked uploads.
It reads the file in parts from Blob Storage, uploads the chunks to SharePoint, and assembles them there. This solution has proven effective for handling larger files.
In retrospect we should rather hire a Switch app-builder to build a SharePoint Switch app that is utilizing the SharePoint Graph API with chunking embedded. This would exclude the extra complexity involving Azure blob storage and Azure Logic Apps. But you work with what you have I guess.
We also built flows to do the opposite, sending files from Sharepoint to Switch, but thats another story.
-
magnussandstrom
- Advanced member
- Posts: 510
- Joined: Thu Jul 30, 2020 6:34 pm
- Location: Sweden
- Contact:
Re: Is there a way that switch can connect and upload artwork to an windows Sharepoint?
I have sent several ideas to "Enfocus App Match" regarding a SharePoint app for Switch, but it's still to be invented I guess.