Inquiry List API

list inquiry api about list inquiry api this {{api}} uses to get a list of {{transaction}} s based on {{merchant}} seller id msid api end point /nicepay/direct/v2/listinquiry request method application/json application/json post post header content type application/json merchant token sha256 ( timestamp + imid + merchant key) request parameter for list inquiry parameter type size description example / notes timestamp required required n 14 {{api}} request date 20170708123456 msid required required an 30 {{merchant}} seller id 123 imid required required an 10 {{merchant}} id ionpaytest paymethod required required an 40 docid\ ek 0djw7nuhytcda4sa3p 05 fromdt required required n 8 query start date 20191201 todt required required n 8 query end date 20191231 merchanttoken required required an 64 {{merchant}} token 46a8219f2e5a903252bb173608ca4324cb25b964d0208625a2ea5 79b385d264a response parameter for list inquiry parameter type size description example / notes resultcd n 4 docid 2r5sr3xvppu1eju1nitg 0000 resultmsg an 255 result message docid 4 fpewlvczfhcvygxwck9 success txid an 30 transaction id ionpaytest05201912022223379276 referenceno ans 40 {{merchant}} order number ord20191202221283 amt n 12 amount 11000 fee n 12 fee reqdt n 8 transaction request date ( yyyymmdd ) 20160301 reqtm n 6 transaction request time ( hh24miss ) 135959 transdt n 8 transaction date ( yyyymmdd ) 20160303 transtm n 6 transaction time ( hh24miss ) 135959 goodsnm an 100 goods name test transaction billingnm a 100 billing name {{customer}} name status n 1 transaction status 0 approved 3 request 4 cancel 8 timeout 9 failed 5 reject before approved sample json for list inquiry api request { "timestamp" "20200306160251", "msid" "123", "imid" "ionpaytest", "paymethod" "05", "fromdt" "20191201", "todt" "20191231", "merchanttoken" "" } response { "resultcd" "0000", "resultmsg" "success", "trxcnt" "2", "trxlist" \[ { "txid" "ionpaytest05201912022223379276", "referenceno" "ord20191202221283", "amt" "11000", "fee" "", "reqdt" "20191202", "reqtm" "222430", "transdt" "20191202", "transtm" "222430", "goodsnm" "test transaction nicepay", "billingnm" "customer name", "status" "0" }, { "txid" "ionpaytest05201912022232599277", "referenceno" "ord20191202221261", "amt" "11000", "fee" "", "reqdt" "20191202", "reqtm" "223319", "transdt" "20191202", "transtm" "223319", "goodsnm" "test transaction nicepay", "billingnm" "customer name", "status" "0" } ] } inquiry detail api about inquiry detail api this {{api}} uses to check {{the}} {{status}} of batch {{order}} s api end point /nicepay/direct/v2/inquirydetail request method post post header content type application/json merchant token sha256 (timestamp + imid + referenceno+ amt + merchantkey) request parameter for inquiry detail parameter type size description example / notes timestamp required required n 14 {{api}} request date 20180810152800 txid required required an 30 transaction id bmritest0101201808101526233736 imid required required an 10 {{merchant}} id bmritest01 referenceno required required ans 40 {{merchant}} order number ordno2018715255268 amt required required n 12 transaction amount 1000 merchanttoken required required an 255 {{merchant}} token 5a859cf700880565ef7f69218c0efce5bd601766d7bb479e2302f74fdeb95c74 response parameter for inquiry detail parameter type size description example / notes count n 12 transaction count 3 transactions aoo transaction list json array acquirerdata array 20 a dynamic array consisting of a unique reference number rrn that is provided by {{the}} {{bank}} ing {{partner}} when a refund is {{process}} ed this reference number can be used by {{the}} {{customer}} to track {{the}} {{status}} of {{the}} refund with {{the}} {{bank}} "acquirerdata" { "rrn" "2399849" } sample json for inquiry detail api request { {"timestamp" "20180810152800", "merchanttoken" "5a859cf700880565ef7f69218c0efce5bd601766d7bb479e2302f74fdeb95c74", "referenceno" "ordno2018715255268", "amt" "1000", "txid" "bmritest0101201808101526233736", "imid" "bmritest01" } response { "count" 3, "transactions" \[ { "txid" "bmritest0101201808101526233736", "imid" "bmritest01", "currency" "idr", "amt" "1000", "instmntmon" "1", "instmnttype" "1", "referenceno" "ordno2018715255268", "goodsnm" null, "paymethod" "01", "billingnm" "honggildong", "billingphone" "021 579 00000", "billingemail" "no reply\@ionpay net", "billingaddr" "jalan jenderal gatot subroto kav 57", "billingcity" "jakarta", "billingstate" "jakarta", "billingpostcd" "12950", "billingcountry" "id", "deliverynm" "honggildong", "deliveryphone" "62 21 0000 0000", "deliveryaddr" "jalan jenderal gatot subroto kav 57", "deliverycity" "jakarta", "deliverystate" "jakarta", "deliverypostcd" "12950", "deliverycountry" "id", "vat" null, "fee" null, "notaxamt" null, "description" null, "merchanttoken" null, "reqdt" "20180810", "reqtm" "152623", "resultcd" "0000", "resultmsg" "paid", "merfixacctid" null, "vacctvaliddt" null, "vacctvalidtm" null, "status" "0", "vacctno" null, "bankcd" "bmri", "cardno" "483574 9802", "depositamt" null, "issubankcd" "hsbc", "preauthtoken" null, "mitracd" null, "payno" null, "receiptcode" "009942", "cancelamt" null, "transdt" "20180810", "transtm" "152726", "recurringtoken" "58412707a41c69e3142a3ce1d99a09afbf0b8bcd9513f1726e09aabe2e5a3ddd", "cctranstype" "1", "payvaliddt" null, "payvalidtm" null, "mrefno" null, "acqustatus" "00", "cardexpyymm" "2110", "issubanknm" "hsbc", "acqubanknm" "mandiri", "depositdt" null, "deposittm" null, "paymentexpdt" null, "paymentexptm" null, "paymenttrxsn" null, "canceltrxsn" null, "userid" null, "shopid" null, "partialflag" null, "cancelreferenceno" null, "ecivalue" "05", "acquirerdata" { "rrn" "332608321717" } }, { "txid" "bmritest0101201808101527134133", "imid" "bmritest01", "currency" "idr", "amt" "1000", "instmntmon" "1", "instmnttype" "1", "referenceno" null, "goodsnm" "t 1000", "paymethod" "01", "billingnm" "honggildong", "billingphone" "021 579 00000", "billingemail" "no reply\@ionpay net", "billingaddr" "jalan jenderal gatot subroto kav 57", "billingcity" "jakarta", "billingstate" "jakarta", "billingpostcd" "12950", "billingcountry" "id", "deliverynm" "honggildong", "deliveryphone" "62 21 0000 0000", "deliveryaddr" "jalan jenderal gatot subroto kav 57", "deliverycity" "jakarta", "deliverystate" "jakarta", "deliverypostcd" "12950", "deliverycountry" "id", "vat" null, "fee" null, "notaxamt" null, "description" null, "merchanttoken" null, "reqdt" "20180810", "reqtm" "152713", "resultcd" "0000", "resultmsg" "void", "merfixacctid" null, "vacctvaliddt" null, "vacctvalidtm" null, "status" "1", "vacctno" null, "bankcd" null, "cardno" null, "depositamt" null, "issubankcd" null, "preauthtoken" null, "mitracd" null, "payno" null, "receiptcode" null, "cancelamt" null, "transdt" "20180810", "transtm" "153805", "recurringtoken" null, "cctranstype" null, "payvaliddt" null, "payvalidtm" null, "mrefno" null, "acqustatus" null, "cardexpyymm" null, "issubanknm" "hsbc", "acqubanknm" "mandiri", "depositdt" null, "deposittm" null, "paymentexpdt" null, "paymentexptm" null, "paymenttrxsn" null, "canceltrxsn" null, "userid" null, "shopid" null, "partialflag" null, "cancelreferenceno" null, "ecivalue" null, "acquirerdata" { "rrn" "332608321717" } }, { "txid" "bmritest0101201808101538058789", "imid" "bmritest01", "currency" "idr", "amt" "1000", "instmntmon" "1", "instmnttype" "1", "referenceno" null, "goodsnm" "t 1000", "paymethod" "01", "billingnm" "honggildong", "billingphone" "021 579 00000", "billingemail" "no reply\@ionpay net", "billingaddr" "jalan jenderal gatot subroto kav 57", "billingcity" "jakarta", "billingstate" "jakarta", "billingpostcd" "12950", "billingcountry" "id", "deliverynm" "honggildong", "deliveryphone" "62 21 0000 0000", "deliveryaddr" "jalan jenderal gatot subroto kav 57", "deliverycity" "jakarta", "deliverystate" "jakarta", "deliverypostcd" "12950", "deliverycountry" "id", "vat" null, "fee" null, "notaxamt" null, "description" null, "merchanttoken" null, "reqdt" "20180810", "reqtm" "153805", "resultcd" "0000", "resultmsg" "void", "merfixacctid" null, "vacctvaliddt" null, "vacctvalidtm" null, "status" "1", "vacctno" null, "bankcd" null, "cardno" null, "depositamt" null, "issubankcd" null, "preauthtoken" null, "mitracd" null, "payno" null, "receiptcode" null, "cancelamt" null, "transdt" "20180810", "transtm" "153805", "recurringtoken" null, "cctranstype" null, "payvaliddt" null, "payvalidtm" null, "mrefno" null, "acqustatus" null, "cardexpyymm" null, "issubanknm" "hsbc", "acqubanknm" "mandiri", "depositdt" null, "deposittm" null, "paymentexpdt" null, "paymentexptm" null, "paymenttrxsn" null, "canceltrxsn" null, "userid" null, "shopid" null, "partialflag" "0", "cancelreferenceno" null, "ecivalue" null, } ] } transaction list parameter for transaction list parameter type size description example / notes resultcd n 4 docid 2r5sr3xvppu1eju1nitg 000 resultmsg an 255 result message docid 4 fpewlvczfhcvygxwck9 success txid an 30 transaction id (key from {{nicepay}} ) bmritest0101201808101526233736 imid an 10 {{merchant}} id bmritest01 referenceno ans 40 {{merchant}} order number (key from {{merchant}} ) ordno2018715255268 paymethod n 2 docid\ ek 0djw7nuhytcda4sa3p 01 {{cc}} amt n 12 {{paymentproduct}} amount 1000 currency an 3 currency idr reqdt n 8 transaction request date ( yyyymmdd ) 20160301 reqtm n 6 transaction request time ( hh24miss ) 135959 transdt n 8 transaction date ( yyyymmdd ) 20160303 transtm n 6 transaction time ( hh24miss ) 135959 goodsnm an 100 goods name {{merchant}} goods 1 billingnm an 100 buyer name honggildong billingphone n 15 buyer phone 021 579 00000 billingemail ans 40 buyer e mail no reply\@ionpay net billingaddr an 100 buyer address jalan jenderal gatot subroto kav 57 billingcity a 50 buyer city jakarta billingstate a 50 billing state jakarta billingpostcd n 10 billing post number 12950 billingcountry a 10 billing country id deliverynm a 30 delivery name honggildong deliveryphone n 15 delivery phone 62 21 0000 0000 deliveryaddr an 100 delivery address jalan jenderal gatot subroto kav 57 deliverycity a 50 delivery city jakarta deliverystate a 50 delivery state jakarta deliverypostcd n 10 delivery post code 12950 deliverycountry a 10 delivery country id bankcd an 4 docid\ qbeq29lj53z vbvxtvb7l bmri status n 1 transaction status 0 paid 1 void 2 refund 3 unpaid 4 expired (va, cvs, direct debit cancel) 8 fail (refer status code) 0 ecivalue n 2 card eci 05 issubankcd a 4 docid\ qbeq29lj53z vbvxtvb7l bmri acqubankcd a 4 docid\ qbeq29lj53z vbvxtvb7l bmri cardno an 20 card number with masking 483574 9802 cardexpyymm n 4 card expiry ( yymm ) 2110 instmntmon n 2 installment month 1 instmnttype n 2 docid\ wfsinjxqc2s9yubbybpep 1 preauthtoken an 255 pre auth token (need for capture for preauth only) ty23revc85452geg46hw33aaca6d17a33e4ad72cfc7c4c656hjt4 recurringtoken an 255 recurring token (can use next {{payment}} for recurring only) 412707a41c69e3142a3ce1d99a09afbf0b8bcd9513f1726e09aabe2e5a3ddd receiptcode n 6 receipt code null cctranstype an 2 docid 7pas vd5ylg4vdurmygwo 1 normal 2 recurring 3 pre auth 4 capture 1 acqustatus an 2 purchase status 00 not purchase 01 later cancel not purchase 10 finish purchase 99 etc 00 vat n 12 vat null fee n 12 s ervice fee null notaxamt n 12 t ax free amount null depositdt n 8 transaction request date ( yyyymmdd ) null deposittm n 6 transaction request time ( hh24miss ) null depositamt n 20 deposit amount null paymentexpdt n 6 {{paymentproduct}} expiry date ( yyyymmdd ) null paymentexptm n 6 {{paymentproduct}} expiry time ( hh24miss ) null paymenttrxsn n 32 qr {{paymentproduct}} expiry date ( yyyymmdd ) null canceltrxsn an 32 cancel transaction number null cancelamt n 12 cancel amount null userid an 128 user id hash null shopid an 32 shop id null partialflag a 4 partial flagging null cancelreferenceno ans 40 cancel reference number null mitracd a 4 docid 0upx1lyg1o2f4biu3ssp null mrefno an 20 {{bank}} reference number null sample json array for transaction list { "count" 3, "transactions" \[ { "txid" "bmritest0101201808101526233736", "imid" "bmritest01", "currency" "idr", "amt" "1000", "instmntmon" "1", "instmnttype" "1", "referenceno" "ordno2018715255268", "goodsnm" null, "paymethod" "01", "billingnm" "honggildong", "billingphone" "021 579 00000", "billingemail" "no reply\@ionpay net", "billingaddr" "jalan jenderal gatot subroto kav 57", "billingcity" "jakarta", "billingstate" "jakarta", "billingpostcd" "12950", "billingcountry" "id", "deliverynm" "honggildong", "deliveryphone" "62 21 0000 0000", "deliveryaddr" "jalan jenderal gatot subroto kav 57", "deliverycity" "jakarta", "deliverystate" "jakarta", "deliverypostcd" "12950", "deliverycountry" "id", "vat" null, "fee" null, "notaxamt" null, "description" null, "merchanttoken" null, "reqdt" "20180810", "reqtm" "152623", "resultcd" "0000", "resultmsg" "paid", "merfixacctid" null, "vacctvaliddt" null, "vacctvalidtm" null, "status" "0", "vacctno" null, "bankcd" "bmri", "cardno" "483574 9802", "depositamt" null, "issubankcd" "hsbc", "preauthtoken" null, "mitracd" null, "payno" null, "receiptcode" "009942", "cancelamt" null, "transdt" "20180810", "transtm" "152726", "recurringtoken" "412707a41c69e3142a3ce1d99a09afbf0b8bcd9513f1726e09aabe2e5a3ddd", "cctranstype" "1", "payvaliddt" null, "payvalidtm" null, "mrefno" null, "acqustatus" "00", "cardexpyymm" "2110", "issubanknm" "hsbc", "acqubanknm" "mandiri", "depositdt" null, "deposittm" null, "paymentexpdt" null, "paymentexptm" null, "paymenttrxsn" null, "canceltrxsn" null, "userid" null, "shopid" null, "partialflag" null, "cancelreferenceno" null, "ecivalue" "05" }, { "txid" "bmritest0101201808101527134133", "imid" "bmritest01", "currency" "idr", "amt" "1000", "instmntmon" "1", "instmnttype" "1", "referenceno" null, "goodsnm" "t 1000", "paymethod" "01", "billingnm" "honggildong", "billingphone" "021 579 00000", "billingemail" "no reply\@ionpay net", "billingaddr" "jalan jenderal gatot subroto kav 57", "billingcity" "jakarta", "billingstate" "jakarta", "billingpostcd" "12950", "billingcountry" "id", "deliverynm" "honggildong", "deliveryphone" "62 21 0000 0000", "deliveryaddr" "jalan jenderal gatot subroto kav 57", "deliverycity" "jakarta", "deliverystate" "jakarta", "deliverypostcd" "12950", "deliverycountry" "id", "vat" null, "fee" null, "notaxamt" null, "description" null, "merchanttoken" null, "reqdt" "20180810", "reqtm" "152713", "resultcd" "0000", "resultmsg" "void", "merfixacctid" null, "vacctvaliddt" null, "vacctvalidtm" null, "status" "1", "vacctno" null, "bankcd" null, "cardno" null, "depositamt" null, "issubankcd" null, "preauthtoken" null, "mitracd" null, "payno" null, "receiptcode" null, "cancelamt" null, "transdt" "20180810", "transtm" "153805", "recurringtoken" null, "cctranstype" null, "payvaliddt" null, "payvalidtm" null, "mrefno" null, "acqustatus" null, "cardexpyymm" null, "issubanknm" "hsbc", "acqubanknm" "mandiri", "depositdt" null, "deposittm" null, "paymentexpdt" null, "paymentexptm" null, "paymenttrxsn" null, "canceltrxsn" null, "userid" null, "shopid" null, "partialflag" null, "cancelreferenceno" null, "ecivalue" null }, { "txid" "bmritest0101201808101538058789", "imid" "bmritest01", "currency" "idr", "amt" "1000", "instmntmon" "1", "instmnttype" "1", "referenceno" null, "goodsnm" "t 1000", "paymethod" "01", "billingnm" "honggildong", "billingphone" "021 579 00000", "billingemail" "no reply\@ionpay net", "billingaddr" "jalan jenderal gatot subroto kav 57", "billingcity" "jakarta", "billingstate" "jakarta", "billingpostcd" "12950", "billingcountry" "id", "deliverynm" "honggildong", "deliveryphone" "62 21 0000 0000", "deliveryaddr" "jalan jenderal gatot subroto kav 57", "deliverycity" "jakarta", "deliverystate" "jakarta", "deliverypostcd" "12950", "deliverycountry" "id", "vat" null, "fee" null, "notaxamt" null, "description" null, "merchanttoken" null, "reqdt" "20180810", "reqtm" "153805", "resultcd" "0000", "resultmsg" "void", "merfixacctid" null, "vacctvaliddt" null, "vacctvalidtm" null, "status" "1", "vacctno" null, "bankcd" null, "cardno" null, "depositamt" null, "issubankcd" null, "preauthtoken" null, "mitracd" null, "payno" null, "receiptcode" null, "cancelamt" null, "transdt" "20180810", "transtm" "153805", "recurringtoken" null, "cctranstype" null, "payvaliddt" null, "payvalidtm" null, "mrefno" null, "acqustatus" null, "cardexpyymm" null, "issubanknm" "hsbc", "acqubanknm" "mandiri", "depositdt" null, "deposittm" null, "paymentexpdt" null, "paymentexptm" null, "paymenttrxsn" null, "canceltrxsn" null, "userid" null, "shopid" null, "partialflag" "0", "cancelreferenceno" null, "ecivalue" null } ] }