Query Order(Batch)
Order pagination master search
Introduction
Order pagination master search
API Description
Request Method:POST
Request Path:open/api/payment/queryList
Request Parameter
| Parameter | Sign | Mandatory | Type | Length | Remarks |
|---|---|---|---|---|---|
| appId | Y | Y | string | 64 | merchant appid |
| merchantOrderNoList | Y | N | List | 100 | Order number; Maximum order quantity: 100 |
| createTimeStart | Y | Y | string | 19 | Order creation start time UTC+8 yyyy-MM-dd HH:mm:ss |
| createTimeEnd | Y | Y | string | 19 | Order creation end time UTC+8 yyyy-MM-dd HH:mm:ss |
| pageSize | Y | N | string | 3 | Number per page: If left blank, the default value is 10; maximum allowed is 100. |
| pageIndex | Y | N | string | 3 | Query page number; if left blank, the default value is 1. |
| sign | N | Y | string | 512 | sign |
{
"appId": "XXXXXXX",
"sign": "E1D5BF09B3E5DDBAA2F13AC1F2B166D49397602BDD2C0427110B9FE37C5DC0094990C1E3D79942B662FD7D235F276B77704C0BB40493D5E5EBC58257708F2A8E",
"merchantOrderNoList": ["1223","232","2323"],
"createTimeStart": "2026-01-10 15:32:37",
"createTimeEnd": "2026-01-12 15:32:49",
"pageSize": 10,
"pageIndex": 1
}Response Parameter
| Parameter | Type | Length | Remarks |
|---|---|---|---|
| success | boolean | / | Mark of success |
| error | boolean | / | Mark of error |
| code | long | / | Response code |
| msg | string | / | Response message |
| traceId | String | / | TraceId |
| model | Object | / | |
| └startIndex | Int | / | |
| └sumPage | Int | / | |
| └lastPage | Boolean | / | |
| └pageNo | Int | / | |
| └pageSize | Int | / | |
| └sumRow | Int | / | |
| └data | object | / | Response content |
| └─orderNo | String | 64 | AEON order number |
| └─orderStatus | String | 32 | Order status |
| └─userId | String | 128 | User ID(email or phone number) |
| └─userIp | String | 128 | User IP address |
| └─usdAmount | String | 32 | Order amount count as USD |
| └─fiatAmount | String | 32 | Order amount count as local fiat |
| └─fiatCurrency | String | 32 | Fiat currency of user paid |
| └─fiatRate | String | 16 | Fiat currency exchange rate to USD |
| └─fee | String | 16 | Transaction fee count as USD (retains eight digits ) |
| └─qrCode | String | 128 | QRcode address |
| └─merchantOrderNo | String | 64 | Merchant order number (uniqle) |
| └─failReason | string | 256 | Failure reason |
| └─hash | string | 256 | Transaction hash |
| └─refundHash | string | 256 | Refund hash |
| └─orderTime | string | 64 | UTC+8 time zone, formatted as yyyy-MM-dd hh:mm:ss |
Order Status
| Code | Details |
|---|---|
| INIT | Order Created Successfully |
| PENDING | Processing Order |
| SUCCESS | Payment success |
| FAIL | Payment failure |
| ERROR | Order Creation Failed |
| TIMEOUT | TIMEOUT |
| COLLECTION_FAILED | Channel payment failure (for MXN,NGN) |
Success Example
{
"code": "0",
"msg": "success",
"model": {
"startIndex": 0,
"sumPage": 1,
"data": [
{
"usdAmount": "0.60726824",
"fiatRate": "0.000037954265",
"orderNo": "XXXXX852362730072",
"fee": null,
"orderStatus": "FAILED",
"merchantOrderNo": "XXXXX695",
"userId": "[email protected]",
"orderTime": "2025-10-10 16:33:56",
"qrCode": "000201010211XXXXX6000697041501121170028740400208QRIBFTTA53037045802VN63048A1C",
"fiatAmount": "16000",
"fiatCurrency": "VND",
"userIp": "XX.XX.XX.XX",
"failReason": null,
"refundHash": null,
"hash": null
},
{
"usdAmount": "0.60726824",
"fiatRate": "0.000037954265",
"orderNo": "XXXXX5036290074",
"fee": null,
"orderStatus": "FAILED",
"merchantOrderNo": "XXXXX87627",
"userId": "[email protected]",
"orderTime": "2025-10-10 16:38:24",
"qrCode": "0002010102XXXXXXX0126000697041501121170028740400208QRIBFTTA53037045802VN63048A1C",
"fiatAmount": "16000",
"fiatCurrency": "VND",
"userIp": "XX.XX.XX.XX",
"failReason": null,
"refundHash": null,
"hash": null
},
{
"usdAmount": "0.60736045",
"fiatRate": "0.000037960028",
"orderNo": "XXXXX01960075",
"fee": null,
"orderStatus": "FAILED",
"merchantOrderNo": "XXXXX4519",
"userId": "[email protected]",
"orderTime": "2025-10-10 16:39:10",
"qrCode": "000201XXXXXXXX0697041501121170028740400208QRIBFTTA53037045802VN63048A1C",
"fiatAmount": "16000",
"fiatCurrency": "VND",
"userIp": "XX.XX.XX.XX",
"failReason": null,
"refundHash": null,
"hash": null
}
],
"lastPage": true,
"pageNo": 1,
"pageSize": 10,
"sumRow": 3
},
"traceId": "683fc7ba0fc57a534dc308957768f503",
"success": true,
"error": falseUpdated about 20 hours ago
