VBScript
Call a JavaScript Function Returning an Array

Demonstrates how to call a JavaScript function that returns an array.
Chilkat VBScript Downloads

VBScript
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