ACCOUNTING ExportAffiliateBills API Version 1
Exports affiliate bill records from CAKE. Returns a list of affiliate bills filtered by the specified date range and optional affiliate. Use this endpoint to pull affiliate payout data for export to external payment processing systems or for payout reconciliation.
GET
/api/1/accounting.asmx/ExportAffiliateBills
| Parameter | Type | Required | Description |
|---|---|---|---|
| api_key | string | Yes | Your CAKE Admin API key. Find it under Setup → System Access → API Keys. |
| start_date | datetime | Yes | Start of the billing period date range (YYYY-MM-DD HH:MM:SS). |
| end_date | datetime | Yes | End of the billing period date range (YYYY-MM-DD HH:MM:SS). |
| affiliate_id | integer | No | Filter results to a specific affiliate. Omit to return all affiliates. |
| start_at_row | integer | No | Row offset for pagination. Default: 1. |
| row_limit | integer | No | Maximum rows to return. Default: 100. |
Sample request
GET https://yourdomain.cakemarketing.com/api/1/accounting.asmx/ExportAffiliateBills?api_key=YOUR_API_KEY&start_date=2026-01-01+00:00:00&end_date=2026-01-31+23:59:59&affiliate_id=67890
Sample response
{
"request_status": "Success",
"response": {
"affiliate_bills": [
{
"bill_id": 20087,
"affiliate_id": 67890,
"affiliate_name": "Media Partners LLC",
"bill_date": "2026-01-31",
"bill_status": "Paid",
"total_payout": "4825.50",
"currency": "USD"
}
],
"total_rows": 1
}
}
If you have any questions, please reach out to your dedicated CAKE Client Success Manager/Account Manager or contact the CAKE Support Team at support@getCAKE.com.