(Excel) Yousign: Download Information about Previously Uploaded File

Demonstrates how to download the information (in JSON format) about a file previously uploaded.

For more information, see https://dev.yousign.com/?version=latest#26513de1-9fab-44d5-96b1-70fe3b3de7a7

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

' Implements the following CURL command:

' curl --location --request GET 'https://staging-api.yousign.com/files/{{id}}' \
' --header 'Authorization: Bearer YOUR_API_KEY' \
' --header 'Content-Type: application/json'

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

' Adds the "Authorization: Bearer YOUR_API_KEY" header.
http.AuthToken = "YOUR_API_KEY"
http.SetRequestHeader "Content-Type","application/json"

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = http.QuickGetSb("https://staging-api.yousign.com/files/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX",sbResponseBody)
If (success = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim jResp As Chilkat.JsonObject
Set jResp = Chilkat.NewJsonObject
Dim success As Boolean
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False

Debug.Print "Response Body:"
Debug.Print jResp.Emit()


respStatusCode = http.LastStatus
Debug.Print "Response Status Code = "; respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print http.LastHeader
    Debug.Print "Failed."
    Exit Sub
End If

' Sample JSON response:
' (Sample code for parsing the JSON response is shown below)

' {
'   "id": "/files/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX",
'   "name": "The best name for my file.pdf",
'   "type": "signable",
'   "contentType": "application/pdf",
'   "description": null,
'   "createdAt": "2018-12-07T08:10:21+01:00",
'   "updatedAt": "2018-12-07T08:10:21+01:00",
'   "sha256": "bb57ae2b2ca6ad0133a699350d1a6f6c8cdfde3cf872cf526585d306e4675cc2",
'   "metadata": [
'   ],
'   "workspace": "/workspaces/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX",
'   "creator": null,
'   "protected": false,
'   "position": 0,
'   "parent": null
' }

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


id = jResp.StringOf("id")

name = jResp.StringOf("name")

v_type = jResp.StringOf("type")

contentType = jResp.StringOf("contentType")

description = jResp.StringOf("description")

createdAt = jResp.StringOf("createdAt")

updatedAt = jResp.StringOf("updatedAt")

sha256 = jResp.StringOf("sha256")

workspace = jResp.StringOf("workspace")

creator = jResp.StringOf("creator")

v_protected = jResp.BoolOf("protected")

position = jResp.IntOf("position")

parent = jResp.StringOf("parent")

i = 0

count_i = jResp.SizeOfArray("metadata")
Do While i < count_i
    jResp.I = i
    i = i + 1
Loop