Skip to Content (Press Enter)
2023-03-08 10-32-19
Vinod Kumar R
46Views
3Comments
Combine json object which are stored separately
Question
Reactive
Application Type
Reactive
Service Studio Version
11.54.66 (Build 63364)

Hi All,

How can we combine the columns and rows in JSON. I have a table which stores columns and rows is JSON is different columns


I'm trying to get the below output from the above dataset. so how to combine the above JSON.


0
0
14 Jul 2024
Copy Link
2023-11-20 06-53-17
Neha Rathore

Hi @Vinod Kumar R,

Can you please share the OML to understand better.

Thanks

0
0
16 Jul 2024
Copy Link
2022-08-31 11-22-19
Joao Fernandes

Hi, have you tried to use the JSON Deserialize OS object?


https://success.outsystems.com/documentation/11/reference/outsystems_language/logic/implementing_logic/logic_tools/json_deserialize/

Using this you can pass all data into a structure and combine all information

Best Regards,

João Fernandes

0
0
16 Jul 2024
Copy Link
2017-03-03 12-48-17
Balasubramanian Prakasam

Hi Vinoth,

if you want use as structure variable in outsytems, then it should be static columns, if your columns are static and only rows are changed, then create new structure with fixed columns, and for loop to add columns.

if your columns are also dynamic, then structure variable is not possible, only you can manipulate columns and rows in for loop, and combine one json as string used in runtime.

Thanks,

Balasubramanian

0
0
16 Jul 2024
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.