---
title: Transaction History API
slug: en/nicepay-api-laporan-bisnis-transaction-history-api
description: Information about Transaction History API from API Business Report available on the NICEPAY system
image: https://archbee-image-uploads.s3.amazonaws.com/ZHvSjR5ZrsoxwKbJa3xmo/rgujLNT1f1iZJvWieitYd_nicepay-docs-logo.png
icon: {"faIcon":"fa-solid fa-circle-arrow-up"}
docTags: 
createdAt: 2024-07-04T10:02:03.235Z
---

# About Transaction History API

***

Transaction History API uses for status reconciliation and transaction amount with NICEPAY. Merchant gets list of transaction data up to 5,000 data for every request compatible with the needed date.

:::Iframe{iframeHeight="0" code="Merchant should contact <a style=&#x22;color:blue;text-decoration-line:underline&#x22; href=&#x22;mailto:cs@nicepay.co.id&#x22;>NICEPAY Customer Service</a> by sending Merchant IP to proceed Whitelist process on NICEPAY side beforehand and request the API credential to use the Transaction History API."}

:::



# Transaction History API

***

| **API End Point**        | [](https://bo.nicepay.co.id/transdt.do)           |
| ------------------------ | ------------------------------------------------- |
| **Request Method&#x20;** | ****<font color="#3b9f0f">**POST**</font>****     |
| **Description**          | To check transaction history with NICEPAY via API |
| **Header**               | `Content-Type: application/json`                  |
| **Request Format**       | `application/json`                                |

## Request Parameter

| **Parameter**                                        | **Type** | **Length** | **Description**                                                                                                                                         | **Example / Note**    |
| ---------------------------------------------------- | -------- | ---------- | ------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------- |
| `mid`<br /><font color="#2166ae">Required</font>     | VARCHAR2 | 10         | iMid Merchant                                                                                                                                           | IONPAYTEST            |
| `passwd`<br /><font color="#2166ae">Required</font>  | VARCHAR2 | 100        | Password gain after Whitelist IP process successfully registered on NICEPAY side<br />(Please contact **NICEPAY Customer Service team** for assistance) | 123456                |
| `transdt`<br /><font color="#2166ae">Required</font> | VARCHAR2 | 8          | Transaction data date to be seen<br />Format: `YYYYMMDD`                                                                                                | 20200101              |
| `startno`<br /><font color="#2166ae">Required</font> | NUMBER   | 10         | The beginning of the transaction data that will be seen                                                                                                 | 1<br />Default: 1     |
| `endno`<br /><font color="#2166ae">Required</font>   | NUMBER   | 10         | The last of the transaction data that will be seen, maximum 5,000                                                                                       | 100<br />Default: 100 |

## Response Parameter

| **Parameter**                                              | **Type** | **Length** | **Description**                                                              | **Example / Note**             |
| ---------------------------------------------------------- | -------- | ---------- | ---------------------------------------------------------------------------- | ------------------------------ |
| `HEADER`<br /><font color="#2166ae">Required</font>        | Object   | -          | -                                                                            | `"HEADER": {...}`              |
| `CODE`<br /><font color="#2166ae">Required</font>          | NUMBER   | 4          | [Header Code Response](docId\:Mo0VnUbHoIT0btlzcz9Bg)                         | 00                             |
| `MID`<br /><font color="#2166ae">Required</font>           | VARCHAR2 | 10         | iMid Merchant                                                                | IONPAYTEST                     |
| `TRANS_DT`<br /><font color="#2166ae">Required</font>      | VARCHAR2 | 8          | The requested transaction data date<br />Format: `YYYYMMDD`                  | 20200101                       |
| `DATA`<br /><font color="#2166ae">Required</font>          | Object   | -          | -                                                                            | `"DATA": [  { ... } ]`         |
| `CODE`<br /><font color="#2166ae">Required</font>          | NUMBER   | 4          | [Data Code Response](docId\:Mo0VnUbHoIT0btlzcz9Bg)                           | 10                             |
| `TXID`<br /><font color="#2166ae">Required</font>          | VARCHAR2 | 30         | Transaction ID                                                               | IONPAYTEST01202001010010379759 |
| `ORDER_NO`<br /><font color="#2166ae">Required</font>      | NUMBER   | 10         | Merchant Reference Number                                                    | 99999                          |
| `TRANS_STATUS`<br /><font color="#2166ae">Required</font>  | NUMBER   | 2          | Transaction Status: [Transaction Status Code](docId\:Mo0VnUbHoIT0btlzcz9Bg)  | 0                              |
| `TRANS_DT`<br /><font color="#2166ae">Required</font>      | VARCHAR2 | 8          | The requested transaction data date<br />Format: `YYYYMMDD`                  | 20200101                       |
| `TRANS_TM`<br /><font color="#2166ae">Required</font>      | VARCHAR2 | 8          | Hour time from the requested transaction data<br />Format: `HHmmss`          | 001037                         |
| `CANCEL_DT`<br /><font color="#2166ae">Required</font>     | VARCHAR2 | 8          | Transaction Cancellation Date<br />Format: `YYYYMMDD`                        | -                              |
| `CANCEL_TM`<br /><font color="#2166ae">Required</font>     | VARCHAR2 | 8          | The cancellation transaction time<br />Format: `HHmmss`                      | -                              |
| `PAY_METHOD`<br /><font color="#2166ae">Required</font>    | VARCHAR2 | 2          | [Payment Method](docId\:Mo0VnUbHoIT0btlzcz9Bg)                               | 01                             |
| `TRANS_AMT`<br /><font color="#2166ae">Required</font>     | NUMBER   | 19,2       | Transaction Amount                                                           | 10000                          |
| `CUSTOMER_NO`<br /><font color="#2166ae">Required</font>   | VARCHAR2 | 40         | Customer Account Transaction Number                                          | 123412\*\*12341234             |
| `SETTLMNT_DT`<br /><font color="#2166ae">Required</font>   | VARCHAR2 | 8          | Settlement date, it will be shown directly if available                      | -                              |
| `TAIL`<br /><font color="#2166ae">Required</font>          | Object   | -          | -                                                                            | `"TAIL": { ... }`              |
| `CODE`<br /><font color="#2166ae">Required</font>          | NUMBER   | 4          | [Tail Code Response](docId\:Mo0VnUbHoIT0btlzcz9Bg)                           | 99                             |
| `MID`<br /><font color="#2166ae">Required</font>           | VARCHAR2 | 10         | iMid Merchant                                                                | IONPAYTEST                     |
| `TRANS_DT`<br /><font color="#2166ae">Required</font>      | VARCHAR2 | 8          | The requested transaction data date<br />Format: `YYYYMMDD`                  | 20200101                       |
| `APP_TRANS_CNT`<br /><font color="#2166ae">Required</font> | NUMBER   | 10         | The sum of total transaction volume                                          | 6                              |
| `APP_TRANS_AMT`<br /><font color="#2166ae">Required</font> | NUMBER   | 19,2       | The sum of total transaction amount                                          | 290087                         |
| `CC_TRANS_CNT`<br /><font color="#2166ae">Required</font>  | NUMBER   | 10         | The sum of total transaction refund volume                                   | 0                              |
| `CC_TRANS_AMT`<br /><font color="#2166ae">Required</font>  | NUMBER   | 19,2       | The sum of total amount transaction refund                                   | 0                              |

## Sample Parameter

:::CodeblockTabs
Request

```json
{
    "mid":"IONPAYTEST",
    "passwd":"123456",
    "transdt":"20200101",
    "startno":"1",
    "endno":"5000"
}
```

Response

```json
{
  "HEADER": {
    "CODE": "00",
    "MID": "IONPAYTEST",
    "TRANS_DT": "20200101"
  },
  "DATA": [
    {
      "CODE": "10",
      "TXID": "IONPAYTEST01202001010010379759",
      "ORDER_NO": "99999",
      "TRANS_STATUS": "0",
      "TRANS_DT": "20200101",
      "TRANS_TM": "001037",
      "CANCEL_DT": "-",
      "CANCEL_TM": "-",
      "PAY_METHOD": "01",
      "TRANS_AMT": 10000,
      "CUSTOMER_NO": "123412******12341234",
      "SETTLMNT_DT": "-"
    },
    {
      "CODE": "10",
      "TXID": "IONPAYTEST01202001010015131172",
      "ORDER_NO": "99999",
      "TRANS_STATUS": "0",
      "TRANS_DT": "20200101",
      "TRANS_TM": "001513",
      "CANCEL_DT": "-",
      "CANCEL_TM": "-",
      "PAY_METHOD": "01",
      "TRANS_AMT": 10000,
      "CUSTOMER_NO": "123412******12341234",
      "SETTLMNT_DT": "-"
    },
    {
      "CODE": "10",
      "TXID": "IONPAYTEST01202001010950206003",
      "ORDER_NO": "T2148P7ZU8GXADB",
      "TRANS_STATUS": "0",
      "TRANS_DT": "20200101",
      "TRANS_TM": "095019",
      "CANCEL_DT": "-",
      "CANCEL_TM": "-",
      "PAY_METHOD": "01",
      "TRANS_AMT": 65018,
      "CUSTOMER_NO": "111133******5555",
      "SETTLMNT_DT": "-"
    },
    {
      "CODE": "10",
      "TXID": "IONPAYTEST01202001010950256020",
      "ORDER_NO": "T210LX4NZ3F7N35",
      "TRANS_STATUS": "0",
      "TRANS_DT": "20200101",
      "TRANS_TM": "095025",
      "CANCEL_DT": "-",
      "CANCEL_TM": "-",
      "PAY_METHOD": "01",
      "TRANS_AMT": 29018,
      "CUSTOMER_NO": "111112******12222111",
      "SETTLMNT_DT": "-"
    },
    {
      "CODE": "10",
      "TXID": "IONPAYTEST05202001011020342509",
      "ORDER_NO": "T21FZF8IBZAE1OM",
      "TRANS_STATUS": "0",
      "TRANS_DT": "20200101",
      "TRANS_TM": "102034",
      "CANCEL_DT": "-",
      "CANCEL_theTM": "-",
      "PAY_METHOD": "05",
      "TRANS_AMT": 29018,
      "CUSTOMER_NO": "-",
      "SETTLMNT_DT": "-"
    },
    {
      "CODE": "10",
      "TXID": "IONPAYTEST02202001011041357152",
      "ORDER_NO": "T21VQB05AP8KS7O",
      "TRANS_STATUS": "0",
      "TRANS_DT": "20200101",
      "TRANS_TM": "104306",
      "CANCEL_DT": "-",
      "CANCEL_TM": "-",
      "PAY_METHOD": "02",
      "TRANS_AMT": 147033,
      "CUSTOMER_NO": "70014000091041357152",
      "SETTLMNT_DT": "-"
    }
  ],
  "TAIL": {
    "CODE": "99",
    "MID": "IONPAYTEST",
    "TRANS_DT": "20200101",
    "APP_TRANS_CNT": 6,
    "APP_TRANS_AMT": 290087,
    "CC_TRANS_CNT": 0,
    "CC_TRANS_AMT": 0
  }
}
```
:::