Skip to content
Wink

Get daily rates grid

POST
/api/managing-entity/{managingEntityIdentifier}/extranet/master-rate/{masterRateIdentifier}/rate/grid
 
curl --request POST \
  --url https://api.wink.travel/api/managing-entity/d5b8a3c2-9e6f-4a1b-8d34-7c2e1f0a5b69/extranet/master-rate/5e8a3b7c-0d4f-4a2b-8c1d-9e6f2a0b4c73/rate/grid \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --header 'Wink-Version: 2.0' \
  --data null

Retrieve a paginated grid of daily rates for a single master rate. Supports filtering and pagination via the State request body.

Authorizations

Section titled “Authorizations ”

Parameters

Section titled “ Parameters ”

Path Parameters

Section titled “Path Parameters ”
managingEntityIdentifier
required
string
""

Property identifier (managing entity UUID) owning these rates

Example 
d5b8a3c2-9e6f-4a1b-8d34-7c2e1f0a5b69
masterRateIdentifier
required
string
""

Master rate identifier for the room type and rate plan

Example 
5e8a3b7c-0d4f-4a2b-8c1d-9e6f2a0b4c73

Header Parameters

Section titled “Header Parameters ”
Wink-Version
string
default: 2.0.0
Allowed values: 2.0

Request Body required

Section titled “Request Body required ”

Pagination and filter state controlling which daily rate records are returned in the grid view

Media type application/json

Pagination, sorting, filtering, and grouping state used to query a paged result set.

object
skip

Number of records to be skipped by the pager.

integer format: int32
0
Example 
0
take

Number of records to take.

integer format: int32
default: 30 >= 1 <= 180
Example 
10
sort

Descriptors used for sorting result set.

Array<object>
""

Descriptor that defines the sort direction and field for ordering a result set.

object
dir

Descriptors used for sorting result set

string
""
Allowed values: asc desc
Example 
asc
field

Data set field to sort on

string
""
Example 
hotel.name
Example 
{
  "dir": "asc",
  "field": "hotel.name"
}
filter

Descriptors used for filtering result set

object
logic

Whether to filter inclusively or exclusively

string
""
Allowed values: and or
Example 
and
filters

Descriptors used for filtering the result set

Array<object>

A single field-level filter criterion that specifies what to match and how to compare it.

object
field
required

Field name to filter on

string
"" >= 1 characters
Example 
hotel.name
operator
required

Filter operator to use on field

string
""
Allowed values: neq eq contains doesnotcontain isnull isnotnull isempty isnotempty startswith endswith gte lte gt lt in nin
Example 
startsWith
value

Value to filter dataset against

""
Example 
Happy Res
ignoreCase

Make filter comparison case insensitive. Default: Case sensitive

boolean
Example 
true
Example 
{
  "field": "hotel.name",
  "operator": "startsWith",
  "value": "Happy Res",
  "ignoreCase": true
}
Example 
{
  "logic": "and",
  "filters": [
    {
      "field": "hotel.name",
      "operator": "startsWith",
      "value": "Happy Res",
      "ignoreCase": true
    }
  ]
}
group

Descriptors to group result sets by.

Array<object>
""

Descriptor that defines how a result set should be grouped, including sort direction and optional aggregate calculations.

object
field

Field to group data set on

string
""
Example 
createdDate
dir

Group sort direction

string
""
Allowed values: asc desc
Example 
asc
aggregates

Primitive aggregate data points

Array<object>

Descriptor that defines an aggregate function to apply to a specific field in a grouped result set.

object
field

Field to run aggregate function on

string
""
Example 
hotel.bookings
aggregate

Aggregate function

string
""
Allowed values: count sum average min max
Example 
count
Example 
{
  "field": "hotel.bookings",
  "aggregate": "count"
}
Example 
{
  "field": "createdDate",
  "dir": "asc",
  "aggregates": [
    {
      "field": "hotel.bookings",
      "aggregate": "count"
    }
  ]
}
Example 
{
  "skip": 0,
  "take": 10,
  "sort": [
    {
      "dir": "asc",
      "field": "hotel.name"
    }
  ],
  "filter": {
    "logic": "and",
    "filters": [
      {
        "field": "hotel.name",
        "operator": "startsWith",
        "value": "Happy Res",
        "ignoreCase": true
      }
    ]
  },
  "group": [
    {
      "field": "createdDate",
      "dir": "asc",
      "aggregates": [
        {
          "field": "hotel.bookings",
          "aggregate": "count"
        }
      ]
    }
  ]
}

Responses

Section titled “ Responses ”

200

Section titled “200 ”

Paginated grid of daily rates for the specified master rate

Media type application/json

Holds all the information for one rate date

object
id

Unique document identifier (UUID)

string format: uuid
""
hotelIdentifier
required

Property identifier that owns this daily rate

string format: uuid
"" >= 1 characters
rateSource
required

Source of the rate update. TRAVELIKO indicates property-managed rates; other values indicate channel manager origins.

string
default: TRAVELIKO >= 1 characters
ratePlanIdentifier
required

Rate plan identifier for pricing controls and restrictions

string format: uuid
"" >= 1 characters
guestRoomIdentifier
required

Guest room (room type) identifier for this rate

string format: uuid
"" >= 1 characters
rate
required

Nightly rate amount in the specified currency

number
""
currencyCode
required

ISO 4217 currency code for this rate

string
"" >= 1 characters /^[A-Z]{3}$/
master
required

Whether this rate is available for booking on this date

boolean
default: true
closedOnArrival
required

Whether guests cannot check in on this date (Closed on Arrival)

boolean
closedOnDeparture
required

Whether guests cannot check out on this date (Closed on Departure)

