Working with APIs

I'm trying to create an XML output file which I can export to Microsoft Excel using an API. However I am very new to this kind of stuff and I am unaware of how to do it. I have been given this information.

• Endpoint: http://ift.tt/1tM9tNi


• Methods: GET, POST (with url-encoded data in body)


• Return data: XML, JSON (via special URL suffix: http://ift.tt/1wOo2Lj, not Accept headers due to legacy clients)

Data is provided as a series of parameters:

Parameter

1. 
   

   hours

   
   


2. 
   

   typeid

   
   


3. 
   

   minQ

   
   


4. 
   

   regionlimit

   
   


5. 
   

   usesystem

   
   

Usage

1. 
   

   Statistics for market orders with a reported time up to X hours hold. Defaults to 24.

   
   


2. 
   

   The type ID of the item you are requesting. I.e., 34 for Tritanium. Can be specified more than once. Can be specified in a comma separated list.

   
   


3. 
   

   The minimum quantity in an order to consider it for the statistics. Defaults to a heuristic scaled per type ID.

   
   


4. 
   

   Restrict statistics to a region. Can be specified more than once.

   
   


5. 
   

   Restrict statistics to a system.

   
   

Required

1. 
   

   False

   
   


2. 
   

   True

   
   


3. 
   

   False

   
   


4. 
   

   False

   
   


5. 
   

   False

   
   

More than once

1. 
   

   True

   
   


2. 
   

   True

   
   


3. 
   

   False

   
   


4. 
   

   True

   
   


5. 
   

   False

   
   

Any help on what programming language to use and how to program and output this XML file so that I can import it into a spreadsheet would be greatly appreciated.

Thank you,

Dan