Reports
API Connect generates accounting reports by period and returns them as a ZIP of Excel files. They are meant for monthly closing, reconciliation, and filing annexes with the MH.
There are three reports, all with the same mechanics:
| Endpoint | Content |
|---|---|
GET /reports/active-documents | Active (valid) documents in the range. |
GET /reports/voided-documents | Voided documents in the range. |
GET /reports/annexes | Accounting annexes (VAT ledger format). |
Technical details
| Method | GET |
| Authentication | Header Authorization: Bearer odt_... (does not accept ?key=) |
| Response | application/zip (direct download) |
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
start_date | string | Yes | Start date, format YYYY-MM-DD. |
end_date | string | Yes | End date, format YYYY-MM-DD (inclusive). |
The range (end date minus start date) cannot exceed 31 days. A larger range returns 400 immediately, without generating anything. For longer periods, request one month at a time.
What the ZIP contains
Each ZIP contains one Excel file per document type that the company actually issued in the range. Inside each Excel there is one sheet per point of sale and one row per document.
If a document type had no activity in the range, that file is omitted from the ZIP. For example, if no CCF was issued during the month, there will be no CCF file — that is expected, not an error.
File names inside the active-documents ZIP:
| File | Document type |
|---|---|
COMPROBANTES_CONSUMIDOR_FINAL.xlsx | Invoice (01) |
CONTRIBUYENTES.xlsx | CCF (03) |
NOTAS_DE_CREDITO.xlsx | Credit Note (05) |
SUJETOS_EXCLUIDOS.xlsx | Excluded Subject (14) |
The report is a listing (documents as Excel rows), not the PDF/JSON of each DTE. To download the file of a specific document, use Download files.
Example
curl -fL -o active_documents.zip \
-H "Authorization: Bearer odt_xxx" \
"https://ocote.io/api/connect/reports/active-documents?start_date=2026-06-01&end_date=2026-06-30"
The other two reports are identical; only the path changes to voided-documents or annexes.
On Windows prefer -o name.zip (explicit name). The -OJ flag (use the server-provided name) may fail in some Windows environments when renaming the file across drives.
Errors
| HTTP | Message |
|---|---|
400 | Formato de fecha invalido. Use YYYY-MM-DD |
400 | La fecha de inicio no puede ser posterior a la fecha de fin |
400 | El rango de fechas no puede ser mayor a 31 dias (un mes) |
401 | API key missing or invalid. |
See also
- List documents — to query documents by filters in JSON (instead of Excel).
- Rate limits — report downloads count against the limit.
- Download files — for the PDF/JSON of an individual document.