Search and retrieve pending (not yet posted) transactions for a property. Pending transactions represent charges, payments, or adjustments that have been created but not yet finalized. This endpoint uses POST (instead of GET) to support complex filter criteria in the request body. The filter and sort options are the same as for posted transactions.

Routing behavior: pending transactions keep their original source; when a transaction is routed to another source (for example a group profile), the routing target is stored separately. Filters on source_kind, source_id, and source_identifier (with equals or in operators) match the transaction's original or routed-to source, so querying a group profile returns both its direct pending charges and pending charges routed into it from reservations. folio_id filters (with equals or in operators) likewise match the folio the transaction occupies on either side of the routing. Returned transactions always show their original source in sourceKind / sourceId / sourceIdentifier.

Supported filter fields:

• account_category
• chart_of_account_type
• created_at (alias for transaction_datetime)
• customer_id
• custom_code
• external_relation_id
• external_relation_kind
• folio_id
• id
• internal_code
• origin_id
• parent_id
• source_id
• source_identifier
• source_kind
• transaction_datetime
• trial_balance_id
• service_date

Supported sort fields:

• created_at (alias for transaction_datetime)
• id
• internal_code
• source_id
• transaction_datetime
• service_date

Required filter constraints: The API has certain constraints for filters so that the system is able to efficiently query the data. Every request must include at least one of the following base filters:

• id with operator equals or in
• source_id together with source_kind
• source_identifier together with source_kind
• external_relation_id together with external_relation_kind
• transaction_datetime
• service_date
• trial_balance_id

Additional filter rules:

• Filters cannot be empty.
• source_id requires source_kind to be present in the same request.
• source_identifier requires source_kind to be present in the same request.
• external_relation_id and external_relation_kind must always be used together.
• trial_balance_id only supports the equals operator and cannot appear more than once.
• When using a single filter condition (without and/or), only id, transaction_datetime, or service_date are allowed, and the operator must be equals or in.

Example — single filter condition (no AND/OR needed):

  {
    "filters": {
      "field": "id",
      "operator": "in",
      "value": [101, 102, 103]
    }
  }

  {
    "filters": {
      "field": "service_date",
      "operator": "equals",
      "value": "2024-01-01"
    }
  }

Example — composite filter condition:

  {
    "filters": {
      "and": [
        {
          "field": "transaction_datetime",
          "operator": "greater_than_or_equal",
          "value": "2024-01-01T00:00:00Z"
        },
        {
          "field": "transaction_datetime",
          "operator": "less_than",
          "value": "2024-02-01T00:00:00Z"
        }
      ]
    }
  }

Example — composite filter condition with sorting and pagination:

  {
    "filters": {
      "and": [
        {
          "operator": "greater_than_or_equal",
          "value": "2019-01-11T08:59:00Z",
          "field": "transaction_datetime"
        },
        {
          "operator": "equals",
          "value": "123",
          "field": "source_id"
        },
        {
          "operator": "equals",
          "value": "RESERVATION",
          "field": "source_kind"
        },
        {
          "or": [
            {
              "operator": "in",
              "value": ["1", "2", "3"],
              "field": "customer_id"
            },
            {
              "operator": "equals",
              "value": "9000",
              "field": "internal_code"
            }
          ]
        }
      ]
    },
    "pageToken": null,
    "limit": 10,
    "sort": [
      {
        "field": "transaction_datetime",
        "direction": "asc"
      }
    ]
  }

{
  "transactions": [
    {
      "sourceDatetime": "2017-07-21T17:32:28Z",
      "transactionDatetime": "2017-07-21T17:32:28Z",
      "serviceDate": "2017-07-21",
      "businessDate": "2026-06-21",
      "createdAt": "2017-07-21T17:32:28Z",
      "sourceIdentifier": "38883261663",
      "subSourceIdentifier": "38883261663-2"
    }
  ]
}