rates.blockRoomDates
Block a (room, date) range. Idempotent per (tenant, room, date) unique key. One row per night via ON CONFLICT DO NOTHING. Mutation — changes data.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
roomId | string | yes | |
from | string | yes | |
to | string | yes | |
reason | string | no |
Output fields
| Field | Type | Required | Notes |
|---|---|---|---|
count | integer | yes |
rates.block_dates
Block a date range for a unit (room id) so it cannot be booked — e.g. maintenance or owner use. Inserts the blocked nights (idempotent) and best-effort closes the dates on connected OTA channels. Dates are YYYY-MM-DD inclusive. Requires confirmation.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
roomId | string | yes | |
from | string | yes | |
to | string | yes | |
reason | string | no |
Output fields
| Field | Type | Required | Notes |
|---|---|---|---|
count | number | yes |
rates.bulk_set
Set the same price across a date range for a given room type. Inserts or updates one row per night between dateFrom and dateTo (inclusive). Uses the tenant's default rate plan when ratePlanId is omitted. Returns the count of rows inserted/updated.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
ratePlanId | string | no | |
roomType | string | yes | |
dateFrom | string | yes | First night of the range, inclusive. |
dateTo | string | yes | Last night of the range, inclusive. |
priceCents | integer | yes | |
currency | string | no | Default: "EUR" |
Output fields
| Field | Type | Required | Notes |
|---|---|---|---|
count | integer | yes |
rates.createPlan
Create a new rate plan. The name is auto-translated for the booking page; optional namenUebersetzt {de?, en?} sets a language by hand.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
name | string | yes | |
refundable | boolean | no | Default: true |
paymentMode | enum | no | One of: stripe, pay_at_hotel — Default: "stripe" |
minLeadTimeHours | integer | no | |
guestSegment | enum | no | One of: public, business, package |
namenUebersetzt | object | no | |
namenUebersetzt.de | string | no | |
namenUebersetzt.en | string | no |
Output fields
| Field | Type | Required | Notes |
|---|---|---|---|
id | string | yes | |
name | string | yes | |
isDefault | boolean | yes | |
priority | integer | yes | |
refundable | boolean | yes | |
paymentMode | string | yes | |
cancellationWindowHours | integer | yes | |
minLeadTimeHours | integer · nullable | yes | |
maxLeadTimeDays | integer · nullable | yes | |
guestSegment | string · nullable | yes | |
inheritFromId | string · nullable | yes | |
namenUebersetzt | object | yes | |
tenantId | string | yes | |
createdAt | string | yes |
rates.delete
Delete a specific room rate by its UUID. Returns the deleted rate's id.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
id | string | yes | UUID of the room_rate row to delete. |
Output fields
| Field | Type | Required | Notes |
|---|---|---|---|
deletedId | string | yes |
rates.deletePlan
Delete an existing rate plan.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
id | string | yes |
Output fields
| Field | Type | Required | Notes |
|---|---|---|---|
ok | literal | yes | One of: true |
rates.deleteRestriction
Delete a stay-length/date rate restriction.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
ids | array of string | yes |
Output fields
| Field | Type | Required | Notes |
|---|---|---|---|
count | integer | yes |
rates.list
List room rates for a date range. Optional filters: roomType and ratePlanId (defaults to the tenant's default rate plan if omitted). Returns one row per (roomType, date) with priceCents and currency.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
from | string | yes | Start date inclusive, YYYY-MM-DD. |
to | string | yes | End date inclusive, YYYY-MM-DD. |
roomType | string | no | Filter to a specific room type. |
ratePlanId | string | no | Filter to a specific rate plan. |
Output fields
| Field | Type | Required | Notes |
|---|---|---|---|
rates | array of object | yes | |
rates.id | string | yes | |
rates.ratePlanId | string | yes | |
rates.roomType | string | yes | |
rates.date | string | yes | |
rates.priceCents | integer | yes | |
rates.currency | string | yes |
rates.listBlockedDates
List operator-managed blocked-date entries in a window. Joined with the room scope so the UI can show per-room blocks (e.g. "DZ-12 on 2026-06-14: Renovierung"). Read-only query.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
from | string | yes | |
to | string | yes |
Output fields
Returns array of object. Fields of each element:
| Field | Type | Required | Notes |
|---|---|---|---|
id | string | yes | |
roomId | string | yes | |
date | string | yes | |
reason | string · nullable | yes |
rates.listBulkEdits
Audit-log of bulk-edits (rates + restrictions). Read-only; rows are written by bulkSet.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
limit | integer | no | Default: 50 |
Output fields
Returns array of object. Fields of each element:
| Field | Type | Required | Notes |
|---|---|---|---|
id | string | yes | |
tenantId | string | yes | |
userId | string · nullable | yes | |
entityKind | string | yes | |
summary | string | yes | |
affectedCount | integer | yes | |
createdAt | string | yes | |
revertedAt | string · nullable | yes | |
revertedBy | string · nullable | yes | |
actorLabel | string · nullable | yes |
rates.listChannelSync
outbound channel-sync log for the operator's audit surface. Read-only; entries are written by the channel-sync workers (the former hospitable.rate-sync rows stay as history).
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
channel | enum | no | One of: hospitable, booking_com_native |
succeededOnly | boolean | no | Default: false |
failedOnly | boolean | no | Default: false |
limit | integer | no | Default: 100 |
Output fields
Returns array of object. Fields of each element:
| Field | Type | Required | Notes |
|---|---|---|---|
id | string | yes | |
tenantId | string | yes | |
channel | string | yes | |
operation | string | yes | |
roomType | string · nullable | yes | |
dateFrom | string · nullable | yes | |
dateTo | string · nullable | yes | |
httpStatus | integer · nullable | yes | |
errorMessage | string · nullable | yes | |
succeeded | boolean | yes | |
durationMs | integer · nullable | yes | |
createdAt | string | yes |
rates.listPlans
List the property's rate plans.
Input parameters
Returns object.
Output fields
Returns array of object. Fields of each element:
| Field | Type | Required | Notes |
|---|---|---|---|
id | string | yes | |
name | string | yes | |
isDefault | boolean | yes | |
priority | integer | yes | |
refundable | boolean | yes | |
paymentMode | string | yes | |
cancellationWindowHours | integer | yes | |
minLeadTimeHours | integer · nullable | yes | |
maxLeadTimeDays | integer · nullable | yes | |
guestSegment | string · nullable | yes | |
inheritFromId | string · nullable | yes | |
namenUebersetzt | object | yes |
rates.list_restrictions
List min-stay / max-stay restrictions for a date range. Optional ratePlanId filter (defaults to tenant's default plan). Returns one row per (roomType, date) with stopSell, cta, ctd, minStay, maxStay flags.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
from | string | yes | Start date inclusive, YYYY-MM-DD. |
to | string | yes | End date inclusive, YYYY-MM-DD. |
ratePlanId | string | no | |
roomType | string | no |
Output fields
| Field | Type | Required | Notes |
|---|---|---|---|
restrictions | array of object | yes | |
restrictions.id | string | yes | |
restrictions.ratePlanId | string | yes | |
restrictions.roomType | string | yes | |
restrictions.date | string | yes | |
restrictions.stopSell | boolean | yes | |
restrictions.cta | boolean | yes | |
restrictions.ctd | boolean | yes | |
restrictions.minStay | integer · nullable | yes | |
restrictions.maxStay | integer · nullable | yes |
rates.manualResync
manual resync — re-emits the OTA channel rate-sync job for the given range without changing prices. Recovery from a failed channel-sync run. Mutation — changes data.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
roomType | string | yes | |
from | string | yes | |
to | string | yes |
Output fields
| Field | Type | Required | Notes |
|---|---|---|---|
ok | literal | yes | One of: true |
rates.pushPrice
Makes the price set in the calendar effective for THIS ONE ROOM. Mutation — changes data.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
room | string | yes | |
from | string | yes | |
to | string | yes | |
priceCents | integer | yes |
Output fields
| Field | Type | Required | Notes |
|---|---|---|---|
geschrieben | integer | yes | |
beds24 | boolean | yes |
rates.richtwertSetzen
Set nightly prices from the DOUBLE-ROOM price per day: pass `tage` as [{ datum: 'YYYY-MM-DD', doppelzimmerCents }]. Single, triple and shared-bath room types are derived by the property's pricing rule (Einstellungen → Preisstrategie); rooms with their own price row are set room-exact. Every price is pushed to Beds24 (Booking.com/Airbnb) immediately, logged and undoable like the rate calendar. Changes live selling prices — requires confirmation.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
tage | array of object | yes | |
tage.datum | string | yes | |
tage.doppelzimmerCents | integer | yes |
Output fields
| Field | Type | Required | Notes |
|---|---|---|---|
gesetzt | array of object | yes | |
gesetzt.datum | string | yes | |
gesetzt.ziel | string | yes | |
gesetzt.cents | integer | yes |
rates.unblockDates
Unblock by id. Returns count of removed rows. Mutation — changes data.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
ids | array of string | yes |
Output fields
| Field | Type | Required | Notes |
|---|---|---|---|
count | integer | yes |
rates.undoBulkEdit
undo a bulk-edit by restoring old prices from diffJson. New rows (oldPriceCents === null) are deleted; existing rows have their price restored. Marks the audit row with revertedAt. Mutation — changes data.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
id | string | yes |
Output fields
| Field | Type | Required | Notes |
|---|---|---|---|
count | integer | yes |
rates.unit-calendar
Per-unit nightly PRICES for a date window, from Foyer's own price per room (`room_rates`). Returns room (unit code), date, priceCents, currency, minNights, and beds24PriceCents (only when Beds24 sells a different price — price floor per room type / 650 EUR cap). At most 400 nights per window. Says NOTHING about whether a night is free — bookings and blocks are not considered; use `availability.query` for that. Read-only.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
from | string | yes | |
to | string | yes |
Output fields
| Field | Type | Required | Notes |
|---|---|---|---|
days | array of object | yes | |
days.room | string | yes | |
days.date | string | yes | |
days.priceCents | integer · nullable | yes | |
days.currency | string · nullable | yes | |
days.minNights | integer · nullable | yes | |
days.beds24PriceCents | integer | no |
rates.updatePlan
Edit an existing rate plan. Renaming re-translates the booking-page name; calling with just id fills missing languages. namenUebersetzt {"en": "..."} sets the English guest-facing name by hand, {"en": ""} returns it to automatic.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
id | string | yes | |
name | string | no | |
refundable | boolean | no | |
paymentMode | enum | no | One of: stripe, pay_at_hotel |
minLeadTimeHours | integer · nullable | no | |
guestSegment | enum · nullable | no | One of: public, business, package |
namenUebersetzt | object | no | |
namenUebersetzt.de | string | no | |
namenUebersetzt.en | string | no |
Output fields
| Field | Type | Required | Notes |
|---|---|---|---|
id | string | yes | |
name | string | yes | |
isDefault | boolean | yes | |
priority | integer | yes | |
refundable | boolean | yes | |
paymentMode | string | yes | |
cancellationWindowHours | integer | yes | |
minLeadTimeHours | integer · nullable | yes | |
maxLeadTimeDays | integer · nullable | yes | |
guestSegment | string · nullable | yes | |
inheritFromId | string · nullable | yes | |
namenUebersetzt | object | yes | |
tenantId | string | yes | |
createdAt | string | yes |
rates.upsert
Set the price for a specific room type on a specific date. Creates the row if it does not exist, or updates priceCents and currency if it does. Uses the tenant's default rate plan when ratePlanId is omitted.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
ratePlanId | string | no | |
roomType | string | yes | |
date | string | yes | |
priceCents | integer | yes | |
currency | string | no | Default: "EUR" |
Output fields
| Field | Type | Required | Notes |
|---|---|---|---|
id | string | yes | |
ratePlanId | string | yes | |
roomType | string | yes | |
date | string | yes | |
priceCents | integer | yes | |
currency | string | yes |
rates.upsertRestriction
Sets or replaces a day's restrictions for a room type (roomType, date): stopSell, closed to arrival and closed to departure (cta, ctd), minStay and maxStay; if ratePlanId is omitted, the default rate plan applies. Triggers the sync with the connected channels. Owner only. Changes data; a minStay greater than maxStay is rejected. Mutation — changes data.
Input parameters
| Field | Type | Required | Notes |
|---|---|---|---|
ratePlanId | string | no | |
roomType | string | yes | |
date | string | yes | |
stopSell | boolean | no | Default: false |
cta | boolean | no | Default: false |
ctd | boolean | no | Default: false |
minStay | integer | no | |
maxStay | integer | no |
Output fields
| Field | Type | Required | Notes |
|---|---|---|---|
id | string | yes | |
tenantId | string | yes | |
ratePlanId | string | yes | |
roomType | string | yes | |
date | string | yes | |
stopSell | boolean | yes | |
cta | boolean | yes | |
ctd | boolean | yes | |
minStay | integer · nullable | yes | |
maxStay | integer · nullable | yes | |
createdAt | string | yes | |
updatedAt | string | yes |