Action 64: Search for Old 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
.
- We query transactions of specified game types if request contains
- 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 5 minutes.
- To obtain better response when huge data and heavy traffic, specifying a time range less than 1 minute for each search is recommended.
- The function searches for the data according to the game date 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 between 1 hour and 60 days.
- 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:
- If a player bets 10 and wins 100 points in the game
bet = -10, gambleBet = 0, win = 100, total = 90, hasGamble = 0 - 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 a player bets 10 and wins 100 points in the game
Parameter
Parameter | Format | Mandatory | Description |
---|---|---|---|
action | Integer | Y | 64 |
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": 64,
"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 be 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 ⚠️ The system is scheduled to update the field to String(200) in the test environment on Aug 21, 2025, and will be gradually rolled out to the production environment on Aug 26, 2025. |
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 IPfields may be empty |
clientType | String(20) | Player login from website or mobile device.fields may be empty |
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 ⚠️ The system is scheduled to update the field to String(200) in the test environment on Aug 21, 2025, and will be gradually rolled out to the production environment on Aug 26, 2025. |
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 ⚠️ The system is scheduled to update the field to String(200) in the test environment on Aug 21, 2025, and will be gradually rolled out to the production environment on Aug 26, 2025. |
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 ⚠️ The system is scheduled to update the field to String(200) in the test environment on Aug 21, 2025, and will be gradually rolled out to the production environment on Aug 26, 2025. |
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 ⚠️ The system is scheduled to update the field to String(200) in the test environment on Aug 21, 2025, and will be gradually rolled out to the production environment on Aug 26, 2025. |
roundSeqNo | String(100) | Game round sequence number ⚠️ The system is scheduled to update the field to String(200) in the test environment on Aug 21, 2025, and will be gradually rolled out to the production environment on Aug 26, 2025. |
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 IPfields may be empty |
clientType | String(20) | Player login from website or mobile device.fields may be empty |
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, FUNKY GAMES, Aviatrix, SWGS, CP: 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), FUNKY GAMES(140, 141, 142), Aviatrix(150), SWGS(160, 161, 162), CP(200, 201)
Parameter | Format | Description |
---|---|---|
historyId | String(100) | Game History ID ⚠️ The system is scheduled to update the field to String(200) in the test environment on Aug 21, 2025, and will be gradually rolled out to the production environment on Aug 26, 2025. |
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 ⚠️ The system is scheduled to update the field to String(200) in the test environment on Aug 21, 2025, and will be gradually rolled out to the production environment on Aug 26, 2025. |
roundSeqNo | String(100) | Game round sequence number ⚠️ The system is scheduled to update the field to String(200) in the test environment on Aug 21, 2025, and will be gradually rolled out to the production environment on Aug 26, 2025. |
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-p0gedUPdQOUWsfd6PHz9Ky-wM3mIC9El4kwl_SlX3lpraVaCLnpK0WsgKmpYTV9XpYncHzbtvn591qfaAwpGyOvsS4v1Yj7OvpRw_iU4554RuSsvHpI9jaj4XUgTK5yzb
WKEddANjAAbxF0s=
// 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,
"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": "test01",
"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": "test01",
"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": "test01",
"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": "test01",
"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": "58436132",
"playerId": "test01",
"gType": 22,
"mtype": 22004,
"gameDate": "07-12-2021 17:46:18",
"bet": -50,
"win": 60,
"total": 10,
"currency": "TB",
"lastModifyTime": "07-12-2021 17:46:18",
"beforeBalance": "8477.425",
"afterBalance": "8477.125"
},
{
"historyId": "8643315",
"playerId": "test01",
"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": "984313",
"playerId": "test01",
"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": "asf135456b4gt",
"playerId": "test01",
"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": "iu4541gf6v",
"playerId": "test01",
"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": "y74u6854v1a",
"playerId": "test01",
"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": "8543321651",
"playerId": "test01",
"gType": 50,
"mtype": 50001,
"gameDate": "02-05-2023 15:33:41",
"bet": -0.4,
"win": 0.0,
"total": -0.4,
"currency": "RB",
"lastModifyTime": "02-05-2023 15:33:41",
"beforeBalance": "8477.425",
"afterBalance": "8477.025"
},
{
"historyId": "uy4i654132x",
"playerId": "test01",
"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": "qwr1531fb",
"playerId": "test01",
"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": "erwt14651vd35",
"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": "53818221",
"playerId": "testpl01",
"gType": 101,
"mtype": 101001,
"gameDate": "27-06-2024 18:15:24",
"bet": -2.0,
"win": 4.0,
"total": 2.0,
"currency": "RB",
"lastModifyTime": "27-06-2024 18:15:24",
"afterBalance": "100009.9993",
"beforeBalance": "100007.9993"
},
{
"historyId": "57762",
"playerId": "test01",
"gType": 120,
"mtype": 120001,
"gameDate": "18-10-2024 16:23:15",
"bet": -0.4,
"win": 0.0,
"total": -0.4,
"currency": "RB",
"lastModifyTime": "18-10-2024 16:23:15",
"beforeBalance": "8477.425",
"afterBalance": "8477.025"
},
{
"historyId": "02b1446f-b6a6-4f1f-8859-ca78545228fd",
"playerId": "test01",
"gType": 130,
"mtype": 130001,
"gameDate": "18-11-2024 16:23:15",
"bet": -5.0,
"win": 0.0,
"total": -5.0,
"currency": "RB",
"lastModifyTime": "18-11-2024 16:23:15",
"beforeBalance": "8477.425",
"afterBalance": "8472.425"
},
{
"historyId": "02b1446f-b6a6-4f1f-8859-ca78545228fd",
"playerId": "test01",
"gType": 160,
"mtype": 160001,
"gameDate": "18-11-2024 16:23:15",
"bet": -5.0,
"win": 0.0,
"total": -5.0,
"currency": "RB",
"lastModifyTime": "18-11-2024 16:23:15",
"beforeBalance": "8477.425",
"afterBalance": "8472.425"
}
]
}
// Http Response (error)
{
"status":"9005",
"err_text":"Assertion(SAML) didn't pass the timestamp validation."
}
// Http Response (no data)
{
"status":"0000",
"data":[]
}