Online Orchestration
This guide covers transactions created through Online Orchestration. Transactions processed through Account Tokenization don't appear here; see Transactions.
These endpoints report on transactions made through Online Orchestration, and on how they reconcile with the settlement files from your card network.
| Endpoint | Returns | Scope |
|---|---|---|
txn/transactions | Orchestrated transactions | transactions.read |
recon/transactions | Transactions with their reconciliation status and settlement history | transactions.read |
recon/settlements | Settlement records, each with its matched transaction | transactions.read |
All paths start with POST /v1/reporting/rest/. See Making a request for how filters and pagination work.
Each endpoint below has at least one status filter that you must send, with one or more values. A request without it fails with 400. Status values are case-sensitive and match the values returned in the response, for example Approved or Charged.
These endpoints have no default limit: without one, they return up to 500 records. They do not return a total count.
List transactions
POST /v1/reporting/rest/txn/transactions
| Field | Type | Description |
|---|---|---|
statuses | string[] | Required. Transaction statuses to include. |
startDate | string | Only transactions created at or after this time (ISO 8601, UTC). |
endDate | string | Only transactions created before this time. |
limit | integer | Maximum 500. |
offset | integer | Records to skip. |
{
"statuses": ["Approved", "Charged"],
"startDate": "2026-10-01T00:00:00Z",
"endDate": "2026-10-02T00:00:00Z",
"limit": 500
}
{
"transactions": [
{
"id": "67f468dd-dd44-45f2-a9b1-2eb15d07c644",
"partner_reference_id": "MT1650952400081",
"tenant_reference_id": "1b7b28af-a9eb-48b6-a1bc-8b50dd5489ba",
"partner_id": "c672db28-e16f-4335-9534-89cf88aaeb0d",
"partner_name": "merchant-1",
"partner_info": { "id": "c672db28-e16f-4335-9534-89cf88aaeb0d", "tenant_partner_id": "M-0042" },
"currency": "SGD",
"amount": 2300,
"approved_currency": "SGD",
"approved_amount": 2300,
"status": "Charged",
"payment_experience": null,
"total_reversed_amount": null,
"reason": null,
"created_at": "2026-10-01T05:53:29.319",
"updated_at": "2026-10-01T05:54:09.100"
}
]
}
| Field | Description |
|---|---|
id | Open Fabric transaction ID. |
tenant_reference_id, partner_reference_id | Your reference, and the merchant's or gateway's reference. |
partner_id, partner_name, partner_info.tenant_partner_id | The merchant or gateway, including your ID for it. |
amount, currency | The requested amount. |
approved_amount, approved_currency | The amount you approved. |
total_reversed_amount | Total refunded or reversed. |
status, reason | The transaction status, and why it failed, if it did. |
payment_experience | How the customer paid. |
List reconciled transactions
POST /v1/reporting/rest/recon/transactions returns transactions with their reconciliation status, and the settlement records matched to each.
| Field | Type | Description |
|---|---|---|
statuses | string[] | Required. Transaction statuses to include. |
reconciliation_statuses | string[] | Required. Reconciliation statuses to include, for example Full. |
startDate | string | Only transactions created at or after this time. |
endDate | string | Only transactions created before this time. |
limit | integer | Maximum 500. |
offset | integer | Records to skip. |
The response is recon_transactions. Each record has:
| Field | Description |
|---|---|
of_transaction_id | Open Fabric transaction ID. |
tenant_reference_id, partner_reference_id, card_reference_id | References. |
original_amount, original_currency | The requested amount. |
approved_amount, approved_currency | The approved amount. |
transaction_status, reversed_amount | Status and reversed amount. |
reconciliation_status | How the transaction matched the settlement files. |
settlement_history | The settlement records matched to this transaction. |
of_file_id | The Open Fabric transaction file that included this transaction. |
txn_created_at, txn_updated_at | Transaction timestamps. |
List settlement records
POST /v1/reporting/rest/recon/settlements returns records from the network's settlement files, each with its matched transaction.
| Field | Type | Description |
|---|---|---|
reconciliation_statuses | string[] | Required. Reconciliation statuses to include. |
startDate | string | Only records received at or after this time. |
endDate | string | Only records received before this time. |
limit | integer | Maximum 500. |
offset | integer | Records to skip. |
The date filters apply to recon_created_at, the time Open Fabric received the record. They don't filter on the settlement date.
The response is recon_settlements. Each record has:
| Field | Description |
|---|---|
settlement_transaction_id | ID of the record in the settlement file. |
settlement_file_id, settlement_date | The file it came from, and its settlement date. |
settlement_amount, settlement_currency | The settled amount. |
acquirer_reference_number | Acquirer reference number (ARN). |
reversal_flag, issuer_transaction_code | Network codes from the file. |
reconciliation_status | Whether the record matched a transaction. |
of_transaction_id, transaction | The matched Open Fabric transaction, if any. |
recon_created_at, recon_updated_at | When Open Fabric received and last updated the record. |
GraphQL queries
Each endpoint is built on one of the queries below. The fields you send in the request body fill in its query. To fetch fewer fields or combine data, send your own version to the GraphQL endpoint.
- txn/transactions
- recon/transactions
- recon/settlements
# /v1/reporting/rest/txn/transactions (POST)
#
# Scope: transactions.read
# Hasura query: allowed-queries/get-realtime-transaction-post (REST url: txn/transactions)
#
# Generated from slice-graphql-service src/schema/v1/metadata/query_collections.yaml
# by docs/scripts/sync-reporting-graphql.mjs. Do not edit by hand.
query RestQuery ($limit: Int, $offset: Int, $startDate: timestamp, $endDate: timestamp, $statuses: [String!]!) {
transactions(limit: $limit, offset: $offset, where: {created_at:{_gte:$startDate,_lt:$endDate},status:{_in:$statuses}}) {
id
partner_reference_id
tenant_reference_id
partner_id
partner_name
currency
approved_currency
amount
approved_amount
partner_info {
id
tenant_partner_id
}
status
payment_experience
total_reversed_amount
reason
updated_at
created_at
}
}
# /v1/reporting/rest/recon/transactions (POST)
#
# Scope: transactions.read
# Hasura query: allowed-queries/get-recon-transaction-post (REST url: recon/transactions)
#
# Generated from slice-graphql-service src/schema/v1/metadata/query_collections.yaml
# by docs/scripts/sync-reporting-graphql.mjs. Do not edit by hand.
query RestQuery ($limit: Int, $offset: Int, $startDate: timestamp, $endDate: timestamp, $statuses: [String!]!, $reconciliation_statuses: [String!]!) {
recon_transactions(limit: $limit, offset: $offset, where: {txn_created_at:{_gte:$startDate,_lt:$endDate},transaction_status:{_in:$statuses},reconciliation_status:{_in:$reconciliation_statuses}}) {
of_transaction_id
tenant_id
partner_id
tenant_reference_id
partner_reference_id
card_reference_id
settlement_history {
settlement_currency
settlement_amount
settlement_transaction_id
settlement_date
settlement_file_id
reversal_flag
issuer_transaction_code
recon_created_at
recon_updated_at
}
partner_info {
id
tenant_partner_id
}
original_amount
original_currency
approved_amount
approved_currency
transaction_status
reversed_amount
reconciliation_status
of_file_id
txn_created_at
txn_updated_at
}
}
# /v1/reporting/rest/recon/settlements (POST)
#
# Scope: transactions.read
# Hasura query: allowed-queries/get-recon-settlement-post (REST url: recon/settlements)
#
# Generated from slice-graphql-service src/schema/v1/metadata/query_collections.yaml
# by docs/scripts/sync-reporting-graphql.mjs. Do not edit by hand.
query RestQuery ($limit: Int, $offset: Int, $startDate: timestamp, $endDate: timestamp, $reconciliation_statuses: [String!]!) {
recon_settlements(limit: $limit, offset: $offset, where: {recon_created_at:{_gte:$startDate,_lt:$endDate},reconciliation_status:{_in:$reconciliation_statuses}}) {
settlement_transaction_id
of_transaction_id
tenant_id
partner_id
transaction {
of_transaction_id
tenant_id
partner_id
card_reference_id
original_currency
original_amount
approved_currency
approved_amount
transaction_status
}
tenant_reference_id
partner_reference_id
acquirer_reference_number
reversal_flag
reconciliation_status
settlement_currency
settlement_amount
settlement_date
settlement_file_id
issuer_transaction_code
recon_created_at
recon_updated_at
}
}