Action 29: Search for Details of Transactions in Games

Function Description

Integrate details of game history transactions for all games and sort them by gType (game type).
- We query transactions of specified game types if request contains gTypes.
Search for a single parent ID’s details of game history settled transaction with a given time range (search by lastModifyTime).
The values of ss(seconds) in start time and end time must be 00.
The maximum time range for each search is 15 minutes, and the display time of the latest information is 3 minutes from request time. For example, if you search request at 15:00:00, the latest information available is between 14:56:00 and 14:57:00.
To obtain better response, specifying a time range less than 1 minute for each search is recommended.
The function searches for the data according to the last modified time of the game record. Therefore, if the number of transactions found and transaction data on the win/loss statement are not matching, that is because the record has not cleared yet in the time range you searched.
Provide game history transaction information within 2 hours. For transaction information older than 1 hours, please use “Action64”.
Each gambling game is considered as a transaction. When “hasGamble” is 1, it means that this is a gambling games transaction. Only JDB Bar(gType=9) games have gambling game.
- Example:
  1. If a player bets 10 and wins 100 points in the game
    bet = -10, gambleBet = 0, win = 100, total = 90, hasGamble = 0
  2. Same as above, if a player uses winning points to play gambling games and wins
    bet = 0, gambleBet = -100, win = 200, total = 100, hasGamble = 1
If the data is very huge, recommended to use the HTTP Compression to retrieve the data.

Parameter

Parameter	Format	Mandatory	Description
action	Integer	Y	29
ts	Long	Y	Current system time
parent	String(50)	Y	Agent ID
starttime	String(19)	Y	Start time of the searching range (dd - MM - yyyy HH: mm: ss)
endtime	String(19)	Y	End time of the searching range (dd - MM - yyyy HH: mm: ss)
gTypes	Integer Array	N	Game types See Game Provider

Example

{
  "action": 29,
  "ts": 1447452951820,
  "parent": "testag",
  "starttime": "08-12-2016 17:45:00",
  "endtime": "08-12-2016 17:46:00",
  "gTypes": [0,7]
}

Return Results

Parameter	Format	Description
status	String(4)	Success: 0000 Error: See Error Codes in Appendix `No Data: 0000`
data	JSON Array	`The returned data will vary by gType, listed in the following tables.`
err_text	String(255)	Error message

Betting records in slot games: gType = 0, 66, 90

Parameter	Format	Description
historyId	String(100)	Game History ID See Explanation of historyId
playerId	String(50)	Player ID
gType	Integer	Game types See Game Provider
mtype	Integer	Machine Types
gameDate	String(19)	Date of playing. (dd-MM-yyyy HH:mm:ss)
bet	Double	Bet amount
win	Double	Winning points in the game
total	Double	Total Win Loss
currency	String(10)	Currency types See Currency Code
jackpot	Double	The amount of the jackpot won
jackpotContribute	Double	Jackpot contributions
denom	Double	Bet denomination
lastModifyTime	String(19)	Last modified time
playerIp	String(50)	Player login IP
clientType	String(20)	Player login from website or mobile device.
hasFreegame	Integer	Free game 0: No 1: Yes
systemTakeWin	Integer	Mark this as the interruption if the game and it will be settled by the system. 0: No 1: Yes
beforeBalance	String(20)	Balance before playing
afterBalance	String(20)	Balance after playing

Betting records in fishing game: gType = 7, 67, 91

Parameter	Format	Description
historyId	String(100)	Game History ID See Explanation of historyId
playerId	String(50)	Player ID
gType	Integer	Game types See Game Provider
mtype	Integer	Machine Types
gameDate	String(19)	Date of playing. (dd-MM-yyyy HH:mm:ss)
roomType	Integer	Game Room -1: Lobby (Achievement Game) 0: Small Bet 1: Medium sized bet 2: Large bet `Real naming of game room differentiated by Machine Type`
currency	String(10)	Currency types See Currency Code
bet	Double	Bet amount
win	Double	Winning points in the game
total	Double	Total Win Loss
denom	Double	Bet denomination
beforeBalance	Double	Balance before playing
afterBalance	Double	Balance after playing
lastModifyTime	String(19)	Last modified time. (dd - MM - yyyy HH: mm: ss)
playerIp	String(50)	Player login IP
clientType	String(20)	Player login from website or mobile device

