You can transfer data with JSON in SQL Server. Based on an SQL query, you can output the results into JSON format. Here is a small example:

DECLARE @JSONOutput NVARCHAR(MAX) =   (SELECT  * FROM Students FOR JSON auto, INCLUDE_NULL_VALUES)Print @JSONOutput;This could potentially give the following result:[   {      "StudentID":1,      "StudentName":"Hannes",      "EnrolDate":"2017-12-14T14:19:22.273"   },   {      "StudentID":2,      "StudentName":"Elmarie",      "EnrolDate":"2017-12-13T13:19:22.273"   },   {      "StudentID":3,      "StudentName":"Kayla",      "EnrolDate":"2017-12-15T15:19:22.273"   }]