XModPro

nested JSON form SQL

Cata Cata asked Dec 23, 2019
Active Dec 23 · Viewed 2135 times
<p>Hi, </p> <p>I used so far &lt;xmod:Feed&gt; returning me a 'liniar' json structure. I need to get a 'nested' structure form joined tables. I can achieve this result in SQL Server with FORJSON but send it through &lt;xmod:Feed&gt; I get a token JSON (JSON_F52E2B61-18A1-11d1-B105-00805F49916B<span class="redactor-invisible-space"> which I may parse in javascript....) but also this backslash \"<br></span>[{"JSON_F52E2B61-18A1-11d1-B105-00805F49916B":"{\"main\":[{\"FirstId\":57,\"SecondId\":3, ......<br><br>I can do SQL query in feed to return the inner join tables in nested JSON? </p>

0 Answers

Loading answers...