I need to make 1000+ calls to the following web service and download the XML output that results from each call - http://comtrade.un.org/ws/
I am fairly new to web services, so please bear with me.
I wrote some C# code with which I can call the web service - see attached.
Now, I need to call the web service with a couple of parameters - http://comtrade.un.org/ws/get.aspx?cc=TOTAL&px=S3&r=372&y=2006&p=4,%208,%2024&rg=1,2&so=9999
I will need to loop through various values for "cc" and "r".
The web service returns a XML file which I plan to import into Excel.
Can someone please help me with the code that will help me download the files?
static void Main(string args)
// Create the web request
= WebRequest.Create("http://comtrade.un.org/ws/") as HttpWebRequest;
request.Proxy = WebProxy.GetDefaultProxy();
// Get response
using (HttpWebResponse response = request.GetResponse() as HttpWebResponse)
// Get the response stream
StreamReader reader = new StreamReader(response.GetResponseStream());
// Read it into a StringBuilder
sbSource = new StringBuilder(reader.ReadToEnd());
// Console application output