falk0069

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.