ACT Lab Safety Test Reports Submittal Pipeline

ACT Lab is a safety and product testing lab with offices all around the world. After each safety test, the results report must be submitted to their clients and vendors. One of their vendors is a global retailer with very specific requirements. In order to minimize user error and automate the process I have designed a specific pipeline that allows the tester to input some basic test information in an Excel spreadsheet then, on a set interval, a watchdog Python script validates and generates the submittal data in the required WSDL format and submits it through an integrated API endpoint.