(Excel) MercadoLibre - Get Recent Orders

See more MercadoLibre Examples

Demonstrates how to get recent orders in Mercadolibre.

For more information, see https://developers.mercadolibre.com.ar/es_ar/gestiona-ventas#Ordenes-recientes

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")

' Notice that the query parameter name is "seller".   In other Mercadolibre API calls the query parameter name is "seller_id".
' Make sure to pay close attention to the Mercadolibre documentation.
' For example, here:  https://developers.mercadolibre.com.ar/es_ar/gestiona-ventas#Ordenes-recientes
' and here:  https://developers.mercadolibre.com.ar/en_us/manage-questions-and-answers

responseStr = http.QuickGetStr("https://api.mercadolibre.com/orders/search/recent?seller={$SELLER_ID}&offset=0&sort=date_desc&limit=50")
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print responseStr