Flat booking and retail digest for export
GET/v2/bookings/digest
Requires your API key in the X-API-Key header.
Returns one flat row per booking, retail sale, or voucher sale, shaped for CSV/Excel export.
Takes the same filters, scoping and pagination as GET /v2/bookings (including
nopagination=true for a plain array).
Pass columns (comma-separated camelCase field names, e.g.
columns=bookingId,bookingCode,retailPrice) to choose the fields; omitted, every field
your role allows is returned.
Money columns depend on role. With role=reseller you get the selling side:
retailPrice, retailPriceBreakdown, commission (your earnings on the booking; 0 for
in-house bookings) and refundAmount (non-zero only for CANCELLED bookings: final price
minus cancellation fee). With role=organizer you get the supplying side instead:
currency, turneoFee and organizerPayout. Timestamps (startTime, bookingCreated)
are local wall-clock strings in the experience's timezone (YYYY-MM-DD HH:MM:SS).
curl "https://api.turneo.co/v2/bookings/digest" \
-H "X-API-Key: <your-api-key>"Query parameters
pageintegerPage number to return (1-based).
- Default:
1- Example:
1
page_sizeintegerNumber of rows per page. Defaults to 50.
- Default:
50- Example:
50
nopaginationbooleanSet to
trueto disable pagination and return a plain array of rows.- Default:
false- Example:
false
columnsstringComma-separated camelCase digest field names to include. Defaults to every field your
roleallows; money fields outside your role are ignored even when requested.- Example:
bookingId,bookingCode,retailPrice,currency
rolestringWhich side of the bookings you report on.
reseller: bookings you sold, with the selling-side money columns.organizer: bookings of experiences you run, withcurrency,turneoFeeandorganizerPayoutinstead of the selling-side money columns.- Allowed values:
organizerreseller- Example:
reseller
bookingStatusstringComma-separated booking statuses (same as the list endpoint).
- Example:
ACCEPTED,COMPLETED,CANCELLED
netRevenuestringFilters rows by canonical net revenue (
retailPrice - refundAmount).positivereturns values greater than zero;zeroreturns values equal to zero. The filter applies consistently to BOOKING, RETAIL, and VOUCHER rows after authenticated partner and assignment scoping.- Allowed values:
positivezero- Example:
positive
agentNamestringOne agent name or a comma-separated list of exact agent names. Multiple values are OR-combined and only narrow the authenticated partner and assignment scope.
- Example:
Iva,Marta
startTime[gte]stringLocal start-date lower bound (value truncated to
YYYY-MM-DD). All list-endpoint filters and modifiers are supported.- Example:
2026-07-01T00:00:00
cancellationFeeAmount[gte]numberNumeric cancellation-fee bound applied to CANCELLED bookings only. Non-numeric values return a 400.
- Example:
1
Responses
200object
Paginated digest rows.
countintegerTotal number of rows matching the filters.
- Example:
137
nextstringnullableAbsolute URL of the next page, or null on the last page.
- Example:
https://api.turneo.co/v2/bookings/digest?page=2&page_size=50
previousstringnullableAbsolute URL of the previous page, or null on the first page.
resultsobject[]The digest rows on this page.
Child fields
typestringWhat the row is.
BOOKINGfor a booking,RETAILfor a retail sale,VOUCHERfor a gift voucher sale.- Allowed values:
BOOKINGRETAILVOUCHER- Example:
BOOKING
bookingIdstring (uuid)Booking UUID, or the sold item's UUID on a retail or voucher row.
- Example:
0b7f5f7e-1234-4c56-89ab-4d5e6f7a8b9c
bookingCodestringShort booking code, or the sold item's code on a retail or voucher row.
- Example:
AC3F1TT2
startTimestringBooking start as a naive local wall-clock string in the experience's timezone. On a retail or voucher row, the moment of sale.
- Example:
2026-07-14 10:00:00
bookingCreatedstringCreation time as a naive local wall-clock string in the experience's timezone.
- Example:
2026-06-30 11:12:00
bookingStatusstringBooking status on a booking row (
ACCEPTED,PENDING,COMPLETED,CANCELLED...); the sold item's status on a retail or voucher row (PAID,DELIVERED,CANCELLED...).- Example:
ACCEPTED
retailPricenumberFinal retail price amount.
- Example:
100
currencystringCurrency of the retail price.
- Example:
EUR
unitsstringHuman-readable purchased units,
"{quantity}x{name}"joined by commas (discount lines excluded).- Example:
2xAdult, 1xTransfer
retailPriceBreakdownobject[]nullableRaw price breakdown lines.
Child fields
labelstringHuman-readable line label, in the booking's language (e.g. a participant type or add-on name).
- Example:
Adult
quantityintegerNumber of units on this line.
- Example:
2
unitPricenumberPer-unit price.
- Example:
50
retailPriceobjectLine total (
unitPrice×quantity).Child fields
amountnumberAmount in major currency units.
- Example:
100
currencystringISO 4217 currency code.
- Example:
EUR
typestringLine kind:
BASE(participant/tier pricing),ADDONorDISCOUNT(negative).- Allowed values:
BASEADDONDISCOUNT- Example:
BASE
travelerNamestringTraveler full name (falls back to the order's traveler when the booking has none).
- Example:
Ada Lovelace
additionalInformationstringAnswered custom booking questions, one "Question: answer" line per field.
- Example:
Dietary requirements: vegetarian
storeAdditionalInformationstringAnswered store-level checkout questions, one "Question: answer" line per question; checkbox answers render as
Yes/No. Question labels come from the store's current config, so an answer whose question was deleted falls back to the raw question id. Populated only whenrole=reseller; "" otherwise.- Example:
Room number: 204
organizerstringOrganizer partner name.
- Example:
Split Tours
experienceNamestringExperience name in the booking's language.
- Example:
Split Old Town Walking Tour
experienceIdstring (uuid)Experience UUID.
- Example:
9b2e6c7d-1f2a-4b3c-8d9e-0a1b2c3d4e5f
resellerstringReseller partner name.
- Example:
Hotel Adriatic
storeNamestringStore the booking was made through ("" when unknown).
- Example:
Lobby Desk
storeIdstringStore ID ("" when unknown).
- Example:
store-123
resellerReferencestringReseller reference, falling back to the agent reference.
- Example:
PMS-42
ratinganyReview rating, or "" when the booking has no review.
- Example:
5
reviewanyReview text, or "" when the booking has no review.
- Example:
Great tour!
commissionnumberReseller earnings on the booking (commission + reseller fee); derived from the cancellation fee for cancelled bookings; 0 for in-house bookings when
role=reseller.- Example:
20
paidTostringWho collected the money, bucketed from
payment.processedBy.Vouchermeans the line was paid with a gift voucher.- Allowed values:
TurneoResellerOrganizerVoucher- Example:
Turneo
paymentCodestringnullablePayment reference code for
role=reseller; null for the organizing view.- Example:
agentstringConcierge agent name ("" when none).
- Example:
Marta
refundAmountnumberAmount refunded to the traveler — non-zero only for CANCELLED bookings (final price minus cancellation fee).
- Example:
0
turneoFeenumbernullableTurneo platform fee for the caller's side of the deal. Null for regular API callers.
organizerPayoutnumbernullableCanonical organizer earnings computed by backend financial logic. Present only in the organizer view; null when financial amounts do not apply to the row's status.
- Example:
80
experiencePropertyNamestringName of the property linked to the experience ("" when none).
- Example:
Hotel Adriatic Split
bookingPropertyNamestringName of the reseller property on the booking ("" when none).
- Example:
Hotel Adriatic Split
optionNamestringnullableBooking option name. Null for retail and voucher rows.
durationstringnullableStable English booking duration, for example
1 day 2 hours.noScheduledDatebooleannullableWhether the booking uses a provider's no-date mode.
cancelledBystringnullablecancellationReasonstringnullablecancellationPolicystringnullableHuman-readable English refund policy shown in the Booking Drawer.
paymentStatusstringnullablediscountstringnullableConcierge discount percentage formatted as displayed in the Booking Drawer.
- Example:
10%
discountNotestringnullabletravelerEmailstringnullabletravelerPhonestringnullablehotelNamestringnullableTraveler hotel for
role=reseller; null for the organizing view.roomOrReservationNumberstringnullableHotel reservation reference or room number for
role=reseller.pmsBookingIdstringnullabletotalParticipantsintegernullableagentReferencestringnullableutmSourcestringnullableutmMediumstringnullableresourcesstringnullableLF-separated resource names for
role=organizer; null for the selling view.participantAdditionalInformationstringnullableLF-separated participant question answers in deterministic participant order.
travelerNotesstringnullablesellerNotestringnullableorganizerNotestringnullableorganizerContactstringnullableLF-separated organizer support contacts for
role=reseller.
{
"count": 137,
"next": "https://api.turneo.co/v2/bookings/digest?page=2&page_size=50",
"previous": null,
"results": [
{
"type": "BOOKING",
"bookingId": "0b7f5f7e-1234-4c56-89ab-4d5e6f7a8b9c",
"bookingCode": "AC3F1TT2",
"startTime": "2026-07-14 10:00:00",
"bookingCreated": "2026-06-30 11:12:00",
"bookingStatus": "ACCEPTED",
"retailPrice": 100,
"currency": "EUR",
"units": "2xAdult, 1xTransfer",
"retailPriceBreakdown": [
{
"label": "Adult",
"quantity": 2,
"unitPrice": 50,
"retailPrice": {
"amount": 100,
"currency": "EUR"
},
"type": "BASE"
}
],
"travelerName": "Ada Lovelace",
"additionalInformation": "Dietary requirements: vegetarian",
"storeAdditionalInformation": "Room number: 204",
"organizer": "Split Tours",
"experienceName": "Split Old Town Walking Tour",
"experienceId": "9b2e6c7d-1f2a-4b3c-8d9e-0a1b2c3d4e5f",
"reseller": "Hotel Adriatic",
"storeName": "Lobby Desk",
"storeId": "store-123",
"resellerReference": "PMS-42",
"rating": 5,
"review": "Great tour!",
"commission": 20,
"paidTo": "Turneo",
"paymentCode": "",
"agent": "Marta",
"refundAmount": 0,
"turneoFee": null,
"organizerPayout": 80,
"experiencePropertyName": "Hotel Adriatic Split",
"bookingPropertyName": "Hotel Adriatic Split",
"optionName": "string",
"duration": "string",
"noScheduledDate": true,
"cancelledBy": "string",
"cancellationReason": "string",
"cancellationPolicy": "string",
"paymentStatus": "string",
"discount": "10%",
"discountNote": "string",
"travelerEmail": "string",
"travelerPhone": "string",
"hotelName": "string",
"roomOrReservationNumber": "string",
"pmsBookingId": "string",
"totalParticipants": 0,
"agentReference": "string",
"utmSource": "string",
"utmMedium": "string",
"resources": "string",
"participantAdditionalInformation": "string",
"travelerNotes": "string",
"sellerNote": "string",
"organizerNote": "string",
"organizerContact": "string"
}
]
}Errors
- 400
Validation failed. Inspect
errors[].fieldanderrors[].code.- 401
Missing or invalid
X-API-Keyheader.- 403
The API key is valid but not allowed to perform this action on this resource.
Error body
typestringError class.
- Allowed values:
validation_errorclient_errorserver_error- Example:
validation_error
errorsobject[]Child fields
codestringMachine-readable error code.
- Example:
required
fieldstringnullableOffending field, or null/'general' for non-field errors.
- Example:
startTime
messagestringHuman-readable message.
- Example:
This field is required.
{
"type": "validation_error",
"errors": [
{
"code": "required",
"field": "startTime",
"message": "This field is required."
}
]
}