API_007 Get Transaction Records

POSThttps://prod.phl8268.com/panel/api/integration/getTransactionRecords

Endpoint to get transaction records from PHL.

Retrieve and return 1000 (configurable) at a time (based on time sequence in ascending order). This API will have to work together with API_008 Remove Transaction Records, or else it will always return earliest 1000 records.

Envelope

Please encode the following parameters into JSON, then encode them using Base64 and put them into the data field of a generic request/response. Signature: refer to Signature Description.

Request Schema

Property	Field Type	Mandatory	Description	Sample value
merchantCode	String	Y	Merchant code	PNLM000001

Response Schema

The response data is a List of ticket records.

Property	Field Type	Mandatory	Description	Sample value
orderId	String	Y	Order no.	20231016000001
username	String	Y	Username used from the platform	JOHNDOE
betCurrency	String	Y	Bet currency. See System Code – Currency	PHP
totalBetAmount	String	Y	Total bet amount	100.00
drawDate	String	Y	Draw date in ISO 8601 with offset. Format: yyyy-MM-dd'T'HH:mm:ss'+08:00'	2023-10-16T23:30:00+08:00
roundId	String	Y	Rounds of the game	1
status	String	Y	Status. See System Code – Status	POSTED
creationDate	String	Y	Transaction creation date in ISO 8601 with offset. Format: yyyy-MM-dd'T'HH:mm:ss'+08:00'	2023-10-16T23:00:25+08:00
updatedDate	String	Y	Transaction updated date in ISO 8601 with offset. Format: yyyy-MM-dd'T'HH:mm:ss'+08:00'	2023-10-16T23:00:25+08:00
bettings	List	Y	Each bet number in the ticket	Refer bettings

bettings

Property	Field Type	Mandatory	Description	Sample value
bettingId	String	Y	Bet unique ID	20230926000001001
siteCode	String	Y	Bet site code	PCSO
site	String	Y	Bet site	PCSO
gameType	String	Y	Game type	SWER3
betType	String	Y	Bet type. See System Code – Bet Type Code	S
betAmount	String	Y	Bet amount	10.00
betNumber	String	Y	Bet number	5,7,8
drawId	String	Y	Draw ID	2023092601
creationDate	String	Y	Betting creation date in ISO 8601 with offset. Format: yyyy-MM-dd'T'HH:mm:ss'+08:00'	2023-10-16T13:00:30+08:00
updatedDate	String	Y	Betting updated date in ISO 8601 with offset. Format: yyyy-MM-dd'T'HH:mm:ss'+08:00'	2023-10-16T13:00:30+08:00
bettingOdds	List	Y	Betting odds types	Refer bettingOdds

bettingOdds

Property	Field Type	Mandatory	Description	Sample value
code	String	Y	Code of odds	SWER3
odds	String	Y	The odds	450

Request Sample

{
  "merchantCode": "PNLM000003"
}

Response Sample

[
  {
    "orderId": "20231016000001",
    "username": "JOHNDOE",
    "betCurrency": "PHP",
    "totalBetAmount": "100.00",
    "drawDate": "2023-10-16T14:0:00+08:00",
    "roundId": "1",
    "status": "POSTED",
    "creationDate": "2023-10-16T13:01:35+08:00",
    "updatedDate": "2023-10-16T13:01:35+08:00",
    "bettings": [
      {
        "bettingId": "20230926000001001",
        "siteCode": "PCSO",
        "site": "PCSO",
        "gameType": "SWER3",
        "betType": "S",
        "betAmount": "60.00",
        "betNumber": "5,7,8",
        "drawId": "2023092601",
        "creationDate": "2023-10-16T13:00:30+08:00",
        "updatedDate": "2023-10-16T13:00:30+08:00",
        "bettingOdds": [
          {
            "code": "SWER3",
            "odds": "450"
          }
        ]
      },
      {
        "bettingId": "20230926000001002",
        "betSiteCode": "PCSO",
        "betSite": "PCSO",
        "gameType": "EZ2",
        "betType": "R",
        "betAmount": "40.00",
        "betNumber": "05,17",
        "drawId": "2023092601",
        "creationDate": "2023-10-16T13:00:30+08:00",
        "updatedDate": "2023-10-16T13:00:30+08:00",
        "bettingOdds": [
          {
            "code": "EZ2",
            "odds": "400"
          }
        ]
      }
    ]
  }
]