SharePoint Integration: Automated Upload of Blitz Report Outputs via Custom Postprocess Script

Customer October 7, 2025 at 12:57 pm

We need to distribute large volumes of data extracted using Blitz Report, but the size limitations on email attachments restrict our concurrent request output delivery methods. Our organization uses SharePoint Online for document management. Is there a solution, perhaps utilizing the powerful Blitz Report postprocessing feature, that allows us to automatically send Blitz Report Excel outputs from our Linux EBS server directly to a specified SharePoint document library, enabling seamless file sharing and archive?

Viewing 5 reply threads

Author
Replies
- Support October 7, 2025 at 4:42 pm
  This is a key capability designed in response to customer feedback regarding email size limits. Blitz Report’s flexible Custom Postprocess feature allows users to execute external actions on output files, enabling seamless SharePoint Integration.
- Customer October 7, 2025 at 7:56 pm
  What is the technical setup required on the Linux server to execute the SharePoint upload?
- Support October 7, 2025 at 11:02 pm
  The recommended approach utilizes a Python script, leveraging libraries like `requests` and `msal` for authentication with Azure Active Directory and SharePoint Online. After setting up Python 3 and registering an app in Azure AD to acquire necessary API permissions (Files.ReadWrite.All, Sites.ReadWrite.All), the Python script handles the file upload.
- Customer October 8, 2025 at 3:24 am
  How do we ensure the script runs automatically after the Blitz Report generates the Excel file, and that the script correctly identifies the file path and name?
- Support October 8, 2025 at 7:55 am
  You must define the Python script name (e.g., `upload_to_sharepoint.py`) in the Custom Postprocess option field when running the report. Within that Python script, ensure you use the environment variables `os.environ[“outfile_name”]` and `os.environ[“output_filename”]` to dynamically fetch the location and name of the generated Blitz Report output.
- Support October 8, 2025 at 11:23 am
  The completed report output will be processed as a standard concurrent request and automatically delivered to the SharePoint document library specified in the script.
Author
Replies

Viewing 5 reply threads

You must be logged in to reply to this post.