class theUrls {
  String ntseUrl;
  String publicApi;
}

class theUrls {
  String ntseUrl;
  String publicApi;
}

theUrls:
  system: INTERESTS
       ntseUrl: some-INTERESTS-website.dev.com
       publicApi: some-INTERESTS-api.dev.com
       ...
  system: INVEST
       ntseUrl: some-INVEST-website.dev.com
       publicApi: some-INVEST-api.dev.com
       ...

theUrls:
  system: INTERESTS
       ntseUrl: some-INTERESTS-website.dev.com
       publicApi: some-INTERESTS-api.dev.com
       ...
  system: INVEST
       ntseUrl: some-INVEST-website.dev.com
       publicApi: some-INVEST-api.dev.com
       ...

theUrls:
     ntseUrl: some-INTERESTS-website.dev.com
     publicApi: some-INTERESTS-api.dev.com
     ...

theUrls:
     ntseUrl: some-INTERESTS-website.dev.com
     publicApi: some-INTERESTS-api.dev.com
     ...

@Grab(group='org.codehaus.groovy.modules.http-builder', module='http-builder', version='0.7.1')
@Grab(group='org.apache.poi', module='poi-ooxml', version='5.0.0')

import groovyx.net.http.RESTClient
import org.apache.poi.ss.usermodel.Workbook
import org.apache.poi.ss.usermodel.WorkbookFactory

import java.io.ByteArrayInputStream

// Import Selenium dependencies
import org.openqa.selenium.By
import org.openqa.selenium.WebDriver
import org.openqa.selenium.chrome.ChromeDriver

// Set the path to the chromedriver executable
System.setProperty("webdriver.chrome.driver", "/path/to/chromedriver")

// Initialize Selenium WebDriver
WebDriver driver = new ChromeDriver()

try {
    // Navigate to the web page
    driver.get("http://your-internal-tool-url")

    // Find the download link element
    WebElement downloadLink = driver.findElement(By.id("your-download-link-id"))

    // Get the URL of the download link
    String fileURL = downloadLink.getAttribute("href")

    // Initialize HTTPBuilder with the file URL
    def client = new RESTClient(fileURL)

    // Perform a GET request to download the file
    def response = client.get([:])

    // Check if the response status is OK (HTTP 200)
    if (response.status == 200) {
        // Extract the bytes from the response data
        byte[] fileBytes = response.data.bytes

        // Use Apache POI to verify the file
        try (ByteArrayInputStream bais = new ByteArrayInputStream(fileBytes)) {
            // Create a Workbook from the byte array input stream
            Workbook workbook = WorkbookFactory.create(bais)
            println("The downloaded file is a valid Excel file.")
        } catch (Exception e) {
            println("The downloaded file is not a valid Excel file.")
        }
    } else {
      //...
    }
} catch (Exception e) {
   //...
} finally {
    //...
}

@Grab(group='org.codehaus.groovy.modules.http-builder', module='http-builder', version='0.7.1')
@Grab(group='org.apache.poi', module='poi-ooxml', version='5.0.0')

import groovyx.net.http.RESTClient
import org.apache.poi.ss.usermodel.Workbook
import org.apache.poi.ss.usermodel.WorkbookFactory

import java.io.ByteArrayInputStream

// Import Selenium dependencies
import org.openqa.selenium.By
import org.openqa.selenium.WebDriver
import org.openqa.selenium.chrome.ChromeDriver

// Set the path to the chromedriver executable
System.setProperty("webdriver.chrome.driver", "/path/to/chromedriver")

// Initialize Selenium WebDriver
WebDriver driver = new ChromeDriver()

try {
    // Navigate to the web page
    driver.get("http://your-internal-tool-url")

    // Find the download link element
    WebElement downloadLink = driver.findElement(By.id("your-download-link-id"))

    // Get the URL of the download link
    String fileURL = downloadLink.getAttribute("href")

    // Initialize HTTPBuilder with the file URL
    def client = new RESTClient(fileURL)

    // Perform a GET request to download the file
    def response = client.get([:])

    // Check if the response status is OK (HTTP 200)
    if (response.status == 200) {
        // Extract the bytes from the response data
        byte[] fileBytes = response.data.bytes

        // Use Apache POI to verify the file
        try (ByteArrayInputStream bais = new ByteArrayInputStream(fileBytes)) {
            // Create a Workbook from the byte array input stream
            Workbook workbook = WorkbookFactory.create(bais)
            println("The downloaded file is a valid Excel file.")
        } catch (Exception e) {
            println("The downloaded file is not a valid Excel file.")
        }
    } else {
      //...
    }
} catch (Exception e) {
   //...
} finally {
    //...
}