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).

Requestbash
curl "https://api.turneo.co/v2/bookings/digest" \
  -H "X-API-Key: <your-api-key>"

Query parameters

  • pageinteger

    Page number to return (1-based).

    Default:
    1
    Example:
    1
  • page_sizeinteger

    Number of rows per page. Defaults to 50.

    Default:
    50
    Example:
    50
  • nopaginationboolean

    Set to true to disable pagination and return a plain array of rows.

    Default:
    false
    Example:
    false
  • columnsstring

    Comma-separated camelCase digest field names to include. Defaults to every field your role allows; money fields outside your role are ignored even when requested.

    Example:
    bookingId,bookingCode,retailPrice,currency
  • rolestring

    Which side of the bookings you report on. reseller: bookings you sold, with the selling-side money columns. organizer: bookings of experiences you run, with currency, turneoFee and organizerPayout instead of the selling-side money columns.

    Allowed values:
    organizerreseller
    Example:
    reseller
  • bookingStatusstring

    Comma-separated booking statuses (same as the list endpoint).

    Example:
    ACCEPTED,COMPLETED,CANCELLED
  • netRevenuestring

    Filters rows by canonical net revenue (retailPrice - refundAmount). positive returns values greater than zero; zero returns 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
  • agentNamestring

    One 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]string

    Local 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]number

    Numeric cancellation-fee bound applied to CANCELLED bookings only. Non-numeric values return a 400.

    Example:
    1

Responses

200object