boolean
day

Day of the month (1-31)

integer format: int32
""
month

Month of the year (1-12)

integer format: int32
""
year

Year in ISO format

integer format: int32
""
quantity

Number of available rooms for this date

integer format: int32
0
minLengthOfStay

Minimum length of stay (in days) required for guests arriving on this date. -1 means no minimum.

integer format: int32
default: -1
maxLengthOfStay

Maximum length of stay (in days) allowed for guests arriving on this date. -1 means no maximum.

integer format: int32
default: -1
singleOccupancyRateModifier

Rate modifier (fixed amount or percentage) for single occupancy bookings

object
type
required

When the type is FIXED, fixedAmount is required. When the type is PERCENTAGE, percent is required.

string
""
Allowed values: FIXED PERCENTAGE
percent

A percentage of the total stay amount for an early check-in or late check-out

number format: float
""
fixedAmount

A localized amount

object
amount
required

Monetary amount value

number
""
currency
required

ISO 4217 currency code

string
"" >= 1 characters /^[A-Z]{3}$/
extraPaxRateModifier

Rate modifier (fixed amount or percentage) for extra adult guests

object
type
required

When the type is FIXED, fixedAmount is required. When the type is PERCENTAGE, percent is required.

string
""
Allowed values: FIXED PERCENTAGE
percent

A percentage of the total stay amount for an early check-in or late check-out

number format: float
""
fixedAmount

A localized amount

object
amount
required

Monetary amount value

number
""
currency
required

ISO 4217 currency code

string
"" >= 1 characters /^[A-Z]{3}$/
extraChildRateModifier

Rate modifier (fixed amount or percentage) for extra child guests

object
type
required

When the type is FIXED, fixedAmount is required. When the type is PERCENTAGE, percent is required.

string
""
Allowed values: FIXED PERCENTAGE
percent

A percentage of the total stay amount for an early check-in or late check-out

number format: float
""
fixedAmount

A localized amount

object
amount
required

Monetary amount value

number
""
currency
required

ISO 4217 currency code

string
"" >= 1 characters /^[A-Z]{3}$/
ttl
required

Time-to-live (TTL) for this rate record in MongoDB. Records are automatically removed 24 hours after this instant.

string format: date-time
""
available
boolean
key
additional properties
""
Example 
{
  "id": "3c6b1a5d-8e2f-4a0b-9c7d-6e4f0a8b2c51",
  "hotelIdentifier": "7d4f2a1b-3e8c-4b0d-a5f9-1c2e6b4d8f07",
  "rateSource": "TRAVELIKO",
  "ratePlanIdentifier": "9a2d5e8c-1f4b-4c7a-b3e6-2d0f8a5c3e91",
  "guestRoomIdentifier": "4b7e2c9a-6f1d-4a0b-8c3e-5d2f9b1a7c84",
  "rate": 4500,
  "currencyCode": "THB",
  "master": true,
  "closedOnArrival": false,
  "closedOnDeparture": false,
  "day": 14,
  "month": 1,
  "year": 2026,
  "quantity": 9,
  "minLengthOfStay": 2,
  "maxLengthOfStay": 30,
  "singleOccupancyRateModifier": {
    "type": "PERCENTAGE",
    "percent": 0.8,
    "fixedAmount": null
  },
  "extraPaxRateModifier": {
    "type": "PERCENTAGE",
    "percent": 0.25,
    "fixedAmount": null
  },
  "extraChildRateModifier": {
    "type": "PERCENTAGE",
    "percent": 0.15,
    "fixedAmount": null
  },
  "ttl": "2026-01-14T00:00:00Z",
  "available": true
}

400

Section titled “400 ”

Bad Request — missing or invalid request parameter or body

Media type application/problem+json
object
type
string format: uri
title
string
status
integer format: int32
detail
string
instance
string format: uri
properties
object
key
additional properties
key
additional properties
""
Example

401

Section titled “401 ”

Unauthorized — authentication is required or the session has expired

Media type application/problem+json
object
type
string format: uri
title
string
status
integer format: int32
detail
string
instance
string format: uri
properties
object
key
additional properties
key
additional properties
""
Example

403

Section titled “403 ”

Forbidden — authenticated but lacking the required permission or scope

Media type application/problem+json
object
type
string format: uri
title
string
status
integer format: int32
detail
string
instance
string format: uri
properties
object
key
additional properties
key
additional properties
""
Example

404

Section titled “404 ”

Not Found — the requested resource does not exist

Media type application/problem+json
object
type
string format: uri
title
string
status
integer format: int32
detail
string
instance
string format: uri
properties
object
key
additional properties
key
additional properties
""
Example

405

Section titled “405 ”

Method Not Allowed — the HTTP verb is not supported on this endpoint

Media type application/problem+json
object
type
string format: uri
title
string
status
integer format: int32
detail
string
instance
string format: uri
properties
object
key
additional properties
key
additional properties
""
Example

415

Section titled “415 ”

Unsupported Media Type — use application/json

Media type application/problem+json
object
type
string format: uri
title
string
status
integer format: int32
detail
string
instance
string format: uri
properties
object
key
additional properties
key
additional properties
""
Example

500

Section titled “500 ”

Internal Server Error — an unexpected failure occurred on the server

Media type application/problem+json
object
type
string format: uri
title
string
status
integer format: int32
detail
string
instance
string format: uri
properties
object
key
additional properties
key
additional properties
""
Example

503

Section titled “503 ”

Service Unavailable — a downstream dependency is unreachable

Media type application/problem+json
object
type
string format: uri
title
string
status
integer format: int32
detail
string
instance
string format: uri
properties
object
key
additional properties
key
additional properties
""
Example