I'm trying to take a SQL query and turn it into JSON for an API call. I have two groupings that need to contain an opening and closing bracket [] because they can contain multiple rows. Those are shown here…
I've got a table in my database that contains a bunch of JSON paths and the values at those paths. I want to take the data in that table and construct a JSON object out of it. I'm more of…
This is my query: SELECT a.Id, a.Title, (SELECT m.Id, m.Name, m.MobileNo FROM [msm].[MsmMember] AS m WHERE m.Id = a.MemberId AND m.OrganizationId = @OrganizationId FOR JSON PATH, WITHOUT_ARRAY_WRAPPER) AS Member FROM msm.MsmArticleSubmission a WHERE a.OrganizationId = @OrganizationId AND a.Id = @Id…
I have a table in SQL SERVER to keep all of the users app reviews. When the user reviews the app with 4 or 5 stars I recieve a Json like this one { "Calificacion": 5, "Cuestionario": "", "Comentarios": "",…
I have the two tables assets and transactions in my database, whereby transactions are connected to assets by the columns transactions.from_id and transactions.to_id: assets: id title 1 a1 2 a2 3 a3 transactions: id title from_id to_id 1 t1 1…
I am using below code to generate JSON, but I cannot seem to find a way to add an extra "root" to the JSON. I have tried to add multiple "roots" by using subqueries, but it does not work as…
Creating a logic app to retrieve data from SQL server in JSON format. Calling SQL Stored Proc from Logic App trigged via HTTP Request. And using below select Query - FOR JSON to create the output as JSON and using…