(Excel) MercadoLibre - GET Request with Authorization Bearer Access Token

See more MercadoLibre Examples

Demonstrates how to send an HTTPS GET request to MercadoLibre with an "Authorization: Bearer $ACCESS_TOKEN" header.

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

' First get our previously obtained OAuth2 access token.
Dim jsonToken As Chilkat.JsonObject
Set jsonToken = Chilkat.NewJsonObject

success = jsonToken.LoadFile("qa_data/tokens/mercadolibre.json")
If (success = False) Then
    Debug.Print "Failed to load JSON access token."
    Exit Sub
End If

' This adds the "Authorization: Bearer $ACCESS_TOKEN" header field.
http.AuthToken = jsonToken.StringOf("access_token")

' Use your seller ID.
Dim success As Boolean
success = http.SetUrlVar("SELLER_ID","577815702")


responseStr = http.QuickGetStr("https://api.mercadolibre.com/questions/search?seller_id={$SELLER_ID}&api_version=4")
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print responseStr