Skip to content

Get Updated Reservation Transactions by Hotel (DLM-Based)

This endpoint returns a list of reservation-related operations (payments, refunds, and status updates) that have been created or modified since the last request, based on the internal Data Last Modified (DLM) mechanism.


Request

GET /v2/transactions/vouchers/hotel/{hotel_id}?id_type={id_type}

Example:

GET /v2/transactions/vouchers/hotel/17?id_type=internal

Path Parameters

Name Type Required Description
hotel_id int Yes Internal hotel ID.

Query Parameters

Name Type Required Description
id_type string Yes Determines how the hotel ID should be interpreted. Possible values: internal, channel_manager.

DLM Behavior (Data Last Modified)

The service keeps track of the timestamp of the last request made by this hotel.

  • First request:
    All transaction vouchers for the hotel are returned.

  • Subsequent requests:
    Only records that were created or updated after the last request are returned.

This allows to sync data incrementally.


Response Schema

Root Object

Field Type Description
hotel object Basic metadata about the hotel.
data array List of updated reservations / voucher records.
metadata object Extra details such as total items.

Hotel Object

Field Type Description
id int Internal hotel ID.
channel_mannager_id string Channel manager hotel identifier.
name string Hotel name.

Data Entry

Each item returned in data represents a reservation voucher with the following fields:

FIELD TYPE DESCRIPTION
operation_type String Type of operation performed. Accepted values: automated, terminal_payment, payment_link.
id Integer Internal operation ID in Autocore.
reservation_id String Unique reservation identifier.
portal_code String | Null Portal code if applicable.
checkin_date Date | Null Reservation check-in date (YYYY-MM-DD) if applicable.
guest String Guest full name.
bank String Bank associated with the payment.
payment_type String Payment type or concept.
payment_status_code String Technical payment status code.
payment_status String Human-readable payment status.
transaction Object | Null Information about the processed transaction. May be null.
refound Object | Null Information about the refund. May be null.
generated_at String Report generation timestamp (DD-MM-YYYY hh:mm:ss AM/PM).

Transaction Object (nullable)

FIELD TYPE DESCRIPTION
status_code String Transaction status code.
status String Human-readable transaction status.
status_detail String Detailed status description.
carrier String Payment processor/network (e.g., RedeBan).
transaction_id String Carrier-generated transaction identifier.
description String Description of the processed payment.
payment_method String Payment method used (credit_card, etc.).
payment_card_info Object Credit card information used in the transaction.
installments String Number of installments.
payment_date Datetime Date and time of the payment.
amount Float Processed amount.
currency String Currency of the transaction.
voucher_url String URL to the payment voucher.

Payment Card Info

FIELD TYPE DESCRIPTION
card_holder String Card holder name.
card_num String Masked card number.
card_type String Card brand or type.

Refund Object (nullable)

Field Type Description
status_code string Refund status code.
status string Translated status.
status_detail string Additional detail.
transaction_id string Refund transaction reference.
refund_date datetime When the refund was processed.
amount float Refund amount.
currency string Currency.
voucher_url string Link to refund voucher.

Status Codes

The following status codes may appear in root, transaction, or refound.

CODE ORIGINAL (ES)
pending Pendiente
invalid_card Tarjeta no válida
rejected Rechazado
applied Aplicado
cancelled Cancelado
early_checkout Salida anticipada
overdue Vencido
in_process En proceso
partial_refound Reembolso parcial
total_refound Reembolso total
rejected_refound Reembolso rechazado
pending_refound Reembolso pendiente
in_process_refound Reembolso en proceso
in_validation En validación
cancelled_charge Cobro cancelado
no_card_data Sin datos de pago
invalid_card_data Datos de pago inválidos
error Error

Status Detail Values

The following values may appear inside transaction.status_detail or refound.status_detail.

DETAIL (ES)
Recaudo: Aprobado
Recaudo: Aprobación pendiente
Recaudo: Rechazado
Recaudo: Cancelado
Reembolso: Aprobado
Reembolso: Aprobación pendiente
Reembolso: Rechazado

Supported Portals

The following values may appear in portal_code when the reservation originates from a connected OTA, wholesaler, or booking engine.

PORTAL KEY DESCRIPTION
booking Booking.com
expedia Expedia
despegar Despegar
hyperguest HyperGuest
hotelbeds Hotelbeds
scalabed Scalabed
hopper Hopper
roomcloud RoomCloud
roibos Roibos
tbo TBO Holidays
roiback Roiback
siteminder_engine SiteMinder Booking Engine
channels_plus Channels+
cloudbeds_engine Cloudbeds Booking Engine
profitroom Profitroom
open_travel_service Open Travel Service
webbeds Webbeds
simple_booking Simple Booking
airbnb Airbnb
hostelworld Hostelworld
mirai Mirai
gnahs GNA Hotel Solutions (GNAHS)

Example Response

The following response represents a valid sample:

{
    "hotel": {
        "id": 17,
        "channel_mannager_id": "0001",
        "name": "Test Hotel"
    },
    "data": [
        {
            "operation_type": "payment_link",
            "id": 163,
            "reservation_id": "bk_123456789",
            "portal_code": "booking",
            "checkin_date": "2025-06-21",
            "guest": "Jhon Doe",
            "bank": "Davivienda",
            "payment_type": "anticipo estadía",
            "payment_status_code": "in_process_refound",
            "payment_status": "Reembolso en proceso",
            "transaction": {
                "status_code": "applied",
                "status": "Aplicado",
                "status_detail": "Recaudo: Aprobado",
                "carrier": "redeban",
                "transaction_id": "RB-774454",
                "description": "Pago exitoso de link de pago hz824gjch4fd por: $125,000.00",
                "payment_method": "credit_card",
                "payment_card_info": {
                    "card_holder": "David Rojas",
                    "card_num": "**********1111",
                    "card_type": "Visa"
                },
                "installments": "1",
                "payment_date": "2025-09-24 19:39:23.825846",
                "amount": 125000.0,
                "currency": "COP",
                "voucher_url": "localhost:8081/v1/bookings/123/vouchers?type=payment_link"
            },
            "refound": {
                "status_code": "in_process_refound",
                "status": "Reembolso en proceso",
                "status_detail": "Reembolso: Aprobación pendiente",
                "transaction_id": "RB-774454",
                "refund_date": "2025-09-24 19:39:38.849530",
                "amount": 25000.0,
                "currency": "COP",
                "voucher_url": "localhost:8081/v1/bookings/123/vouchers?type=payment_link&transaction_id=3234"
            },
            "generated_at": "09-10-2025 02:59:32 PM"
        },
        {
            "operation_type": "automated",
            "id": 12652,
            "reservation_id": "3462688899",
            "portal_code": "despegar",
            "checkin_date": "2025-11-26",
            "guest": "Jane Doe",
            "bank": "Davivienda",
            "payment_type": "anticipo estadía",
            "payment_status_code": "pending",
            "payment_status": "Pendiente",
            "transaction": null,
            "refound": null,
            "generated_at": "18-11-2025 04:56:00 PM"
        },
    ],
    "metadata": {
        "total_items": 2
    }
}

Status code: 401, 403, 404

{
 "code": "Status code",
 "message":"Error description",
 "detail": "Error details"
}