This is the general direction i am taking. I will need more guidance to be alittle bit more specific.

• I have created a structure from the above json named EEVEE_OUTPUT.
• I have an aggregate that holds the data.

I then created a server action

Then created a client action on my screen that is triggered by clicking a link:

Unfortunately, the file that is downloaded on button click has nothing in it.
Where am I going wrong?

I added a breakpoint on my client action where my server action is on debug.
The debug path goes from the switch statement to the end instead of going through the other route(if statement, assign, json serializer ...)

Can you share the OML?

Now my biggest problem is that am not getting all the data that I need in my Json download.
I am getting data from OrderInfo section of the Json but now the MedItem or MedItemDose which are nested arrays. The following Json is what am currently getting:

{"OrderInfo":{"OrderNum":"34","OrderDt":"03-04-2024","OrderDtm":"03-04-2024","MdctNum":"","MdctDt":"","PtntNum":"13","PtntNm":"Dominic Calvert-Lewin","Sex":"Male","Birthday":"01-01-1999","PtntAddr":"Address 1 Address 2","InOutClsf":"I","HsptCd":"","HsptNm":"","DptmtCd":"0","DoctorNm":"Dych","WardCd":"","WardNm":"","RoomNum":"","EmgClsf":"0","DschClsf":"0","OrderClsf":"0","Note":"","DataClsf":"N","DspsOpt":"5|R^Y^Y|Test Bundesliga Layout|Y","MedItem":[]}}

When I debug the application, I could see all data including those for MedItem and MedItemDose as shown in the image below:

My OML is bigger that 4MB, so can't be attached.

Since my OML's size is bigger that 4MB, I am sharing a link to a google drive

Thank you for sharing.

You will have to change your approach to handle the nested list structures.
I have made a simple example, wich showcases the concept that you need to implement in your code.

In my example i'm using 3 different aggregates to collect the data just to keep it as simple as posssible. You could also use 1 DB call and use the listfilter widget.

I hope this clarifies ! 

Kind regards

Thibaut 

I believe yours is the right process but am still experiencing similar issues where am able to get OrderInfo related info but not MedItem or MedItemDose data in my json download.

When debugging, I can see the expected MedItem and MedItemDose related data but an error pops up when stepping out

Can you share the new OML?

There a local variable in the server action(EEVEE_OUTPUT) whose data type is the structure. The assign is used to populate this local variable with values from the database.
Then, that local variable is used as the input to the json serializer. 

Right now, my serialized json gives me data up to DspsOpt part leaving MedItem empty and MedItemDose nonexistent.
{"OrderInfo":{"OrderNum":"35","OrderDt":"03-04-2024","OrderDtm":"03-04-2024","MdctNum":"","MdctDt":"","PtntNum":"17","PtntNm":"Bukayo Saka","Sex":"Male","Birthday":"05-05-2000","PtntAddr":"Address 1 Address 2","InOutClsf":"I","HsptCd":"","HsptNm":"","DptmtCd":"0","DoctorNm":"Arteta","WardCd":"","WardNm":"","RoomNum":"","EmgClsf":"0","DschClsf":"0","OrderClsf":"0","Note":"","DataClsf":"N","DspsOpt":"5|R^Y^Y|Test EPL Layout|Y","MedItem":[]}}

Hi Mganda.

I found some issues:

1. Each action/function should do only one "task". JSONDataServerAction is not only returning the JSON, it's calling the action Deactivate_Order. The call of the action Deactivate_Order should be done in the MainFlow\ProductionList\DeactivateOrderAndDownloadJson .
2. The query JSONData is only returning 50 records, probably you want to return more data, right?
3. In the image bellow:The IF that I identify as 1, is not doing nothing. If the list is empty, it will step out the for each. The flow ID that I identify as 2, is duplicated, the only difference is "EEVEE_OUTPUT.OrderInfo.MedItem.Current.GroupNum" is "1" when JSONData.List.Current.GLOBAL_VMP.Id <> NullIdentifier(). You can have only a flow and put an inline IF as If(JSONData.List.Current.GLOBAL_VMP.Id <> NullIdentifier(), "1", "") in the "EEVEE_OUTPUT.OrderInfo.MedItem.Current.GroupNum" value.
4. Regarding the mapping, I agree with @Thibaut G, you should revisit your approach to handle the nested list structures.