(Excel) Yousign: List Files

List Yousign files.

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' \
' --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",sbResponseBody)
If (success = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

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

Debug.Print "Response Body:"
Debug.Print json.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": "abc.pdf",
'   "type": "signable",
'   "contentType": "application\/pdf",
'   "description": null,
'   "createdAt": "2020-05-27T09:14:12+02:00",
'   "updatedAt": "2020-05-27T09:14:12+02:00",
'   "sha256": "ea2a92b0eff5bebfa3ccd869fd61e27bb7fe973d0dff63f106d8b0d614469fa0",
'   "metadata": [
'   ],
'   "workspace": "\/workspaces\/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX",
'   "creator": null,
'   "fileObjects": [
'   ],
'   "protected": false,
'   "position": 0,
'   "parent": null,
'   "fieldsCompatible": true,
'   "company": "\/companies\/XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX"
' }

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


id = json.StringOf("id")

name = json.StringOf("name")

v_type = json.StringOf("type")

contentType = json.StringOf("contentType")

description = json.StringOf("description")

createdAt = json.StringOf("createdAt")

updatedAt = json.StringOf("updatedAt")

sha256 = json.StringOf("sha256")

workspace = json.StringOf("workspace")

creator = json.StringOf("creator")

v_protected = json.BoolOf("protected")

position = json.IntOf("position")

parent = json.StringOf("parent")

fieldsCompatible = json.BoolOf("fieldsCompatible")

company = json.StringOf("company")

i = 0

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