Downloading data
Introduction
The /from_kesk/ side of the SFTP server is where Kesk puts files for you to
collect. Besides the processing reports,
it has three export folders:
As of 2026-09-17 no exports are generated. The three folders exist and are
always empty: the export job is written, but nothing runs it, so there is no
schedule to document and no file to collect
(backend#904). Until that
changes, read invoices with the invoices
query on the Enterprise API.
The rest of this page describes the files the export job is written to produce, so an integration can be built against the format. Treat the details as subject to change until exports are running.
Summary
| Export | Folder | File name |
|---|---|---|
Trips | /from_kesk/trips/ | trips_YYYYMMDD.csv |
Orders | /from_kesk/orders/ | orders_YYYYMMDD.csv |
Invoices | /from_kesk/invoices/ | invoices_YYYYMMDD.csv |
- The date in the name is the UTC date the file was written.
- Each file is a full snapshot, not an increment. It holds every row for your enterprise, not just the rows since the previous file, so collect the latest file rather than combining several.
- Rows are ordered newest first.
- A second export on the same UTC day replaces that day's file.
- Each file has a header row, and fields are quoted only where needed.
- Timestamps carry no timezone designator.
Available data
Trips
| Column | Contents |
|---|---|
order_id | Kesk order id |
order_number | The order's human-readable code |
total_amount | Order total, as a decimal number with no currency |
status | The order's status |
created_at | When the order was placed |
Despite the name, this export lists every order associated with your enterprise, not only rides. It carries no pickup, drop-off, distance or employee columns.
Orders
One row per order associated with your enterprise, carrying the allocation recorded against it.
| Column | Contents |
|---|---|
order_id | Kesk order id |
cost_center | Cost centre, or empty |
project_code | Project code, or empty |
department | Department, or empty |
associated_at | When the order was associated with your enterprise |
Join it to the trips export on order_id for amounts and status.
Invoices
| Column | Contents |
|---|---|
invoice_number | The invoice number to quote in correspondence |
period_start | Start of the period the invoice covers |
period_end | End of that period |
subtotal | Amount before tax |
tax_amount | Tax charged |
total_amount | Amount payable |
currency | ISO 4217 code the amounts are in |
status | Invoice status, lowercase |
due_date | When payment falls due |
Reference
Generated reference — every type, field and argument of the Enterprise GraphQL API, built from the live schema. SFTP itself is not GraphQL and is documented in full in this section.