Capture.PNG

Systems Engineer

Alex Jaya

<div>
Thank you, that worked, however, it exported all results into a single line json. &nbsp;Is there a way to export it with each field in it's own line?
</div>


Thank you, that worked, however, it exported all results into a single line json.  Is there a way to export it with each field in it's own line?

<div>
No, cause pretty print is for data representation not necessary, thus it is not done by FOR JSON. <br />
<br />
When you want that, then you need to use a separate tool for that.
</div>


No, cause pretty print is for data representation not necessary, thus it is not done by FOR JSON.

When you want that, then you need to use a separate tool for that.

<div>
<div class="content wysiwyg-content fr-view">
<p>I'm running a SQL query and using the FOR JSON PATH clause with child arrays. &nbsp;The results show up fine when viewing the results to grid but I need a way to export it to an actual json file. &nbsp;<br>I've read up on BCP but I can't seem to get it working mostly because I don't know how to use it. &nbsp;I need to be able to use this as an automated scheduled job, preferably as a SQL job. &nbsp;<br>Does anyone have any suggestions?</p>
</div>
</div>



I'm running a SQL query and using the FOR JSON PATH clause with child arrays.  The results show up fine when viewing the results to grid but I need a way to export it to an actual json file.  
I've read up on BCP but I can't seem to get it working mostly because I don't know how to use it.  I need to be able to use this as an automated scheduled job, preferably as a SQL job.  
Does anyone have any suggestions?

Export FOR JSON clause to an actual JSON File

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

JavaScript Object Notation, or JSON, is human-readable text used when transmitting data objects consisting of attribute:value pairs between a server and a web application as an alternative to XML. JSON, while it is originally derived from JavaScript, is a language-independent data format. Code for parsing and generating JSON data is available in many programming languages.

JSON

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.