Home › Discussions › Questions & Answers › Integration with SharePoint: Automating Blitz Report Output Delivery from EBS Linux Server

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

Avatar photoCustomer Questions & Answers 7 replies

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?

7 replies

  • Support Enginatics

    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.

  • Avatar photoCustomer

    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 Enginatics

    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.

  • Avatar photoCustomer

    How is the critical authentication managed? Do we need to embed administrator credentials in the script, posing a security risk?

  • Support Enginatics

    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.

  • Avatar photoCustomer

    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 Enginatics

    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.

  • You must be logged in to reply to this post.