Transaction History API

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 transaction history api api end point https //bo nicepay co id/transdt do request method \<font color="#3b9f0f">post\</font> description to check history with via header content type application/json request format application/json request parameter parameter type length description example / note mid \<font color="#2166ae">required\</font> varchar2 10 imid ionpaytest passwd \<font color="#2166ae">required\</font> varchar2 100 password gain after whitelist ip successfully registered on side ( contact nicepay customer service team for assistance) 123456 transdt \<font color="#2166ae">required\</font> varchar2 8 transaction data date to be seen format yyyymmdd 20200101 startno \<font color="#2166ae">required\</font> number 10 the beginning of data that will be seen 1 default 1 endno \<font color="#2166ae">required\</font> 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 \<font color="#2166ae">required\</font> object "header" { } code \<font color="#2166ae">required\</font> number 4 header code response docid\ mo0vnubhoit0btlzcz9bg 00 mid \<font color="#2166ae">required\</font> varchar2 10 imid ionpaytest trans dt \<font color="#2166ae">required\</font> varchar2 8 the requested data date format yyyymmdd 20200101 data \<font color="#2166ae">required\</font> object "data" \[ { } ] code \<font color="#2166ae">required\</font> number 4 data code response docid\ mo0vnubhoit0btlzcz9bg 10 txid \<font color="#2166ae">required\</font> varchar2 30 transaction id ionpaytest01202001010010379759 order no \<font color="#2166ae">required\</font> number 10 reference number 99999 trans status \<font color="#2166ae">required\</font> number 2 t ransaction status transaction status code docid\ mo0vnubhoit0btlzcz9bg 0 trans dt \<font color="#2166ae">required\</font> varchar2 8 the requested data date format yyyymmdd 20200101 trans tm \<font color="#2166ae">required\</font> varchar2 8 hour time from requested data format hhmmss 001037 cancel dt \<font color="#2166ae">required\</font> varchar2 8 transaction cancellation date format yyyymmdd cancel tm \<font color="#2166ae">required\</font> varchar2 8 the cancellation time format hhmmss pay method \<font color="#2166ae">required\</font> varchar2 2 payment method docid\ mo0vnubhoit0btlzcz9bg 01 trans amt \<font color="#2166ae">required\</font> number 19,2 transaction amount 10000 customer no \<font color="#2166ae">required\</font> varchar2 40 account transaction number 123412 12341234 settlmnt dt \<font color="#2166ae">required\</font> varchar2 8 date, it will be shown directly if available tail \<font color="#2166ae">required\</font> object "tail" { } code \<font color="#2166ae">required\</font> number 4 tail code response docid\ mo0vnubhoit0btlzcz9bg 99 mid \<font color="#2166ae">required\</font> varchar2 10 imid ionpaytest trans dt \<font color="#2166ae">required\</font> varchar2 8 the requested data date format yyyymmdd 20200101 app trans cnt \<font color="#2166ae">required\</font> number 10 the sum of total volume 6 app trans amt \<font color="#2166ae">required\</font> number 19,2 the sum of total amount 290087 cc trans cnt \<font color="#2166ae">required\</font> number 10 the sum of total refund volume 0 cc trans amt \<font color="#2166ae">required\</font> number 19,2 the sum of total amount refund 0 sample parameter request { "mid" "ionpaytest", "passwd" "123456", "transdt" "20200101", "startno" "1", "endno" "5000" } 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 } }