(VBScript) Call a JavaScript Function Returning an Array

See more JavaScript Examples

Note: This example requires Chilkat v11.4.0 or greater.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

success = 0

' ----------------------------------------------------------------------------------
' The Javascript functions called in this example are shown at the bottom of this page.
' -----------------------------------------------------------------------------------

set sbScript = CreateObject("Chilkat.StringBuilder")
success = sbScript.LoadFile("js_function_returning_array.js","utf-8")
If (success = 0) Then
    outFile.WriteLine(sbScript.LastErrorText)
    WScript.Quit
End If

set js = CreateObject("Chilkat.Js")

set result = CreateObject("Chilkat.JsonObject")
result.EmitCompact = 0

' Call Eval to add the function to the context's global object
success = js.Eval(sbScript,result)
If (success = 0) Then
    ' Examine the result for an exception.
    outFile.WriteLine(result.Emit())

    ' Also examine the LastErrorText.
    outFile.WriteLine(js.LastErrorText)
    WScript.Quit
End If

' ------------------------------------------------------------------------------
' Call each function

set funcCall = CreateObject("Chilkat.JsonObject")

' Create JSON specifying the function name and arguments
' The function has no arguments, so we only specify the name.

success = funcCall.UpdateString("name","getDays")

success = js.CallFunction(funcCall,result)
If (success = 0) Then
    ' Examine the result for an exception.
    outFile.WriteLine(result.Emit())

    ' Also examine the LastErrorText.
    outFile.WriteLine(js.LastErrorText)
    WScript.Quit
End If

outFile.WriteLine(result.Emit())

' Output:
' {
'   "type": "array",
'   "value": [
'     "Monday",
'     "Tuesday",
'     "Wednesday",
'     "Thursday",
'     "Friday"
'   ]
' }

' Access each array value..
count = result.SizeOfArray("value")
i = 0
Do While i < count
    result.I = i
    outFile.WriteLine(result.StringOf("value[i]"))
    i = i + 1
Loop

' ------------------------------------------------------------------------------
' Call the getRange(start,end) function

funcCall.Clear 
success = funcCall.UpdateString("name","getRange")
success = funcCall.UpdateInt("args[0]",14)
success = funcCall.UpdateInt("args[1]",21)
success = js.CallFunction(funcCall,result)
outFile.WriteLine(result.Emit())

' Output:
' {
'   "type": "array",
'   "value": [
'     14,
'     15,
'     16,
'     17,
'     18,
'     19,
'     20,
'     21
'   ]
' }

count = result.SizeOfArray("value")
i = 0
Do While i < count
    result.I = i
    outFile.WriteLine(result.IntOf("value[i]"))
    i = i + 1
Loop

' ------------------------------------------------------------------------------
' Call the getEmployees() function

funcCall.Clear 
success = funcCall.UpdateString("name","getEmployees")
success = js.CallFunction(funcCall,result)
outFile.WriteLine(result.Emit())

' Output:
' {
'   "type": "array",
'   "value": [
'     {
'       "id": 101,
'       "name": "Alice",
'       "role": "Dev"
'     },
'     {
'       "id": 102,
'       "name": "Bob",
'       "role": "Manager"
'     }
'   ]
' }

count = result.SizeOfArray("value")
i = 0
Do While i < count
    result.I = i
    outFile.WriteLine("name: " & result.StringOf("value[i].name"))
    outFile.WriteLine("role: " & result.StringOf("value[i].role"))
    outFile.WriteLine("id: " & result.IntOf("value[i].id"))
    outFile.WriteLine("")
    i = i + 1
Loop

outFile.Close

function getDays() {
    return ["Monday", "Tuesday", "Wednesday", "Thursday", "Friday"];
}

function getRange(start, end) {
    var arr = [];
    for (var i = start; i <= end; i++) {
        arr.push(i);
    }
    return arr;
}
// Usage: getRange(1, 5) -> [1, 2, 3, 4, 5]

function getEmployees() {
    return [
        { id: 101, name: "Alice", role: "Dev" },
        { id: 102, name: "Bob", role: "Manager" }
    ];
}