niquenen commented 1 month ago

Your Environment

Platform [PC desktop, Mac, iOS, Office on the web]: Mac
Host [Excel, Word, PowerPoint, etc.]: Excel
Office version number: 16.85 (24051214)
Operating System: macOS 14.5 (23F79)
Browser (if using Office on the web): n/a

Expected behavior

Fetch text (or JSON) data and print the result with console.log.

Current behavior

When using the Fetch API, an error is thrown with the following message: "Load Failed", from a TypeError object.

Steps to reproduce

Open Excel.
Open Automate tab.
Create a new script.

Paste the following code.

async function main(workbook: ExcelScript.Workbook): Promise<void>
{
   try {
       await fetch('https://google.com');
   }
   catch (error) {
       console.log(error);
   }
}

Another example:

async function main(workbook: ExcelScript.Workbook): Promise<void>
{
    try {
        // TypeError
        await fetch('https://example.com');
    }
    catch (error) {
        console.log(error);
    }
    try {
        // TypeError
        await fetch('https://google.com');
    }
    catch (error) {
        console.log(error);
    }
    try {
        // TypeError
        await fetch('https://github.com');
    }
    catch (error) {
        console.log(error);
    }
    try {
        await fetch('https://api.github.com');
    }
    catch (error) {
        console.log(error);
    }
}