Convert Salesforce platform event JSON to CSV

convertPEJsonToCSV.ps1

# Insert record with attachment
# Usage: ./convertPEJsonToCSV.ps1 -inputFile "./eventjson.json" -output "./uat_event.csv"

param (
    [string]$inputFile,
    [string]$outputFile
)

# create record

echo "input = $inputFile"

$objectData  = Get-Content -Raw "$inputFile" | ConvertFrom-Json

$records = @()

foreach ($obj in $objectData){
    $records += $obj.data.payload
    #echo "payload = " $obj.data.payload
}

$records | Export-Csv -Path $outputFile -NoTypeInformation