SSDT - FOR JSON AUTO -- Link is broken

• JSR_SDCA

  SSC-Addicted

  Points: 445

  More actions

  March 31, 2017 at 12:26 am

  #322586

  So, per the suggestion of many articles, I am using SSDT (2017 and 2015 both) to query a 2016 database, and I'm using FOR JSON AUTO.

  The query returns successfully, and the JSON data shows up as a hyperlinked single column.  When I click the link, however, nothing happens.  I am not able to view the JSON data at all, and even copying the value of the cell gives me a truncated string.  So, I am totally unable to use the JSON output.

  If I change FOR JSON AUTO to FOR XML AUTO, clicking the resulting hyperlink opens a new XML window as expected.

  I get this same behavior on both VS 2017 and VS 2015.

  Any help would be greatly appreciated.

  Thanks!

  P.S.  Clicking the link does work in SSMS (but curiously opens the JSON as an XML file), but of course there I don't have CTRL-K + CTRL-D for formatting and color coding, which is why SSDT is the preferred solution.

• JSR_SDCA

  SSC-Addicted

  Points: 445

  More actions

  April 3, 2017 at 12:53 pm

  #1936404

  Found the reason.  Hope they address this soon...

  https://social.msdn.microsoft.com/Forums/Windows/en-US/3e89dfb5-b2d7-45a5-b2f8-1e8527498118/error-for-json-path-fails-when-parsing-an-ampersand-?forum=sqltools