training

Currently, vendor session data is being fetched using the below API:

GET /api/v1/session/vendor-transactions/get-vendor-sessions?vendorId={vendorId}&date={date}&page={page}&pageSize={pageSize}

This API returns paginated data only (limited records per page).

We need to implement a new API to allow downloading complete vendor session data (all pages) into a CSV/Excel file.

Business Requirement:
User should be able to download all session records for a selected date/vendor
Data should not be restricted to current page
Export should match the data shown in UI (Session Detail screen)
Proposed API:
GET /api/v1/session/vendor-transactions/export-vendor-sessions
Request Parameters:
vendorId (required)
date (required) OR date range (optional enhancement)
status (optional)
Any other applied UI filters
Response:
File download
Supported formats:
CSV (.csv)
Excel (.xlsx)
Fields to be included in export:
Station
Charger
Start Time
End Time
Duration
Energy (kWh)
Cost/kWh
Session Fee
Amount
User
Status
Functional Requirements:
Export should include ALL records (no pagination)
Should fetch complete dataset from backend/database
File should download on API hit
Proper column headers should be included
Data format should match UI
Non-Functional Requirements:
Should handle large datasets efficiently
Prefer streaming or batch processing
API should not timeout for large data
Memory usage should be optimized
Acceptance Criteria:
User can download full dataset in one click
Export contains all records across pages
Data matches UI exactly
File opens correctly in Excel/CSV viewer
No performance issues for large datasets