Stuck to create JSON for PowerBI API

Hello everyone,
I’ve spun it all over the place, but my knowledge of Knime is only very recent.
However, I tried to adapt the ‘CreateComplexJSONObject’ workflow, but without success.

I have a Table like that
GroupUserName,Name,Description,Name1,Description1
ATLAS\FG111,Content Manager,By script
ATLAS\BF222,Content Manager,By script
ATLAS\GH333,Content Manager,By script
BUILTIN\ADMINISTRATORS,Content Manager,By script,Browser,By script

And I want to obtain this JSON
“Policies”: [
{
“GroupUserName”: “BUILTIN\ADMINISTRATORS”,
“Roles”: [
{
“Name”: “Browser”,
“Description”: “By script”
},
{
“Name”: “Content Manager”,
“Description”: “By script”
}
]
},
{
“GroupUserName”: “ATLAS\FG111”,
“Roles”: [
{
“Name”: “Content Manager”,
“Description”: “By script”
}
]
},
{
“GroupUserName”: “ATLAS\BF222”,
“Roles”: [
{
“Name”: “Content Manager”,
“Description”: “By script”
}
]
},
{
“GroupUserName”: “ATLAS\GH333”,
“Roles”: [
{
“Name”: “Content Manager”,
“Description”: “By script”
}
]
}
]

If someone could help me it would be great.
Thanks
Emmanuel

Just another things, after a JSON Reader I’ve you tried to do a JSON to Table and just after a TABLE to JSON and sucess to get exactly the same JSON FILE ?

See where I’am, I just need now to have my Roles in Array and not in object

JSON_PBI.knwf (8.9 KB)

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