Wufoo and REST API

This post was kindly contributed by SAS from Out in Left Field - go there to comment and to read the full post.

Wufoo (http://www.wufoo.com/) is a great service for creating user forms and getting input. Build a form interactively, let people fill it out, and Wufoo collects the results. If you haven’t checked it out before, I highly recommend this great service.

I was simply parsing the emails when they were sent upon form completion but that is a real hassle due to HTML. However, Wufoo has a really good REST API so I started playing around with it. Here, in C#, is how I used their API to get my data. This can easily be converted into SAS as well:

The HttpGet:

internal static string HttpGet(string uri, string apiKey)
{
    var pairs = new StringBuilder();
    var req = WebRequest.Create(uri) as HttpWebRequest;
    req.Timeout = 300000;
    req.Credentials = new NetworkCredential(apiKey, string.Empty);
    req.UserAgent = "AlanC";
    req.ContentType = "text/html";
    req.Method = "GET";

    // Get response

    using (var response = req.GetResponse() as HttpWebResponse)
    {
        if (response != null)
        {
            WebResponse resp = req.GetResponse();
            if (resp != null)
            {
                var sr = new StreamReader(resp.GetResponseStream());
                return sr.ReadToEnd().Trim();
            }
            return null;
        }
    }
    return null;
}

The call to the method:

XDocument xd = XDocument.Parse(HttpGet(@”https://xxxxxxx.wufoo.com/api/v3/forms/xxxxx3/entries.xml”, “XXXX-XXXX-XXXX-XXXX”));

The https://xxxxx would correspond to your domain on wufoo.
The xxxxx after forms in the uri would be the form id assigned by Wufoo.
The XXX-XXXX-etc. is the API Key assigned by Wufoo.

The above can be found on the Wufoo site. Just look at the Wufoo API information to find out how to obtain it.

This post was kindly contributed by SAS from Out in Left Field - go there to comment and to read the full post.