Download the company account's bookings as a CSV file

Return the completed bookings (processed or cancelled) of the company account in the access token, created in an inclusive period of at most 24 months, as one CSV file with one row per booking, ordered by booking date and then booking code. The period is on the UTC date each booking was created; no other date is accepted, and periodBasis is refused. The file is UTF-8 with a byte-order mark, comma-separated and quoted per RFC 4180, with a header row, dot decimals and YYYY-MM-DD dates. An empty cell is a value that is not known. The sum of amountEur over the rows whose inTotalSpend is true equals the total_spend analytics metric for the same period. Content-Disposition names the file after the period and the date the analytics data was last refreshed, and Last-Modified is that refresh. A header row change is a breaking change. Only account administrators may read it.

ColumnContent
bookingCodeThe booking code.
travelTypeflight, stay, train, car, or other for other travel services.
statusprocessed or cancelled.
bookingDateThe UTC date the booking was created.
serviceStartDateThe local date the service starts: the first departure, the check-in or the pick-up.
serviceEndDateThe local date the service ends: the last arrival, the check-out or the drop-off. Empty for other travel services.
daysBeforeTravelWhole days from bookingDate to serviceStartDate. Empty when either date is unknown, or when the service started before the booking was created.
amountEurThe amount in EUR, converted at the booking's own exchange rate and rounded to the cent. A cancelled booking keeps its remaining fees.
amountOriginalThe amount in currency, rounded to two decimals.
currencyThe ISO 4217 billing currency.
destinationCountryThe ISO 3166-1 alpha-2 destination country. Empty for other travel services.
travelersThe number of travelers with a profile; for other travel services, the number requested.
selfBookingtrue when the booking was made online, not by an agent or by hand.
policyCompliancecompliant, not_compliant, or not_applicable when no travel policy applies.
inTotalSpendtrue when the booking counts in total_spend.
Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
Query Params
date
required

First day of the period, inclusive (YYYY-MM-DD), on the date each booking was created.

date
required

Last day of the period, inclusive (YYYY-MM-DD). The period spans at most 24 months.

Responses

401

Unauthenticated, or no company account identity.

403

The caller is not an administrator of the account.

422

An invalid or reversed period, a period longer than 24 months, or an unexpected parameter such as periodBasis.

500

The account bookings could not be read.

503

The analytics data is not available yet, or the service is temporarily unavailable.

Language
Credentials
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
text/csv