Converting an input format to another format

Like (0) Share

Report

Posted on 2 Oct 2023 14:15:04 by Tak103

Hi:

I have the following format in the flow (below) and needed to convert to another format (below - Output). Is this possible?

Format in Flow:

[

{
    "FileName": "abc.pdf",
    "rpa": "true"
},
{
    "FileName": "abc.pdf",
    "robotic process automation": "true"
},
{
    "FileName": "abc.pdf",
    "process automation": "true"
},
{
    "FileName": "pqr.pdf",
    "rpa": "true"
},
{
    "FileName": "pqr.pdf",
    "robotic process automation": "false"
},
{
    "FileName": "pqr.pdf",
    "process automation": "true"
}
]

But need to convert to this format (output):

[
{
    "FileName": "abc.pdf",
    "rpa": "true",
    "robotic process automation": "true",
    "process automation": "true"
},
{
    "FileName": "pqr.pdf",
    "rpa": "true",
    "robotic process automation": "false",
    "process automation": "true"
}
]

All responses (3)

Answers (1)

Verified answer

SudeepGhatakNZ 14,381 Most Valuable Professional on 03 Oct 2023 at 01:10:58

Like (2)

Report
Re: Converting an input format to another format

@Tak103 ,

You could try converting the following Powershell code into workflow logic.

$json = @"
[
{
"FileName": "abc.pdf",
"rpa": "true"
},
{
"FileName": "abc.pdf",
"robotic process automation": "true"
},
{
"FileName": "abc.pdf",
"process automation": "true"
},
{
"FileName": "pqr.pdf",
"rpa": "true"
},
{
"FileName": "pqr.pdf",
"robotic process automation": "false"
},
{
"FileName": "pqr.pdf",
"process automation": "true"
}
]
"@

$data = ConvertFrom-Json $json

$result = @{}
$data | ForEach-Object {
$fileName = $_.FileName
if (-not $result.ContainsKey($fileName)) {
$result[$fileName] = @{
"FileName" = $fileName
}
}
foreach ($key in $_.PSObject.Properties | Where-Object { $_.Name -ne "FileName" }) {
$result[$fileName][$key.Name] = $key.Value
}
}

$finalResult = $result.Values

$finalResult | ConvertTo-Json