marge embedded JSON objects with powershell

Question

I have following ConvertFrom-Json output from JSON file:

Id                 : 1
ItemName           : TestFile
SharingInformation : {@{[email protected]; ResharePermission=Read}, @{[email protected]; ResharePermission=Read}}

I would like to save this data to .csv file in following manner as columns:

Id                 : 1
ItemName           : TestFile
Users              : (read) [email protected] ; (write) [email protected]

as columns.. Here you can find part of my actual PS code (which do not work properly when there is more than one embedded values):

$JSONFile = $ExctratedFile | ConvertFrom-Json
$psObjectForCsv = $JSONFile | ForEach-Object {
    [PSCustomObject]@{
        "id"=$_.Id
        "ItemName"=$_.ItemName
        "RecipientEmail"=$_.SharingInformation.RecipientEmail
        "ResharePermission"=$_.SharingInformation.ResharePermission

    }
}
$psObjectForCsv | Export-Csv -path $fileName -Force -NoTypeInformation
}

do you have any ideas how to achieve this?

Thank you for your help! Regards

Theo · Accepted Answer · 2021-01-20 09:41:14Z

1

You can format the SharingInformation in any form you like.

Try

$JSONFile = $ExctratedFile | ConvertFrom-Json
$result   = $JSONFile | ForEach-Object {
    # output a formatted string "(permission) emailaddress" 
    $users = foreach ($shareInfo in $_.SharingInformation) {
        '({0}) {1}' -f $shareInfo.ResharePermission, $shareInfo.RecipientEmail
    }
    [PSCustomObject]@{
        id       = $_.Id
        ItemName = $_.ItemName
        Users    = $users -join "; "
    }
}

$result | Export-Csv -Path $fileName -Force -NoTypeInformation

answered Jan 20, 2021 at 9:41

Theo

61.9k8 gold badges28 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

anders1990 Over a year ago

that's working:) is there any way to sort values by $shareInfo.ResharePermission ?

Theo Over a year ago

@anders1990 You could do

$users = foreach ($shareInfo in ($_.SharingInformation | Sort-Object ResharePermission)) {         '({0}) {1}' -f $shareInfo.ResharePermission, $shareInfo.RecipientEmail     }

.

Collectives™ on Stack Overflow

marge embedded JSON objects with powershell

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related