Forum Discussion
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 created these workbooks in Excel 2010 and they continue to update fine when I click "Refresh data" or "Refresh all" in Excel 2010 - but in Excel 2016 the URL gets truncated which leads to an error message and the data not getting updated.
I would be extremely grateful for any pointers as to how this can be resolved.
Thank you very much in advance for any help you may be able to provide.
All the best,
Stefan
6 Replies
- JKPieterseSilver ContributorCan you perhaps post the URL?
- Anonymous
Hi Jan-Karel, Thanks for replying! Would love to - but it includes our company's account details (Account and API Keys) for our Customer Relationship Management system. Will see if I can find any public API call to simulate the same behaviour. But as far as I can tell, the URL always gets cut off at 115 characters. So I'm hoping for some registry key to fix this. Would you have any ideas where to start looking for this?
- JKPieterseSilver Contributor
I'm afraid not, I googled using a couple of keywords but was unable to find something. Have you tried copying the original URL and adding a new connection from 2016?