title: Use C# to create a windows service to parse JSON data and insert it into SQL table
body: <p>I am a noobie in <code>JSON</code>.  In my research I can see the value of using <code>JSON</code> versus other api methods but I am having a unique situational issue.  </p>
  
  <p>However, my issue lies in trying to parse the <code>JSON</code> data.  I have tried three different methods in <code>C#</code> to parse the data via a URL and keep getting various errors.  My most recent method I believe will get me exactly what I am looking for but now I am getting a general error when I try to execute the code.  </p>
  
  <pre><code>static void Main(string[] args)
  {
      ExecuteRiskSearch();
      Console.ReadLine();
  }
  
  static void ExecuteRiskSearch()
  {
      string url = "https://localhost/api/getWatchList/EDD9-5FFA-2A6A-3CB9ZCC";
  
      JObject results = JObject.Parse(url);
  
      foreach (var result in results["results"])
      {
          string cid = (string)results["CID"];
          JToken rank = results["rank"];
  
          string risk = "";
          if (rank is JValue)
          {
              risk = (string)rank;
          }
          else if (rank is JArray)
          {
              risk = (string)((JArray)rank).First;
          }
  
          Console.WriteLine("CID: {0}, Rank:{1}", cid, risk);
      }
  }
  </code></pre>
  
  <p>The error occurs on <code>JObject results = JObject.Parse(url);</code>  </p>
  
  <blockquote>
    <p>An unhandled exception of type 'Newtonsoft.Json.JsonReaderException' occurred in Newtonsoft.Json.dll
    Additional information: Unexpected character encountered while parsing value: h. Path '', line 0, position 0.</p>
  </blockquote>
  
  <p>Can you please indicate why this would be happening?  Am I way off base on this?  </p>