Multiple Transactions Query

Query multiple transactions by date range

Request

Header

Item	Mandatory	Data Type	Sample	Description
Method	YES	String(5)	00000	Fill in 00000 (indefinite payment method)
ServiceType	YES	String(32)	OrderQuery	Selected Scan2Pay Service type
MchId	YES	String(32)	Account0001	Merchant ID provided by intella
TradeKey	YES	String(128)	sha256...hash	Marchant password provided by intella, this password must be encoded by SHA256
CreateTime	YES	String(14)	20180101120000	Request time, the format is "yyyyMMddHHmmss"

Data

Item	Mandatory	Data Type	Sample	Description
StartDate	YES	String(16)	20180101	Search start date, the format is "yyyyMMddHHmmss"
EndDate	YES	String(16)	20180102	Search end date, the format is "yyyyMMddHHmmss"
OrderStatus	YES	String(16)	1	0:In processing 1:Transaction success 2:Transaction failure
StoreOrderNo	NO	String(32)	PO1801	Keywords, has to be more than 3 characters

Response

Header

Item	Data Type	Sample	Description
StatusCode	String(4)	0000	Transaction Status Code
StatusDesc	String	Success	Description of transaction status
Method	String(5)	10100	Payment method code
ServiceType	String	OrderQuery	Selected Scan2Pay Service type
MchId	String	Account0001	Merchant ID
ResponseTime	String	20180101120000	Transaction response time, the format is "yyyyMMddHHmmss"

Data

Data will be responded in Array format

欄位	型別	範例	說明
SysOrderNo	String(32)	2018010110074205610	System order number
StoreOrderNo	PO180101001	PO180101001	Store order number
TotalFee	Integer	75	Transaction amount
FeeType	String(4)	TWD	Transaction currency, defaults to TWD
Description	String	Chickenchop	Product description
Status	String(16)	Trade success	Order status
RefundStatus	String(16)	Refund success	Refund status (Refund success / Refund fail)

RefundStatus field will not be responded if no refund has been claimed for this transaction

API Example

Request

{
  "Header": {
    "Method": "00000",
    "ServiceType": "OrderQuery",
    "MchId": "myMchId",
    "TradeKey": "9af15b336e6a9619928537df30b2e6a2376569fcf9d7e773eccede65606529a0",
    "CreateTime": "20180715105349"
  },
  "Data": "{\"StartDate\":\"20180715\",\"EndDate\":\"20180716\",\"OrderStatus\":\"1\"}"
}

Response

{
  "Header": {
    "StatusCode": "0000",
    "StatusDesc": "執行成功",
    "Method": "00000",
    "ServiceType": "OrderQuery",
    "MchId": "myMchId"
  },
  "Data": {
    "DataValue": [
      {
        "StoreOrderNo": "PO-20180715-004",
        "SysOrderNo": "104605",
        "TotalFee": 10,
        "FeeType": "TWD",
        "Status": "Trade success",
        "Description": "-7082"
      },
      {
        "StoreOrderNo": "PO-20180715-005",
        "SysOrderNo": "104644",
        "TotalFee": 10,
        "FeeType": "TWD",
        "Status": "Trade success",
        "RefundStatus": "Refund success",
        "Description": "Chicken Rice-0247"
      },
      {
        "StoreOrderNo": "PO-20180715-001",
        "SysOrderNo": "2018071544571196210",
        "TotalFee": 1,
        "FeeType": "TWD",
        "Status": "Trade success",
        "RefundStatus": "Refund success",
        "Description": "Chicken Rice-6485"
      },
      {
        "StoreOrderNo": "PO-20180715-002",
        "SysOrderNo": "J006536011807150001",
        "TotalFee": 1,
        "FeeType": "TWD",
        "Status": "Trade success",
        "Description": "Chicken Rice-1413"
      }
    ]
  }
}