Integration with SharePoint: Automating Blitz Report Output Delivery from EBS Linux Server

Customer December 6, 2025 at 2:42 pm

We need to modernize our report delivery process by automatically moving daily and weekly EBS Concurrent Request outputs, often generated as large Excel files, directly from our Linux application server into a designated folder on SharePoint Online. Traditional email distribution methods fail due to file size limits, and manual file transfer is tedious. Is there an authenticated, automated solution that utilizes EBS background processes, such as a Custom Postprocess script, to handle this Integration with SharePoint securely and reliably, ensuring timely access for our remote business teams?

Viewing 6 reply threads

Author
Replies
- Support December 6, 2025 at 6:25 pm
  This integration is seamlessly achievable using the Blitz Report framework’s highly flexible Custom Postprocess feature. This functionality allows you to execute external scripts immediately upon report completion, enabling complex tasks like authenticated file transfer from the Linux server to SharePoint Online.
- Customer December 6, 2025 at 8:29 pm
  What technical prerequisites are needed on the Linux EBS server side to facilitate communication with the Microsoft SharePoint environment, given that it requires modern authentication protocols?
- Support December 6, 2025 at 11:00 pm
  The recommended approach involves utilizing a modern programming language, such as Python, along with necessary libraries like `requests` and `msal`. Python needs to be installed and configured on your Linux server, allowing the execution of specialized scripts that handle the authentication tokens required by SharePoint Online for secure upload.
- Customer December 7, 2025 at 4:55 am
  How is the critical authentication managed? Do we need to embed administrator credentials in the script, posing a security risk?
- Support December 7, 2025 at 8:41 am
  For secure connectivity, you establish an App Registration in Azure Active Directory, generating specific Client IDs and Secrets. These are referenced within the Python script to authenticate the file transfer, avoiding the need to use direct, sensitive user credentials for the SharePoint integration.
- Customer December 7, 2025 at 10:46 am
  Can this custom script reliably handle large files generated by Blitz Report, and is the process of linking the report output file to the Python script straightforward?
- Support December 7, 2025 at 12:54 pm
  Yes, the custom postprocess script automatically accesses the final output file path using environment variables set by the concurrent manager, such as `outfile_name` and `output_filename`. Since Blitz Report handles high-volume data efficiently, the script can transfer those large files securely, bypassing the limitations of traditional email attachment sizes.
Author
Replies

Viewing 6 reply threads

You must be logged in to reply to this post.