Skip to main content

Online Orchestration

note

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.

EndpointReturnsScope
txn/transactionsOrchestrated transactionstransactions.read
recon/transactionsTransactions with their reconciliation status and settlement historytransactions.read
recon/settlementsSettlement records, each with its matched transactiontransactions.read

All paths start with POST /v1/reporting/rest/. See Making a request for how filters and pagination work.

Status filters are required

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

FieldTypeDescription
statusesstring[]Required. Transaction statuses to include.
startDatestringOnly transactions created at or after this time (ISO 8601, UTC).
endDatestringOnly transactions created before this time.
limitintegerMaximum 500.
offsetintegerRecords to skip.
Request
{
"statuses": ["Approved", "Charged"],
"startDate": "2026-10-01T00:00:00Z",
"endDate": "2026-10-02T00:00:00Z",
"limit": 500
}
Response
{
"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"
}
]
}
FieldDescription
idOpen Fabric transaction ID.
tenant_reference_id, partner_reference_idYour reference, and the merchant's or gateway's reference.
partner_id, partner_name, partner_info.tenant_partner_idThe merchant or gateway, including your ID for it.
amount, currencyThe requested amount.
approved_amount, approved_currencyThe amount you approved.
total_reversed_amountTotal refunded or reversed.
status, reasonThe transaction status, and why it failed, if it did.
payment_experienceHow 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.

FieldTypeDescription
statusesstring[]Required. Transaction statuses to include.
reconciliation_statusesstring[]Required. Reconciliation statuses to include, for example Full.
startDatestringOnly transactions created at or after this time.
endDatestringOnly transactions created before this time.
limitintegerMaximum 500.
offsetintegerRecords to skip.

The response is recon_transactions. Each record has:

FieldDescription
of_transaction_idOpen Fabric transaction ID.
tenant_reference_id, partner_reference_id, card_reference_idReferences.
original_amount, original_currencyThe requested amount.
approved_amount, approved_currencyThe approved amount.
transaction_status, reversed_amountStatus and reversed amount.
reconciliation_statusHow the transaction matched the settlement files.
settlement_historyThe settlement records matched to this transaction.
of_file_idThe Open Fabric transaction file that included this transaction.
txn_created_at, txn_updated_atTransaction timestamps.

List settlement records​

POST /v1/reporting/rest/recon/settlements returns records from the network's settlement files, each with its matched transaction.

FieldTypeDescription
reconciliation_statusesstring[]Required. Reconciliation statuses to include.
startDatestringOnly records received at or after this time.
endDatestringOnly records received before this time.
limitintegerMaximum 500.
offsetintegerRecords 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:

FieldDescription
settlement_transaction_idID of the record in the settlement file.
settlement_file_id, settlement_dateThe file it came from, and its settlement date.
settlement_amount, settlement_currencyThe settled amount.
acquirer_reference_numberAcquirer reference number (ARN).
reversal_flag, issuer_transaction_codeNetwork codes from the file.
reconciliation_statusWhether the record matched a transaction.
of_transaction_id, transactionThe matched Open Fabric transaction, if any.
recon_created_at, recon_updated_atWhen 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.graphql
# /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
}
}