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)`""
})
If it helps, I did find the data can be pull with a resp call. And actually if you open the DevTool [f12] in the browsers when you click on 'Donations' you will see a URL like this is used:
https://SITENAME.squarespace.com/api/rest/commerce/contributions?offset=0&limit=100
If you browse to it, it will return a JSON payload with all the data. Change to 'limit=100' to get more records. The tricky part is now how to parse the JSON data the easiest.
LMstudio got a reaction from Bhavik in Additional Information Field in Donations Form
LMstudio reacted to falk0069 in Additional Information Field in Donations Form
LMstudio got a reaction from creedon in Additional Information Field in Donations Form
