(Excel) UniPin Game List

See more UniPin Examples

Demonstrates how to send a POST with the hash_hmac(sha256,partnerid+timestamp+path,secretkey) authentication.

For more information, see https://documenter.getpostman.com/view/8087848/SVfNvUt2?version=latest#1685124e-d292-4414-b1ca-e34e3f3ec7b4

Download Excel Class Modules Chilkat Excel Class Modules

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Implements the following CURL command:

' curl --request POST 'https://dev-api.unipin.com/in-game-topup/list' \
' --header 'partnerid: 587e3675-e0ed-4e9e-9b39-099b11498fdc' \
' --header 'timestamp: 1566552295' \
' --header 'path: in-game-topup/list' \
' --header 'auth: 1d9f5e7aca9f3c14da7c957d6977447739877cebfc10fcf3682bd32da47a2bda' \
' --header 'Content-Type: application/json'

' Use the following online tool to generate HTTP code from a CURL command
' Convert a cURL Command to HTTP Source Code

Dim dt As Chilkat.CkDateTime
Set dt = Chilkat.NewCkDateTime
Dim success As Boolean
success = dt.SetFromCurrentSystemTime()

timestamp = dt.GetAsUnixTimeStr(False)

' Change this to your actual partner ID.

partnerId = "587e3675-e0ed-4e9e-9b39-099b11498fdc"

http.SetRequestHeader "path","in-game-topup/list"
http.SetRequestHeader "timestamp",timestamp
http.SetRequestHeader "partnerid",partnerId
http.SetRequestHeader "Content-Type","application/json"

' Calculate the auth header using  hash_hmac(sha256,partnerid+timestamp+path,secretkey)
Dim crypt As Chilkat.Crypt2
Set crypt = Chilkat.NewCrypt2
crypt.MacAlgorithm = "hmac"
crypt.HashAlgorithm = "sha256"
crypt.EncodingMode = "hexlower"

' Change this to your actual secret key..
success = crypt.SetMacKeyEncoded("wabc123asljdgadlgd3","us-ascii")

Dim sbMacData As Chilkat.StringBuilder
Set sbMacData = Chilkat.NewStringBuilder
success = sbMacData.Append(partnerId)
success = sbMacData.Append(timestamp)
success = sbMacData.Append("in-game-topup/list")


auth = crypt.MacStringENC(sbMacData.GetAsString())
http.SetRequestHeader "auth",auth


Set resp = http.QuickRequest("POST","https://dev-api.unipin.com/in-game-topup/list")
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = resp.GetBodySb(sbResponseBody)
Dim jResp As Chilkat.JsonObject
Set jResp = Chilkat.NewJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False

Debug.Print "Response Body:"
Debug.Print jResp.Emit()


respStatusCode = resp.StatusCode
Debug.Print "Response Status Code = "; respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print resp.Header
    Debug.Print "Failed."

    Exit Sub
End If

' Sample JSON response:
' (Sample code for parsing the JSON response is shown below)

' {
'   "game_list": [
'     {
'       "game_category": "MLBB_ID",
'       "game_code": "MLBBD_ID",
'       "game_name": "Mobile Legends Diamonds",
'       "icon_url": "http://dev-backoffice.unipin.com/images/icon_direct_topup_games/1565343343-icon-1548659712-icon-Mobile legend 300x300 px.png",
'       "game_status": "active",
'       "updated_at": "2019-08-09 16:35:43"
'     },
'     {
'       "game_category": "MLBB_ID",
'       "game_code": "MLBBS_ID",
'       "game_name": "Mobile Legends Starlight Member",
'       "icon_url": "http://dev-backoffice.unipin.com/images/icon_direct_topup_games/1565343258-icon-1548659712-icon-Mobile legend 300x300 px.png",
'       "game_status": "active",
'       "updated_at": "2019-08-09 16:34:18"
'     },
' ...
' ...
'   ],
'   "status": 1,
'   "reason": "Successful"
' }

' Sample code for parsing the JSON response...
' Use the following online tool to generate parsing code from sample JSON:
' Generate Parsing Code from JSON


status = jResp.IntOf("status")

reason = jResp.StringOf("reason")

i = 0

count_i = jResp.SizeOfArray("game_list")
Do While i < count_i
    jResp.I = i
    game_category = jResp.StringOf("game_list[i].game_category")
    game_code = jResp.StringOf("game_list[i].game_code")
    game_name = jResp.StringOf("game_list[i].game_name")
    icon_url = jResp.StringOf("game_list[i].icon_url")
    game_status = jResp.StringOf("game_list[i].game_status")
    updated_at = jResp.StringOf("game_list[i].updated_at")
    i = i + 1
Loop