I have a few queries, and I need to combine all the results into a single large JSON object in the backend. This JSON will be sent to a PDF generation service.
Query 1 (Single Query): Deal (information about the opportunity)
Query 2 (Single Query): Product_Info (information about the Product linked to the Deal)
Query 3 (Single Query): Extended_Product_Info (additional Product details from another table)
Query 4 (Multiple Records): Optionals (optional items selected for the Product belonging to the Deal)
I’m not even able to combine Query 1 and Query 2 (it results in [object Object][object Object]). I'm using “Set Value” for this. Each query individually returns the correct values in proper JSON format — but I need to merge them into a single JSON object (with "sub-objects"). I even tried using “Join” (from “Data Transformations”), but I’m not sure if I did it correctly.
As for Query 4, I assume I’ll need to pre-group the results into an “Array List,” since I need to organize them by Item Family.
Could someone point me in the right direction?
Thanks in advance!
