Hi
Welcome, I think you cannot directly assign the resulting JSON from FDQuery to TMS web datasets or grids, their formats will not match. FireDac has bunch of metadata in those JSONs in addition to data rows. It works with native FDMemorydataset because they share same format probably.
So I recommend you check this post by @AndrewSimard, to see how he parses that JSON.