javascript - How do I Make Google Apps Script serve XML to IE 11?

Question

I have a google app script attached to a spreadsheet. It's deployed as a web app. When accessed, it returns XML.

function doGet()
{
  var xml = createXML_(getSheetData_())
  Logger.log("
" + xml);
  xml = ContentService.createTextOutput(xml);
  xml.setMimeType(ContentService.MimeType.XML);
  return xml;
}

I have javascript in a webpage that retrieves the XML from this, with a GET request, using XMLHttpRequest() like normal. It then traverses the XML and builds a table from the data.

In Chrome and Firefox, this all works perfectly. However, in IE11, it doesn't work.

Upon further examination (in IE's inspect thing), the XML being returned to IE is:

<Permission Denied>

and that's it.

How do I make my google app script return the XML when requested by Internet Explorer?

question from:https://stackoverflow.com/questions/65932204/how-do-i-make-google-apps-script-serve-xml-to-ie-11

Answer 1

If you mean that Google app script that is deployed as a web app on another domain and your web page is hosted on another domain from where you are trying to retrieve the XML using JS then it can be possible that IE is preventing you from accessing the resources across different domains.

I suggest you try to go to the Internet options-> Security tab-> Select the desired zone-> Custom level then enabled the Access data sources across domains option under the Miscellaneous category.

Restart the machine and again try to check for the issue.

If the issue still persists then I suggest you try to provide detailed steps with the sample code to reproduce the issue and also try to share the snapshot of the error may help to understand the issue in a better way.

Thanks for your understanding.