Paginated digest rows.

  • countinteger

    Total number of rows matching the filters.

    Example:
    137
  • nextstringnullable

    Absolute URL of the next page, or null on the last page.

    Example:
    https://api.turneo.co/v2/bookings/digest?page=2&page_size=50
  • previousstringnullable

    Absolute URL of the previous page, or null on the first page.

  • resultsobject[]

    The digest rows on this page.

    Child fields
    • typestring

      What the row is. BOOKING for a booking, RETAIL for a retail sale, VOUCHER for 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
    • bookingCodestring

      Short booking code, or the sold item's code on a retail or voucher row.

      Example:
      AC3F1TT2
    • startTimestring

      Booking 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
    • bookingCreatedstring

      Creation time as a naive local wall-clock string in the experience's timezone.

      Example:
      2026-06-30 11:12:00
    • bookingStatusstring

      Booking 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
    • retailPricenumber

      Final retail price amount.

      Example:
      100
    • currencystring

      Currency of the retail price.

      Example:
      EUR
    • unitsstring

      Human-readable purchased units, "{quantity}x{name}" joined by commas (discount lines excluded).

      Example:
      2xAdult, 1xTransfer
    • retailPriceBreakdownobject[]nullable

      Raw price breakdown lines.

      Child fields
      • labelstring

        Human-readable line label, in the booking's language (e.g. a participant type or add-on name).

        Example:
        Adult
      • quantityinteger

        Number of units on this line.

        Example:
        2
      • unitPricenumber

        Per-unit price.

        Example:
        50
      • retailPriceobject

        Line total (unitPrice × quantity).

        Child fields
        • amountnumber

          Amount in major currency units.

          Example:
          100
        • currencystring

          ISO 4217 currency code.

          Example:
          EUR
      • typestring

        Line kind: BASE (participant/tier pricing), ADDON or DISCOUNT (negative).

        Allowed values:
        BASEADDONDISCOUNT
        Example:
        BASE
    • travelerNamestring

      Traveler full name (falls back to the order's traveler when the booking has none).

      Example:
      Ada Lovelace
    • additionalInformationstring

      Answered custom booking questions, one "Question: answer" line per field.

      Example:
      Dietary requirements: vegetarian
    • storeAdditionalInformationstring

      Answered 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 when role=reseller; "" otherwise.

      Example:
      Room number: 204
    • organizerstring

      Organizer partner name.

      Example:
      Split Tours
    • experienceNamestring

      Experience name in the booking's language.

      Example:
      Split Old Town Walking Tour
    • experienceIdstring (uuid)

      Experience UUID.

      Example:
      9b2e6c7d-1f2a-4b3c-8d9e-0a1b2c3d4e5f
    • resellerstring

      Reseller partner name.

      Example:
      Hotel Adriatic
    • storeNamestring

      Store the booking was made through ("" when unknown).

      Example:
      Lobby Desk
    • storeIdstring

      Store ID ("" when unknown).

      Example:
      store-123
    • resellerReferencestring

      Reseller reference, falling back to the agent reference.

      Example:
      PMS-42
    • ratingany

      Review rating, or "" when the booking has no review.

      Example:
      5
    • reviewany

      Review text, or "" when the booking has no review.

      Example:
      Great tour!
    • commissionnumber

      Reseller 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
    • paidTostring

      Who collected the money, bucketed from payment.processedBy. Voucher means the line was paid with a gift voucher.

      Allowed values:
      TurneoResellerOrganizerVoucher
      Example:
      Turneo
    • paymentCodestringnullable

      Payment reference code for role=reseller; null for the organizing view.

      Example:
    • agentstring

      Concierge agent name ("" when none).

      Example:
      Marta
    • refundAmountnumber

      Amount refunded to the traveler — non-zero only for CANCELLED bookings (final price minus cancellation fee).

      Example:
      0
    • turneoFeenumbernullable

      Turneo platform fee for the caller's side of the deal. Null for regular API callers.

    • organizerPayoutnumbernullable

      Canonical 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
    • experiencePropertyNamestring

      Name of the property linked to the experience ("" when none).

      Example:
      Hotel Adriatic Split
    • bookingPropertyNamestring

      Name of the reseller property on the booking ("" when none).

      Example:
      Hotel Adriatic Split
    • optionNamestringnullable

      Booking option name. Null for retail and voucher rows.

    • durationstringnullable

      Stable English booking duration, for example 1 day 2 hours.

    • noScheduledDatebooleannullable

      Whether the booking uses a provider's no-date mode.

    • cancelledBystringnullable
    • cancellationReasonstringnullable
    • cancellationPolicystringnullable

      Human-readable English refund policy shown in the Booking Drawer.

    • paymentStatusstringnullable
    • discountstringnullable

      Concierge discount percentage formatted as displayed in the Booking Drawer.

      Example:
      10%
    • discountNotestringnullable
    • travelerEmailstringnullable
    • travelerPhonestringnullable
    • hotelNamestringnullable

      Traveler hotel for role=reseller; null for the organizing view.

    • roomOrReservationNumberstringnullable

      Hotel reservation reference or room number for role=reseller.

    • pmsBookingIdstringnullable
    • totalParticipantsintegernullable
    • agentReferencestringnullable
    • utmSourcestringnullable
    • utmMediumstringnullable
    • resourcesstringnullable

      LF-separated resource names for role=organizer; null for the selling view.

    • participantAdditionalInformationstringnullable

      LF-separated participant question answers in deterministic participant order.

    • travelerNotesstringnullable
    • sellerNotestringnullable
    • organizerNotestringnullable
    • organizerContactstringnullable

      LF-separated organizer support contacts for role=reseller.

Response 200json
{
  "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[].field and errors[].code.

401

Missing or invalid X-API-Key header.

403

The API key is valid but not allowed to perform this action on this resource.

Error body
  • typestring

    Error class.

    Allowed values:
    validation_errorclient_errorserver_error
    Example:
    validation_error
  • errorsobject[]
    Child fields
    • codestring

      Machine-readable error code.

      Example:
      required
    • fieldstringnullable

      Offending field, or null/'general' for non-field errors.

      Example:
      startTime
    • messagestring

      Human-readable message.

      Example:
      This field is required.
Response 400json
{
  "type": "validation_error",
  "errors": [
    {
      "code": "required",
      "field": "startTime",
      "message": "This field is required."
    }
  ]
}