Transaction History API

6min

About Transaction History API
﻿
Transaction History 
﻿ uses for status reconciliation and transaction amount with 
﻿. 
﻿ gets list of 
﻿ data up to 5,000 data for every request compatible with 
﻿ needed date.
Merchant should contact <a style="color:blue;text-decoration-line:underline" href="mailto:[email protected]">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.
Merchant should contact <a style="color:blue;text-decoration-line:underline" href="mailto:cs@nicepay.co.id">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 
﻿GET﻿
Description
To check 
﻿ history with 
﻿ via 
﻿﻿
Header
Content-Type: application/json
Request Format
application/json
Request Parameter
Parameter
Type
Length
Description
Example / Note
mid
﻿Required﻿
VARCHAR2
10
iMid 
﻿ 
IONPAYTEST
passwd
﻿Required﻿
VARCHAR2
100
Password gain after Whitelist IP 
﻿ successfully registered on 
﻿ side
(
﻿ contact NICEPAY Customer Service team for assistance)
123456
transdt
﻿Required﻿
VARCHAR2
8
Transaction data date to be seen
Format: YYYYMMDD
20200101
startno
﻿Required﻿
NUMBER
10
The beginning of 
﻿ 
﻿ data that will be seen
1
Default: 1
endno
﻿Required﻿
NUMBER
10
The last of 
﻿ 
﻿ data that will be seen, maximum 5,000
100
Default: 100
Response Parameter
Parameter
Type
Length
Description
Example / Note
HEADER
﻿Required﻿
Object
-
-
"HEADER": {...}
CODE
﻿Required﻿
NUMBER
4
﻿Header Code Response﻿﻿
00
MID
﻿Required﻿
VARCHAR2
10
iMid 
﻿ 
IONPAYTEST
TRANS_DT
﻿Required﻿
VARCHAR2
8
The requested 
﻿ data date
Format: YYYYMMDD
20200101
DATA
﻿Required﻿
Object
-
-
"DATA": [
 { ... } ]
CODE
﻿Required﻿
NUMBER
4
﻿Data Code Response﻿﻿
10
TXID
﻿Required﻿
VARCHAR2
30
Transaction ID
IONPAYTEST01202001010010379759
ORDER_NO
﻿Required﻿
NUMBER
10
﻿
﻿ Reference Number
99999
TRANS_STATUS
﻿Required﻿
NUMBER
2
Transaction Status: Transaction Status Code﻿ 
0
TRANS_DT
﻿Required﻿
VARCHAR2
8
The requested 
﻿ data date
Format: YYYYMMDD
20200101
TRANS_TM
﻿Required﻿
VARCHAR2
8
Hour time from 
﻿ requested 
﻿ data
Format: HHmmss
001037
CANCEL_DT
﻿Required﻿
VARCHAR2
8
Transaction Cancellation Date
Format: YYYYMMDD
-
CANCEL_TM
﻿Required﻿
VARCHAR2
8
The cancellation 
﻿ time
Format: HHmmss
-
PAY_METHOD
﻿Required﻿
VARCHAR2
2
﻿Payment Method﻿﻿
01
TRANS_AMT
﻿Required﻿
NUMBER
19,2
Transaction Amount
10000
CUSTOMER_NO
﻿Required﻿
VARCHAR2
40
﻿
﻿ Account Transaction Number
123412**12341234
SETTLMNT_DT
﻿Required﻿
VARCHAR2
8
﻿
﻿ date, it will be shown directly if available
-
TAIL
﻿Required﻿
Object
-
-
"TAIL": { ... }
CODE
﻿Required﻿
NUMBER
4
﻿Tail Code Response﻿﻿
99
MID
﻿Required﻿
VARCHAR2
10
iMid 
﻿ 
IONPAYTEST
TRANS_DT
﻿Required﻿
VARCHAR2
8
The requested 
﻿ data date
Format: YYYYMMDD
20200101
APP_TRANS_CNT
﻿Required﻿
NUMBER
10
The sum of total 
﻿ volume
6
APP_TRANS_AMT
﻿Required﻿
NUMBER
19,2
The sum of total 
﻿ amount
290087
CC_TRANS_CNT
﻿Required﻿
NUMBER
10
The sum of total 
﻿ refund volume
0
CC_TRANS_AMT
﻿Required﻿
NUMBER
19,2
The sum of total amount 
﻿ refund
0
Sample Parameter
Request
Response
{
  "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
  }
}
{
  "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
  }
}
﻿
﻿

API End Point	https://bo.nicepay.co.id/transdt.do
Request Method	GET
Description	To check history with via
Header	Content-Type: application/json
Request Format	application/json

Parameter	Type	Length	Description	Example / Note
mid Required	VARCHAR2	10	iMid	IONPAYTEST
passwd Required	VARCHAR2	100	Password gain after Whitelist IP successfully registered on side ( contact NICEPAY Customer Service team for assistance)	123456
transdt Required	VARCHAR2	8	Transaction data date to be seen Format: YYYYMMDD	20200101
startno Required	NUMBER	10	The beginning of data that will be seen	1 Default: 1
endno Required	NUMBER	10	The last of data that will be seen, maximum 5,000	100 Default: 100

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

Updated 02 Oct 2024

Did this page help you?

API Business Report

Settlement History API

Transaction History API

About Transaction History API

Transaction History API

Request Parameter

Response Parameter

Sample Parameter

Welcome to NICEPAY DOCS