(VBScript) TikTok Shop Get Authorized Shops

See more TikTok Shop Examples

An example showing how to get the authorized shops in the TikTok Shops API.

IMPORTANT: This example requires a pre-release for the next version of Chilkat after the current v9.5.0.99 release. Contact info@chilkatsoft.com if you wish to get a pre-release. However, pre-releases of .NET Core (hosted on NuGet) and Node.js will not be possible.

For more information, see https://partner.tiktokshop.com/docv2/page/6507ead7b99d5302be949ba9?external_id=6507ead7b99d5302be949ba9

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

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

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = CreateObject("Chilkat.Http")

' It is assumed we previously obtained an OAuth2 access token.
' This example loads the JSON access token file 
' saved by this example: Get TikTok Shop OAuth2 Access Token
' or refrehsed by this example: Get TikTok Shop Refresh OAuth2 Access Token
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set jsonToken = CreateObject("Chilkat.JsonObject")
success = jsonToken.LoadFile("qa_data/tokens/tiktok-shops.json")
If (success <> 1) Then
    outFile.WriteLine("Failed to load tiktok-shops.json")
    WScript.Quit
End If

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set queryParams = CreateObject("Chilkat.JsonObject")
success = queryParams.UpdateString("app_key","APP_KEY")
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.CkDateTime")
set dt = CreateObject("Chilkat.CkDateTime")
success = queryParams.UpdateString("timestamp",dt.GetAsUnixTimeStr(0))
success = queryParams.UpdateInt("version",202309)

' Sort the JSON members by member name, in ascending order (A-Z), case sensitive..
' Note: The Sort method is added in Chilkat v9.5.0.100
ascending = 1
caseSensitive = 1
queryParams.Sort ascending,caseSensitive

appSecret = "APP_SECRET"
path = "/authorization/202309/shops"

' Build the StringToSign
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder")
set sb = CreateObject("Chilkat.StringBuilder")
success = sb.Append(appSecret)
success = sb.Append(path)
numParams = queryParams.Size
i = 0
Do While i < numParams
    success = sb.Append(queryParams.NameAt(i))
    success = sb.Append(queryParams.StringAt(i))
    i = i + 1
Loop
success = sb.Append(appSecret)

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Crypt2")
set crypt = CreateObject("Chilkat.Crypt2")
crypt.HashAlgorithm = "SHA256"
crypt.MacAlgorithm = "HMAC"
crypt.EncodingMode = "hex_lower"
success = crypt.SetMacKeyString(appSecret)

sig = crypt.MacStringENC(sb.GetAsString())

success = queryParams.UpdateString("access_token",jsonToken.StringOf("data.access_token"))
success = queryParams.UpdateString("sign",sig)

http.SetRequestHeader "x-tts-access-token",jsonToken.StringOf("data.access_token")
http.SetRequestHeader "content-type","application/json"

' resp is a Chilkat.HttpResponse
Set resp = http.QuickRequestParams("GET","https://open-api.tiktokglobalshop.com/authorization/202309/shops",queryParams)
If (http.LastMethodSuccess = 0) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = CreateObject("Chilkat.JsonObject")
success = resp.GetBodyJson(json)

outFile.WriteLine(resp.StatusCode)
outFile.WriteLine(resp.BodyStr)

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

' {
'   "code": 0,
'   "data": {
'     "shops": [
'       {
'         "cipher": "GCP_XF90igAAAABh00qsWgtvOiGFNqyubMt3",
'         "code": "CNGBCBA4LLU8",
'         "id": "7000714532876273420",
'         "name": "Maomao beauty shop",
'         "region": "GB",
'         "seller_type": "CROSS_BORDER"
'       }
'     ]
'   },
'   "message": "Success",
'   "request_id": "202203070749000101890810281E8C70B7"
' }

code = json.IntOf("code")
message = json.StringOf("message")
request_id = json.StringOf("request_id")
i = 0
count_i = json.SizeOfArray("data.shops")
Do While i < count_i
    json.I = i
    cipher = json.StringOf("data.shops[i].cipher")
    code_str = json.StringOf("data.shops[i].code")
    id = json.StringOf("data.shops[i].id")
    name = json.StringOf("data.shops[i].name")
    region = json.StringOf("data.shops[i].region")
    seller_type = json.StringOf("data.shops[i].seller_type")
    i = i + 1
Loop

outFile.Close