Betting records in Arcade games: gType = 9, 92

Parameter	Format	Description
historyId	String(100)	Game History ID See Explanation of historyId
playerId	String(50)	Player ID
gType	Integer	Game types See Game Provider
mtype	Integer	Machine Types
gameDate	String(19)	Date of playing. (dd-MM-yyyy HH:mm:ss)
bet	Double	Bet amount
gambleBet	Double	Bet amount in Gambling games
win	Double	Winning points in the game
total	Double	Total Win Loss
currency	String(10)	Currency types See Currency Code
denom	Double	Bet denomination
lastModifyTime	String(19)	Last modified time. (dd - MM - yyyy HH: mm: ss)
playerIp	String(50)	Player login IP
clientType	String(20)	Player login from website or mobile device
hasBonusGame	Integer	Bonus game 0: No 1: Yes
hasGamble	Integer	Gambling Game 0: No 1: Yes
beforeBalance	String(20)	Balance before playing
afterBalance	String(20)	Balance after playing

Betting records in Lottery Game: gType = 12

Parameter	Format	Description
historyId	String(100)	Game History ID See Explanation of historyId
playerId	String(50)	Player ID
gType	Integer	Game types See Game Provider
mtype	Integer	Machine Types
gameDate	String(19)	Date of playing. (dd-MM-yyyy HH:mm:ss)
bet	Double	Bet amount
win	Double	Winning points in the game
total	Double	Total Win Loss
currency	String(10)	Currency types See Currency Code
denom	Double	Bet denomination
lastModifyTime	String(19)	Last modified time. (dd - MM - yyyy HH: mm: ss)
playerIp	String(50)	Player login IP
clientType	String(20)	Player login from website or mobile device
hasBonusGame	Integer	Bonus game 0: No 1: Yes
beforeBalance	String(20)	Balance before playing
afterBalance	String(20)	Balance after playing

Betting records in Card Games: gType = 18, 93

Parameter	Format	Description
historyId	String(100)	Game History ID See Explanation of historyId
roundSeqNo	Long	Game round sequence number
playerId	String(50)	Player ID
gType	Integer	Game types See Game Provider
mtype	Integer	Machine Types
gameDate	String(19)	Date of playing. (dd-MM-yyyy HH:mm:ss)
bet	Double	Bet amount
win	Double	Winning points in the game
tax	Double	Player pay winning tax in the game
total	Double	Total Win Loss
currency	String(10)	Currency types See Currency Code
lastModifyTime	String(19)	Last modified time. (dd - MM - yyyy HH: mm: ss)
playerIp	String(50)	Player login IP
clientType	String(20)	Player login from website or mobile device
validBet	Double	Valid Bet Amount
beforeBalance	String(20)	Balance before playing
afterBalance	String(20)	Balance after playing

Betting records in SPRIBE, FC, AMB, SWG, MANCALA, YB, Onlyplay, CreedRoomz, ZestPlay, SmartSoft: gType = SPRIBE(22), FC(30, 31, 32), AMB(50), SWG(55, 56, 70), MANCALA(57, 75), YB(58, 59, 60), Onlyplay(80, 81), CreedRoomz(101), ZestPlay(120), SmartSoft(130, 131, 132)

Parameter	Format	Description
historyId	String(100)	Game History ID See Explanation of historyId
playerId	String(50)	Player ID
gType	Integer	Game types See Game Provider
mtype	Integer	Machine Types
gameDate	String(19)	Date of playing. (dd-MM-yyyy HH:mm:ss)
bet	Double	Bet amount
win	Double	Winning points in the game
total	Double	Total Win Loss
currency	String(10)	Currency types See Currency Code
lastModifyTime	String(19)	Last modified time. (dd - MM - yyyy HH: mm: ss)
beforeBalance	String(20)	Balance before playing
afterBalance	String(20)	Balance after playing

