title: Excel 2016 - JSON web query - extra characters at the end of JSON input
body: <p>I am trying to return some data to Excel via my web server.</p>
  
  <pre><code>Function ReturnSomeJson(id As String) As JsonResult
      Return Json(DataProvider.GetSomeData(id), JsonRequestBehavior.AllowGet)
  End Function
  </code></pre>
  
  <p>If i now go <code>New Query -&gt; From File -&gt; From JSON</code> enter the url <code>http://localhost:666/ReturnSomeJson/666</code>, it tries to open it but i get the following error message:</p>
  
  <blockquote>
    <p>Details: "We found extra characters at the end of JSON input."</p>
  </blockquote>
  
  <p>There's nothing wrong with the JSON, anyone encountered this before or have ideas to get round this in another way easily?</p>