Converting Data Table to Json after grouping

Hi guys, below shown is my datatable

Json string output should be:

{
“ID”:“1001”,
“Users”:[
{
“User Name”:“ABC”,
“User Email”:“abc@@gmail.com”,
“Employers”:[
{
“Employer Name”:“Reliance”,
“Employer Zip”:“12332”
},
{
“Employer Name”:“Airtel”,
“Employer Zip”:“23232”
}
]
},
{
“User Name”:“DEF”,
“User Email”:“def@@gmail.com”,
“Employers”:[
{
“Employer Name”:“Idea”,
“Employer Zip”:“32343”
},
]
}
]
}

Hi @Bot_user

Welcome to forum

You check this video

Mark it as solution if it resolves ur query

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed::relaxed:

This does not provide the desired output. I need objects inside my json string.

Hello,
I recommend this movie, and you need to create your JSON with for each step by step:

9:45​ Create a simple JSON
11:05​ Create a JSON with an Object inside
12:17​ Create a JSON with Array inside
14:05​ Create a JSON with a List of Strings inside

Thanks,
Cristian Negulescu

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.