Hi Team,
I have a source which is a azure sql DB. The output from that source is JSON. Query and sample output is as below: -
SELECT * FROM dbo.SalesHeader SH
INNER JOIN dbo.SalesDetail SD ON SH.SalesOrderID = SD.SalesOrderID
FOR JSON AUTO

The issue is, when i place this sql as source query in ADF mapping data flow, i get an error as below:-

How to resolve this issue? How to get the JSON output in a single column? Single row per SalesOrderID and the JSON structure in a single column?



