API_009 Get Settled Transaction Records

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

Endpoint for merchant to get settled transaction records and bet number along with winning record (if any).

Retrieve and return 1000 (configurable) at a time (based on time sequence in ascending order). This API will have to work together with API_010 Remove Settled 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 settled ticket records.

Property	Field Type	Mandatory	Description	Sample value
orderId	String	Y	Order no.	20230414000001
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	20230609095201001
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	20230512001001
winStatus	Boolean	Y	Betting win status	true
drawResult	String	Y	Draw result number. Empties indicate result not yet approved.	5,7,8
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
bettingOdds	List	Y	Betting odds types	Refer bettingOdds
winningDetails	List	Y	Winning type and amount	Refer winningDetails

bettingOdds

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

winningDetails

Property	Field Type	Mandatory	Description	Sample value
code	String	Y	Code of odds	SWER3
amount	String	Y	Winning amount	4500.00

Request Sample

{
  "merchantCode": "PNLM000003"
}

Response Sample

[
  {
    "orderId": "20230512023003",
    "username": "JOHNDOE",
    "betCurrency": "PHP",
    "totalBetAmount": "15.00",
    "drawDate": "2023-10-16T14:00:00+08:00",
    "roundId": "1",
    "status": "POSTED",
    "creationDate": "2023-10-16T13:19:07+08:00",
    "updatedDate": "2023-10-16T13:19:07+08:00",
    "bettings": [
      {
        "bettingId": "20230609095201001",
        "siteCode": "PCSO",
        "site": "PCSO",
        "gameType": "SWER3",
        "betType": "S",
        "betAmount": "10.00",
        "betNumber": "5,7,8",
        "drawId": "20230512001001",
        "winStatus": true,
        "drawResult": "5,7,8",
        "creationDate": "2023-10-16T13:19:07+08:00",
        "updatedDate": "2023-10-16T20:19:07+08:00",
        "bettingOdds": [
          {
            "code": "SWER3",
            "odds": "450"
          }
        ],
        "winningDetails": [
          {
            "code": "SWER3",
            "amount": "4500.00"
          }
        ]
      },
      {
        "bettingId": "20230609099126003",
        "betSiteCode": "PCSO",
        "betSite": "PCSO",
        "gameType": "EZ2",
        "betType": "R",
        "betAmount": "5.00",
        "betNumber": "03,15",
        "drawId": "20230512001002",
        "winStatus": true,
        "drawResult": "03,15",
        "creationDate": "2023-10-16T13:19:07+08:00",
        "updatedDate": "2023-10-16T20:19:07+08:00",
        "bettingOdds": [
          {
            "code": "EZ2",
            "odds": "400"
          }
        ],
        "winningDetails": [
          {
            "code": "EZ2",
            "amount": "2000.00"
          }
        ]
      }
    ]
  }
]