Please help! Excel 2016 truncates URL of REST API call to import XML data

Dear all, I have created a number of Excelsheets that are using calls to a REST API for importing tables into the Workbook. (Through Developer Tools -> XML -> Import and then entering the URL.) I cr...