Betting records in HRG: gType = 41

Parameter	Format	Description
historyId	String(100)	Game History ID See Explanation of historyId
roundSeqNo	String(30)	Game round sequence number
playerId	String(50)	Player ID
gType	Integer	Game types See Game Provider
mtype	Integer	Machine Types
gameDate	String(19)	Date of playing. (dd-MM-yyyy HH:mm:ss)
bet	Double	Bet amount
win	Double	Winning points in the game
validBet	Double	Valid Bet Amount
commission	Double	Rebate
total	Double	Total Win Loss
currency	String(10)	Currency types See Currency Code
lastModifyTime	String(19)	Last modified time. (dd - MM - yyyy HH: mm: ss)
beforeBalance	String(20)	Balance before playing
afterBalance	String(20)	Balance after playing

Operation Sample

// Http Request
http://{API_Address}/apiRequest.do?dc=jb&x=udbFVt_xv0tsAmLDpz5Z3Ct4-p0gedUPdQO-UWsfd6PHz9Ky-wM3mIC9El4kwl_SlX3lpraVaCLnp-K0WsgKmpYTV9XpYncHzbtvn591qfaAwpGyOvsS4v1Yj7OvpRw_iU4554RuSsvHpI9jaj4XUgTK5yzbWKEddANjAAbxF0s=
 
 
// Http Response (success)
{
  "status":"0000",
  "data":[
    {
      "historyId":"5250145823902",
      "playerId":"test01",
      "gType":0,
      "mtype":8001,
      "gameDate":"06-06-2017 09:56:09",
      "bet":-0.4,"win":0.4,
      "total":0,
      "currency":"RB",
      "jackpot":0,
      "jackpotContribute":-0.002,
      "denom":0.02,
      "lastModifyTime":"06-06-2017 09:56:09",
      "playerIp":"10.20.6.86",
      "clientType":"WEB",
      "hasFreegame":0,
      "systemTakeWin":0,
      "beforeBalance": "8477.425",
      "afterBalance": "8477.425"
    },
    {
      "historyId":"5250228066060",
      "playerId": "test01",
      "gType": 0,
      "mtype": 14001,
      "gameDate": "18-07-2023 14:24:22",
      "bet": -1,
      "win": 2.3,
      "total": 1.3,
      "currency": "RB",
      "jackpot": 0,
      "jackpotContribute": -0.005,
      "denom": 0.05,
      "lastModifyTime": "18-07-2023 14:24:22",
      "playerIp": "10.20.6.86",
      "clientType": "WEB",
      "hasFreegame": 0,
      "hasGamble": 0,
      "gambleBet": 0,
      "systemTakeWin": 0,
      "beforeBalance": "8477.425",
      "afterBalance": "8478.725"
    },
    {
      "historyId":"43579741",
      "playerId":"test01",
      "gameDate":"07-06-2017 16:21:48",
      "gType":7,
      "mtype":7001,
      "roomType":1,
      "currency":"RB",
      "bet":-62.5,
      "win":19.75,
      "total":-42.75,
      "denom":5,
      "beforeBalance":200095.6,
      "afterBalance":200052.85,
      "lastModifyTime":"07-06-2017 16:21:55",
      "playerIp":"10.20.6.86",
      "clientType":"WEB"
    },
    {
      "historyId":"5250152072553",
      "playerId":"sbtmppl01",
      "gType":9,
      "mtype":9001,
      "gameDate":"25-07-2018 18:49:01",
      "bet":-90,
      "gambleBet":0,
      "win":20,
      "total":-70,
      "currency":"RB",
      "denom":1,
      "lastModifyTime":"25-07-2018 18:49:06",
      "playerIp":"10.20.9.250",
      "clientType":"WEB",
      "hasBonusGame":0,
      "hasGamble":0,
      "beforeBalance": "8477.425",
      "afterBalance": "8407.425"
    },
    {
      "historyId":"5250152072557",
      "playerId":"sbtmppl01",
      "gType":9,
      "mtype":9001,
      "gameDate":"25-07-2018 18:49:10",
      "bet":0,
      "gambleBet":-20,
      "win":40,
      "total":20,
      "currency":"RB",
      "denom":1,
      "lastModifyTime":"25-07-2018 18:49:15",
      "playerIp":"10.20.9.250",
      "clientType":"WEB",
      "hasBonusGame":0,
      "hasGamble":1,
      "beforeBalance": "8477.425",
      "afterBalance": "8497.425"
    },
    {
      "historyId":"5250147282661",
      "playerId":"gh2alice1",
      "gType":12,
      "mtype":12001,
      "gameDate":"14-05-2018 14:53:53",
      "bet":-0.08,
      "win":0.05,
      "total":-0.03,
      "currency":"TB",
      "denom":0.01,
      "lastModifyTime":"14-05-2018 14:53:53",
      "playerIp":"10.20.9.250",
      "clientType":"WEB",
      "hasBonusGame":0,
      "beforeBalance": "8477.425",
      "afterBalance": "8477.395"
    },
    {
      "historyId":"5250147282662",
      "playerId":"gh2alice1",
      "gType":12,
      "mtype":12001,
      "gameDate":"14-05-2018 14:53:57",
      "bet":-0.08,
      "win":0.05,
      "total":-0.03,
      "currency":"TB",
      "denom":0.01,
      "lastModifyTime":"14-05-2018 14:53:57",
      "playerIp":"10.20.9.250",
      "clientType":"WEB",
      "hasBonusGame":0,
      "beforeBalance": "8477.425",
      "afterBalance": "8477.395"
    },
    {
      "historyId":"5250155819867",
      "roundSeqNo":5558,
      "playerId":"test888",
      "gType":18,
      "mtype":18001,
      "gameDate":"13-07-2018 14:07:33",
      "bet":-2,
      "win":6,
      "tax":-0.3,
      "total":5.7,
      "currency":"TB",
      "lastModifyTime":"13-07-2018 14:07:33",
      "playerIp":"10.20.9.250",
      "clientType":"WEB",
      "validBet":-2,
      "beforeBalance": "8477.425",
      "afterBalance": "8483.125"
    },
    {
      "historyId":"5250155819872",
      "roundSeqNo":5559,
      "playerId":"test888",
      "gType":18,
      "mtype":18001,
      "gameDate":"13-07-2018 14:07:47",
      "bet":-8,
      "win":-8,
      "tax":0,
      "total":-8,
      "currency":"TB",
      "lastModifyTime":"13-07-2018 14:07:47",
      "playerIp":"10.20.9.250",
      "clientType":"WEB",
      "validBet":-8,
      "beforeBalance": "8477.425",
      "afterBalance": "8469.425"
    },
    {
      "historyId":"703514510",
      "playerId": "sbcpl03",
      "gType": 22,
      "mtype": 22001,
      "gameDate": "01-12-2021 17:12:16",
      "bet": -0.3,
      "win": 0,
      "total": -0.3,
      "currency": "TB",
      "lastModifyTime": "01-12-2021 17:12:16",
      "beforeBalance": "8477.425",
      "afterBalance": "8477.125"
    },
    {
      "historyId":"21231513",
      "playerId": "sbcpl03",
      "gType": 26,
      "mtype": 26001,
      "gameDate": "07-06-2022 13:56:52",
      "bet": -3.0,
      "win": 0.0,
      "total": -3.0,
      "currency": "RB",
      "lastModifyTime": "07-06-2022 13:56:52",
      "beforeBalance": "8477.425",
      "afterBalance": "8474.425"
    },
    {
      "historyId":"212315583",
      "playerId": "sbcpl03",
      "gType": 27,
      "mtype": 27017,
      "gameDate": "07-06-2022 15:25:21",
      "bet": -70.0,
      "win": 70.0,
      "total": 0.0,
      "currency": "RB",
      "lastModifyTime": "07-06-2022 15:25:21",
      "beforeBalance": "8477.425",
      "afterBalance": "8477.425"
    },
    {
      "historyId":"a45621c58wd",
      "playerId": "sbcpl03",
      "gType": 30,
      "mtype": 30001,
      "gameDate": "20-10-2022 15:33:41",
      "bet": -0.4,
      "win": 0.0,
      "total": -0.4,
      "currency": "RB",
      "lastModifyTime": "20-10-2022 15:33:41",
      "beforeBalance": "8477.425",
      "afterBalance": "8477.025"
    },
    {
      "historyId":"we1451fa3s1d",
      "playerId": "sbcpl03",
      "gType": 31,
      "mtype": 31003,
      "gameDate": "20-10-2022 15:34:15",
      "bet": -4.0,
      "win": 100.0,
      "total": 96.0,
      "currency": "RB",
      "lastModifyTime": "20-10-2022 15:34:15",
      "beforeBalance": "8477.425",
      "afterBalance": "9453.425"
    },
    {
      "historyId":"yc1451fa3s1d",
      "playerId": "sbcpl03",
      "gType": 32,
      "mtype": 32016,
      "gameDate": "20-10-2022 15:34:58",
      "bet": -0.5,
      "win": 0.0,
      "total": -0.5,
      "currency": "RB",
      "lastModifyTime": "20-10-2022 15:34:58",
      "beforeBalance": "8477.425",
      "afterBalance": "8476.925"
    },
    {
      "historyId":"584654231",
      "playerId": "sbcpl03",
      "gType": 50,
      "mtype": 50001,
      "gameDate": "03-05-2023 15:33:41",
      "bet": -0.4,
      "win": 0.0,
      "total": -0.4,
      "currency": "RB",
      "lastModifyTime": "03-05-2023 15:33:41",
      "beforeBalance": "8477.425",
      "afterBalance": "8477.025"
    },
    {
      "historyId":"tr458466a5we",
      "playerId": "sbcpl03",
      "gType": 55,
      "mtype": 55001,
      "gameDate": "08-06-2023 17:33:41",
      "bet": -0.8,
      "win": 0.0,
      "total": -0.8,
      "currency": "RB",
      "lastModifyTime": "08-06-2023 17:33:41",
      "beforeBalance": "8477.425",
      "afterBalance": "8476.825"
    },
    {
      "historyId":"wr451fd321g56",
      "playerId": "sbcpl03",
      "gType": 56,
      "mtype": 56001,
      "gameDate": "08-06-2023 17:33:41",
      "bet": -0.7,
      "win": 0.0,
      "total": -0.7,
      "currency": "RB",
      "lastModifyTime": "08-06-2023 17:33:41",
      "beforeBalance": "8477.425",
      "afterBalance": "8476.725"
    },
    {
      "historyId":"wer154s1cfq",
      "playerId": "mancalatest01",
      "gType": 57,
      "mtype": 57001,
      "gameDate": "08-08-2023 16:23:11",
      "bet": -1.75,
      "win": 1.75,
      "total": 0,
      "currency": "RB",
      "lastModifyTime": "08-08-2023 16:23:11",
      "beforeBalance": "8477.425",
      "afterBalance": "8477.425"
    },
    {
      "historyId":"1846626470",
      "playerId": "ybtest01",
      "gType": 58,
      "mtype": 58001,
      "gameDate": "12-10-2023 16:23:15",
      "bet": -6.0,
      "win": 4.8,
      "total": -1.2,
      "currency": "RB",
      "lastModifyTime": "12-10-2023 16:23:15",
      "beforeBalance": "8477.425",
      "afterBalance": "8476.225"
    },
    {
      "historyId":"1846626471",
      "playerId": "ybtest01",
      "gType": 59,
      "mtype": 59001,
      "gameDate": "12-10-2023 16:23:15",
      "bet": -6.0,
      "win": 4.8,
      "total": -1.2,
      "currency": "RB",
      "lastModifyTime": "12-10-2023 16:23:15",
      "beforeBalance": "8477.425",
      "afterBalance": "8476.225"
    },
    {
      "historyId":"1846626472",
      "playerId": "ybtest01",
      "gType": 60,
      "mtype": 60001,
      "gameDate": "12-10-2023 16:23:15",
      "bet": -6.0,
      "win": 4.8,
      "total": -1.2,
      "currency": "RB",
      "lastModifyTime": "12-10-2023 16:23:15",
      "beforeBalance": "8477.425",
      "afterBalance": "8476.225"
    },
    {
      "historyId":"525056886488",
      "playerId":"testpl01",
      "gType":66,
      "mtype":66001,
      "gameDate":"03-05-2019 16:34:29",
      "bet":-0.05,
      "win":0,
      "total":-0.05,
      "currency":"TB",
      "jackpot":0,
      "jackpotContribute":-0.00025,
      "denom":0.001,
      "lastModifyTime":"03-05-2019 16:34:29",
      "gameName":"",
      "playerIp":"10.20.9.250",
      "clientType":"WEB",
      "hasFreegame":0,
      "systemTakeWin":0,
      "beforeBalance": "8477.425",
      "afterBalance": "8477.375"
    },
    {
      "historyId":"5250568864780",
      "playerId":"testpl01",
      "gameDate":"03-05-2019 16:32:42",
      "gType":67,
      "mtype":67001,
      "roomType":0,
      "gameName":"",
      "currency":"TB",
      "bet":-0.22,
      "win":0,
      "total":-0.22,
      "denom":1,
      "beforeBalance":111656.22,
      "afterBalance":111656,
      "lastModifyTime":"03-05-2019 16:32:42",
      "playerIp":"10.20.9.250",
      "clientType":"WEB",
      "beforeBalance": "8477.425",
      "afterBalance": "8477.205"
    },
    {
        "historyId": "AAA-212256709",
        "roundSeqNo": "RND-0020107870010",
        "playerId": "testpl01",
        "gType": 41,
        "mtype": 41001,
        "gameDate": "14-11-2023 16:13:16",
        "bet": -500,
        "win": 0,
        "validBet": 0,
        "commission": 0,
        "total": -500,
        "currency": "RB",
        "lastModifyTime": "14-11-2023 16:14:04",
        "beforeBalance": "8477.425",
        "afterBalance": "7977.425"
    },
    {
      "historyId":"57762",
      "playerId": "zestplaytest01",
      "gType": 120,
      "mtype": 120001,
      "gameDate": "18-10-2024 16:23:15",
      "bet": -6.0,
      "win": 4.8,
      "total": -1.2,
      "currency": "RB",
      "lastModifyTime": "18-10-2024 16:23:15",
      "beforeBalance": "8477.425",
      "afterBalance": "8476.225"
    },
    {
      "historyId":"caa819bb-9a3f-40eb-8367-0271397037f3",
      "playerId": "smartsofttest01",
      "gType": 130,
      "mtype": 130001,
      "gameDate": "18-11-2024 16:23:15",
      "bet": -6.0,
      "win": 4.8,
      "total": -1.2,
      "currency": "RB",
      "lastModifyTime": "18-11-2024 16:23:15",
      "beforeBalance": "8477.425",
      "afterBalance": "8476.225"
    }
  ]
}
 
// Http Response (error)
{
  "status":"9005",
  "err_text":"Assertion(SAML) didn't pass the timestamp validation."
}
 
// Http Response (no data)
{
  "status":"0000",
  "data":[]
}

Action 61: Cash Transfer History (Including Rewards)Action 42: Daily Report