New Multiple Transactions Query

New query multiple transactions by date range

Description

The debit transaction and refund transaction are two records according to the date of transaction. So perhaps it's may be listed on different dates. The debit transaction amount is positive and the refund transaction amount is negative.

Request

Header

Item	Mandatory	Data Type	Sample	Description
Method	YES	String(5)	00000	Fill in 00000 (indefinite payment method)
ServiceType	YES	String(32)	OrderQuery1.1	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"
AccoundId	NO	String(30)	store0001	Account ID of directly-managed stores or franchise stores
StoreType	NO	Int(2)	1	1: Headquarters 3: Directly-managed stores

Response

Header

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

Data

Data will be responded in Array format

Item	Data Type	Sample	Description
TranDate	String(16)	20020228	Date of transaction
TranDayTime	String(16)	003018	Time of transaction
AccountId	String(30)	account99	Account ID
StoreType	String(30)	Directly-managed stores	Type of store
Name	String(30)	intella	Name of store
BrandName	String(30)	intella	Name of Brand
SysOrderNo	String(64)	2018010110074205610	System order no.
Method	String(10)	LINE Pay	Payment method
ItemName	String(100)	Green Tea	Item name
StoreOrderNo	String(20	PO180101001	Store order no.
Status	String(20)	Trade success	Status of transaction
Amount	Int(12)	100	Amount of transaction
UserId	String(50)	36100052307809999	Number of card
LinePayMethod	String(30)	Credit card Payment	Payment method of line pay

API Example

Request

{
   "Header": {
      "Method": "00000",
      "ServiceType": "OrderQuery1.1",
      "MchId": "super",
      "CreateTime": "20200326152331",
      "TradeKey": "9af15b336e6a9619928537df30b2e6a2376569fcf9d7e773eccede65606529a0"
   },
   "Data": "{
      "StartDate": "20200324",
      "EndDate": "20200326",
      "AccoundId": "super",
      "StoreType": 1,
   }
}

Response

{
    "Header": {
        "StatusCode": "0000",
        "StatusDesc": "Success",
        "Method": "00000",
        "ServiceType": "OrderQuery1.1",
        "MchId": "Account0001",
        "ResponseTime": "20200326113716"
    },
    "Data": {
        "list": [
            {
                "Status": "Trade success",
                "AccountId": "super",
                "TranDate": "20200326",
                "Amount": 1,
                "LinePayMethod": "Credit Card Payment",
                "StoreOrderNo": "4BF0020032600001",
                "Method": "LINE Pay",
                "Name": "intella",
                "BrandName": "",
                "StoreType": "Directly-managed stores",
                "TranDayTime": "093331",
                "ServiceType": "OLPay",
                "SysOrderNo": "2020032654781817810",
                "UserId": 15400,
                "ItemName": "intella-4831"
            },
            {
                "Status": "Refund success",
                "AccountId": "super",
                "TranDate": "20200325",
                "Amount": -10,
                "LinePayMethod": "Credit Card",
                "StoreOrderNo": "4BF0020032500002",
                "Method": "LINE Pay",
                "Name": "intella",
                "BrandName": "intella",
                "StoreType": "Directly-managed stores",
                "TranDayTime": "163350",
                "ServiceType": "OLPay",
                "SysOrderNo": "2020032554684970010",
                "UserId": 15401,
                "ItemName": "Green Tea"
            }
        ]
    }
}

{
    "Header": {
        "StatusCode": "8002",
        "StatusDesc": "Incorrect data format"
    },
    "Data": {}
}