GET https://[API-BASE-URL]/v2/sites/[SITE_ID]/export/transactions-2
Returns transaction details along with user, payments, and basic registration detail. Intended to pull large exports of transaction records. The id field is a non-unique transaction id. A transaction id can have multiple items within the same transaction. The transactionItemId will be unique over all transactions and items. For example, a user that paid for a program registration and an additional hat product at the same time would have 2 records with the same id and different transactionItemId values. Results limited by batch size will not split transaction items. All transaction items with the same id will be returned in a single response.
Only the first 1000 results are returned at a time. Because of this, it's important to use the last-updated and last-id parameters to ensure that you get all results. We recommend starting with both values equalling 0, and then using the values from the last returned result in subsequent calls.
GET https://public.leagueapps.io/v2/sites/43590/export/transactions-2
[
{
"siteId": 8978,
"id": 27650050,
"transactionItemId": 24558775,
"lastUpdated": 1596137741000,
"type": "Bank",
"gateway": "StripeLAP",
"amount": 50.0,
"netAmount": 46.75,
"netTotalAmount": 46.75,
"userId": 1726402,
"firstName": "Britney",
"lastName": "Martin",
"programId": 73514,
"programName": "2020 Spring Volleyball League",
"programType": "LEAGUE",
"programCode": "FP",
"accountingCode1": "F20-COED",
"accountingCode2": "Online Registration: Club Payments",
"masterProgramId": null,
"masterProgramName": null,
"masterProgramType": null,
"masterProgramCode": null,
"productOrderId": null,
"productId": null,
"productName": null,
"teamId": null,
"teamName": null,
"bankTransferId": "po_1HCxUwFVpM66Mjd2ucwHnAgL",
"bankTransferDate": 1596675742000,
"created_on": 1596137739000,
"programStartDate": 1446350400000,
"programEndDate": 1446350400000,
"invoiceId": 29731093,
"registrationId": 30069244
},
{
"siteId": 8978,
"id": 27650383,
"transactionItemId": 24559051,
"lastUpdated": 1596138424000,
"type": "Charge",
"gateway": "StripeLAP",
"amount": 50.0,
"netAmount": 46.75,
"netTotalAmount": 46.75,
"userId": 8164467,
"firstName": "Taylor",
"lastName": "Dunn",
"programId": 73514,
"programName": "2020 Spring Volleyball League",
"programType": "LEAGUE",
"programCode": "FP",
"accountingCode1": "F20-COED",
"accountingCode2": "Online Registration: Club Payments",
"masterProgramId": null,
"masterProgramName": null,
"masterProgramType": null,
"masterProgramCode": null,
"productOrderId": null,
"productId": null,
"productName": null,
"teamId": null,
"teamName": null,
"bankTransferId": "po_1HBWbDFVpM66Mjd2ESGPNF9G",
"bankTransferDate": 1596334015000,
"created_on": 1596138421000,
"programStartDate": 1446350400000,
"programEndDate": 1446350400000,
"invoiceId": 29731435,
"registrationId": 30069511
},
{
"siteId": 42061,
"id": 52579619,
"transactionItemId": 47619674,
"lastUpdated": 1660585966000,
"type": "Charge",
"gateway": "StripeLAP",
"amount": 10.0,
"netAmount": 9.14,
"netTotalAmount": 10.05,
"userId": 25386415,
"firstName": "Ali",
"lastName": "Baj",
"programId": 3306188,
"programName": "Fall 2022 Archery",
"programType": "LEAGUE",
"accountingCode1": "Co-Ed",
"accountingCode2": "E-Commerce Products",
"productOrderId": 1733075,
"productId": 83452,
"productName": "T-Shirt",
"created_on": 1660585964000,
"programStartDate": 1662004800000,
"programEndDate": 1669784400000,
"invoiceId": 59389970,
"containerInvoiceId": 59392740
}
]