---
title: Fail Transaction API
slug: en/nicepay-api-business-report-fail-transaction-api
description: Information about Fail Transaction API from API Business Report available on the NICEPAY system
image: https://archbee-image-uploads.s3.amazonaws.com/ZHvSjR5ZrsoxwKbJa3xmo/z23gKL3L9cmW8fRYwgaWP_nicepay-docs-logo.png
icon: {"faIcon":"fa-solid fa-circle-arrow-up"}
docTags:
createdAt: 2026-08-04T06:56:34.458Z
---
# Tentang Fail Transaction API
Fail Transaction API uses by Merchant to perform a reconciliation report on failed transaction in the NICEPAY system. Merchant gets list of the fail transaction data up to 5,000 data for every request compatible with the needed date.
:::Iframe{iframeHeight="0" code="Merchant should contact NICEPAY Customer Service by sending Merchant IP to proceed Whitelist process on NICEPAY side beforehand and request the API credential to use the Fail Transaction API."}
:::
# Settlement History API
| **API End Point** | [](https://bo.nicepay.co.id/transdt.do)[`bo.nicepay.co.id/failReport.do`](https://bo.nicepay.co.id/failReport.do) |
| ---------------------------------------------- | ------------------------------------------------------------------------------------------------------------------ |
| **Request Method **application/json | **POST** |
| **Description** | To check Fail Transaction report with NICEPAY via API |
| **Header** | `Content-Type: application/json` |
| **Request Format** | `application/json` |
:::hint{type="info"}
The available transaction value and settlement fund value in this report is using Rupiah currency.
:::
## Request Parameter
| **Parameter** | **Type** | **Length** | **Description** | **Example / Notes** |
| ------------------------------------------------------ | -------- | ---------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------- |
| `mid`
Required | VARCHAR2 | 10 | iMid Merchant | IONPAYTEST |
| `passwd`
Required | VARCHAR2 | 100 | Password gain after Whitelist IP process successfully registered and approved on NICEPAY side.
(Please contact **NICEPAY Customer Service team** for assistance). | 123456 |
| `date`
Required | VARCHAR2 | 8 | Transaction data date to be seen
Format: `YYYYMMDD` | 20260727 |
| `paymethod`
Required | VARCHAR2 | 2 | [Payment Method](docId\:Mo0VnUbHoIT0btlzcz9Bg) | 00 |
| `startno`
Required | NUMBER | 10 | The initial sequence number of the transaction data that will be seen (the first line of the requested data range. | 1
Default: 1 |
| `endno`
Required | NUMBER | 10 | The final sequence number of the transaction data that will be seen (the last line of the requested data range.
**Notes:**
Maximum range of data between
`startno`
and
`endno` are 5,000 data. | 100
Default: 100 |
## Response Parameter
| **Parameter** | **Tipe** | **Ukuran** | **Deskripsi** | **Contoh / Catatan** |
| ----------------------------------------------------------- | -------- | ---------- | ---------------------------------------------------------------------- | --------------------------------------- |
| `HEADER`
Required | Object | - | - | `"HEADER": { ... } ` |
| `CODE`
Required | NUMBER | 4 | [Header Code Response](docId\:Mo0VnUbHoIT0btlzcz9Bg) | 00 |
| `MID`
Required | VARCHAR2 | 10 | iMid Merchant | IONPAYTEST |
| `TRANS_DT`
Required | VARCHAR2 | 8 | The requested transaction data date
Format: `YYYYMMDD` | 20260727 |
| `DATA`
Required | Object | - | - | `"DATA": [ { ... } ] ` |
| `CODE`
Required | NUMBER | 2 | [Data Code Response](docId\:Mo0VnUbHoIT0btlzcz9Bg) | 10 |
| `TXID`
Required | VARCHAR2 | 30 | Transaction ID | IONPAYTEST01202607272022549895 |
| `ORDER_NO`
Required | VARCHAR2 | 8 | Merchant Reference Number | 99999 |
| `RESULT_CD`
Required | N | 4 | Result Code | 9151 |
| `RESULT_MSG`
Required | AN | 255 | Result Message | cardBin Information exist in blackList. |
| `TRANS_DT`
Required | VARCHAR2 | 8 | The requested transaction data date
Format: `YYYYMMDD` | 20260727 |
| `TRANS_TM`
Required | VARCHAR2 | 8 | Hour time from the requested transaction data
Format: `HHmmss` | 202321 |
| `BILLING_NM`
Required | A | 100 | Buyer Name | John Doe |
| `PAY_METHOD`
Required | VARCHAR2 | 2 | [Payment Method](docId\:Mo0VnUbHoIT0btlzcz9Bg) | 01 |
| `TRANS_AMT`
Required | NUMBER | 19,2 | Transaction Amount | 1000 |
| `BANK_CD`
Optional | VARCHAR2 | 4 | [Bank Code](docId\:Mo0VnUbHoIT0btlzcz9Bg) | CENA |
| `CUSTOMER_NO`
Required | VARCHAR2 | 40 | [Customer Account Transaction Number](docId\:Mo0VnUbHoIT0btlzcz9Bg) | 79150000\*\*\*\*\*\*\*\*8310 |
| `TAIL`
Required | Object | - | - | `"TAIL": { ... }` |
| `CODE`
Required | NUMBER | 4 | [Tail Code Response](docId\:Mo0VnUbHoIT0btlzcz9Bg)
Code Response | 99 |
| `MID`
Required | VARCHAR2 | 10 | iMid Merchant | IONPAYTEST |
| `TRANS_DT`
Required | VARCHAR2 | 8 | The requested transaction data date
Format: `YYYYMMDD` | 20260727 |
| `FAIL_TRANS_CNT`
Required | NUMBER | 10 | The sum of total fail transaction volume | 5 |
| `FAIL_TRANS_AMT`
Required | NUMBER | 19,2 | The sum of total fail transaction amount | 14000 |
## Sample Parameter
:::CodeblockTabs
Request Parameter
```json
{
"mid": "IONPAYTEST",
"passwd": "gpAFym0vGYmGIcPz5dVDyoKprI+Uul4miEH7LLiJiLUWfESSk1egsFhb82DHyRZhHwbqaFjij9hhUfBSUgm4Yg==",
"date": "20260727",
"paymethod": "00",
"startno": 1,
"endno": 1000
}
```
Response Parameter
```json
{
"HEADER": {
"CODE": "00",
"MID": "IONPAYTEST",
"TRANS_DT": "20260727"
},
"DATA": [
{
"CODE": "10",
"TXID": "IONPAYTEST01202607272022549895",
"ORDER_NO": "T212F0I7HJUODYN",
"RESULT_CD": "9151",
"RESULT_MSG": "cardBin Information exist in blackList.",
"TRANS_DT": "20260727",
"TRANS_TM": "202321",
"BILLING_NM": "John Doe",
"PAY_METHOD": "01",
"TRANS_AMT": 15725,
"CUSTOMER_NO": "45353524********3322"
},
{
"CODE": "10",
"TXID": "IONPAYTEST01202607271029583585",
"ORDER_NO": "P21KKCBYWK87667",
"RESULT_CD": "-",
"RESULT_MSG": "Server is busy. Please kindly try again in few minutes.",
"TRANS_DT": "20260727",
"TRANS_TM": "103102",
"BILLING_NM": "John Doe",
"PAY_METHOD": "01",
"TRANS_AMT": 83670,
"BANK_CD": "CENA",
"CUSTOMER_NO": "34353453********3445"
},
{
"CODE": "10",
"TXID": "IONPAYTEST01202607271029583585",
"ORDER_NO": "P21KKCBYWK87667",
"RESULT_CD": "9151",
"RESULT_MSG": "cardBin Information exist in blackList.",
"TRANS_DT": "20260727",
"TRANS_TM": "103023",
"BILLING_NM": "John Doe",
"PAY_METHOD": "01",
"TRANS_AMT": 83670,
"CUSTOMER_NO": "45353453********3453"
}
],
"TAIL": {
"CODE": "99",
"MID": "IONPAYTEST",
"TRANS_DT": "20260727",
"FAIL_TRANS_CNT": 3,
"FAIL_TRANS_AMT": 183065
}
}
```
:::