Home › Discussions › Questions & Answers › SharePoint Integration: Automated Upload of Blitz Report Outputs via Custom Postprocess Script

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

Avatar photoCustomer Questions & Answers 6 replies

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?

6 replies

  • Support Enginatics

    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.

  • What is the technical setup required on the Linux server to execute the SharePoint upload?

  • Support Enginatics

    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.

  • 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 Enginatics

    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 Enginatics

    The completed report output will be processed as a standard concurrent request and automatically delivered to the SharePoint document library specified in the script.

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