ASP classic page that will consume API or Webservice data in XML or Json

Develop ASP classic page that will consume API or Webservice data in XML or Json. Description: build client (consumer of API/Webservice) in classic ASP that retrieves data in XML or Json, either one is acceptible (you choose. Better both options!). The data is in ".XLS like" format that will be supplied by the server in either format you choose: XML or Json. You can suggest a server side code, but this project just needs the client side (consumer of server data). The data specs are not defined yet (number of columns, types, etc), so a generic solution is acceptible. The server API/Webservice must be user/password protected, and so the URL of the resource must have these credentials in it (or you can suggest your way for this security layer). In resume: - Develop a classic ASP client that consumes data from a URL (API or Webservice); - Data in XML or Json (you choose. Better both); - User/Password protected.