PowerBuilder

Call a JavaScript Function Returning an Array

See more JavaScript Examples

Demonstrates how to call a JavaScript function that returns an array. PowerBuilder

integer li_rc
integer li_Success
oleobject loo_SbScript
oleobject loo_Js
oleobject loo_Result
oleobject loo_FuncCall
integer li_Count
integer i

li_Success = 0

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

loo_SbScript = create oleobject
li_rc = loo_SbScript.ConnectToNewObject("Chilkat.StringBuilder")
if li_rc < 0 then
    destroy loo_SbScript
    MessageBox("Error","Connecting to COM object failed")
    return
end if
li_Success = loo_SbScript.LoadFile("js_function_returning_array.js","utf-8")
if li_Success = 0 then
    Write-Debug loo_SbScript.LastErrorText
    destroy loo_SbScript
    return
end if

loo_Js = create oleobject
li_rc = loo_Js.ConnectToNewObject("Chilkat.Js")

loo_Result = create oleobject
li_rc = loo_Result.ConnectToNewObject("Chilkat.JsonObject")

loo_Result.EmitCompact = 0

// Call Eval to add the function to the context's global object
li_Success = loo_Js.Eval(loo_SbScript,loo_Result)
if li_Success = 0 then
    // Examine the result for an exception.
    Write-Debug loo_Result.Emit()

    // Also examine the LastErrorText.
    Write-Debug loo_Js.LastErrorText
    destroy loo_SbScript
    destroy loo_Js
    destroy loo_Result
    return
end if

// ------------------------------------------------------------------------------
// Call each function

loo_FuncCall = create oleobject
li_rc = loo_FuncCall.ConnectToNewObject("Chilkat.JsonObject")

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

loo_FuncCall.UpdateString("name","getDays")

li_Success = loo_Js.CallFunction(loo_FuncCall,loo_Result)
if li_Success = 0 then
    // Examine the result for an exception.
    Write-Debug loo_Result.Emit()

    // Also examine the LastErrorText.
    Write-Debug loo_Js.LastErrorText
    destroy loo_SbScript
    destroy loo_Js
    destroy loo_Result
    destroy loo_FuncCall
    return
end if

Write-Debug loo_Result.Emit()

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

// Access each array value..
li_Count = loo_Result.SizeOfArray("value")
i = 0
do while i < li_Count
    loo_Result.I = i
    Write-Debug loo_Result.StringOf("value[i]")
    i = i + 1
loop

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

loo_FuncCall.Clear()
loo_FuncCall.UpdateString("name","getRange")
loo_FuncCall.UpdateInt("args[0]",14)
loo_FuncCall.UpdateInt("args[1]",21)
li_Success = loo_Js.CallFunction(loo_FuncCall,loo_Result)
Write-Debug loo_Result.Emit()

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

li_Count = loo_Result.SizeOfArray("value")
i = 0
do while i < li_Count
    loo_Result.I = i
    Write-Debug string(loo_Result.IntOf("value[i]"))
    i = i + 1
loop

// ------------------------------------------------------------------------------
// Call the getEmployees() function

loo_FuncCall.Clear()
loo_FuncCall.UpdateString("name","getEmployees")
li_Success = loo_Js.CallFunction(loo_FuncCall,loo_Result)
Write-Debug loo_Result.Emit()

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

li_Count = loo_Result.SizeOfArray("value")
i = 0
do while i < li_Count
    loo_Result.I = i
    Write-Debug "name: " + loo_Result.StringOf("value[i].name")
    Write-Debug "role: " + loo_Result.StringOf("value[i].role")
    Write-Debug "id: " + string(loo_Result.IntOf("value[i].id"))
    Write-Debug ""
    i = i + 1
loop


destroy loo_SbScript
destroy loo_Js
destroy loo_Result
destroy loo_FuncCall