To add my previous post, here is a quick PowerShell script I wrote to parse the JSON payload and convert it to a CSV (Excel) output. Very little error checking done. Just paste in Excel and delimit by the comma. Hope it works for others.
$payload = 'PASTE ENTIRE JSON PAYLOAD HERE'
$results = ConvertFrom-Json $payload
Write-Output "Date,Donor,Email,Phone,Amount,Currency,DonationType,Label0,Field0,Label1,Field1"
$(ForEach($r in $results.contributions){
$Date = (Get-Date -Date "01-01-1970") + ([System.TimeSpan]::FromMilliSeconds(($r.submittedOn)))
$Donor = $r.donor.name
$Email = $r.donor.email
$Phone = $r.donor.phone
$Amount = $r.amount.decimalValue
$currency = $r.amount.currencyCode
$DonationType = $r.donationTitle
$Label0 = $Value0 = $Label1 = $Value1 = ""
if($r.formData){
$Label0 = $r.formData.fields[0].label
$Value0 = $r.formData.fields[0].value
$Label1 = $r.formData.fields[1].label
$Value1 = $r.formData.fields[1].value
}
Write-Output "`"$($Date)`",$($Donor),$($Email),$($Phone),$($Amount),$($Currency),$($DonationType),$($Label0),`"$($Value0)`",$($Label1),`"$($Value1)`""
})
