(Excel) MercadoLibre - Cargar factura (Upload Invoice)

Cargar factura en detalle de venta

For more information, see https://developers.mercadolibre.com.ar/es_ar/cargar-factura

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

' Implements the following CURL command:

' curl -X POST https://api.mercadolibre.com/packs/$PACK_ID/fiscal_documents?access_token=$ACCESS_TOKEN 
'   -H 'content-type: multipart/form-data;' 
'   -F 'fiscal_document=@/home/user/.../Factura_adjunta.pdf'

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

Dim sbPath As Chilkat.StringBuilder
Set sbPath = Chilkat.NewStringBuilder
Dim success As Boolean
success = sbPath.Append("/packs/$PACK_ID/fiscal_documents?access_token=$ACCESS_TOKEN")
' Use an actual pack ID.

numReplaced = sbPath.Replace("$PACK_ID","2000000089077943")
numReplaced = sbPath.Replace("$ACCESS_TOKEN",jsonToken.StringOf("access_token"))

Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest
req.HttpVerb = "POST"
req.Path = sbPath.GetAsString()
req.ContentType = "multipart/form-data"
success = req.AddFileForUpload2("fiscal_document","/home/user/.../Factura_adjunta.pdf","application/pdf")

req.AddHeader "Expect","100-continue"
req.AddHeader "content-type","multipart/form-data;"


Set resp = http.SynchronousRequest("api.mercadolibre.com",443,True,req)
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)

' {
'   "ids": [
'     "415460047_a96d8dea-38cd-4402-938e-80a1c134fc5d"
'   ]
' }

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


i = 0

count_i = jResp.SizeOfArray("ids")
Do While i < count_i
    jResp.I = i
    strVal = jResp.StringOf("ids[i]")
    i = i + 1
Loop