Problem Debugging Microsoft Office Script in Excel

Here is the code (it wasn't letting me post it with the main message):

Please Login or Register  to view this content.

Also, I just read the agreement terms of this website. I had posted an identical question on MrExcel but no one answered.

I hope to have better luck here...

Thanks for the suggestion mogul. Unfortunately, the same problem exists after changing the name of the variable "response" to "resp".

I looked at your code and did a little research.

const response = await fetch(sheet.getRange("I7"));

should be

const response = await fetch(sheet.getRange('I7').getText());


I would break it up. Log url to make sure it is right.

const url = sheet.getRange('I7').getText();
console.log(url);
const response = await fetch(url);

That worked!

Thank you very much mogul for your help.

Welcome. Might want to mark it as solved.