(Excel) MercadoLibre - GET Request with Access Token in Query Params

See more MercadoLibre Examples

Demonstrates how to send an HTTPS GET request to MercadoLibre with the access token specified as a query parameter.

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

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


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

Debug.Print responseStr