Excel 2016 - JSON web query - extra characters at the end of JSON input
<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>