Skip to Content

Scripting example in Jitterbit App Builder - Processes

This examples demonstrates how to fill an event table using an action registered on the Filter event. In this example, the table is populated with a list of system processes.

Table schema

Column Data Type Primary Key Auto-generate Nullable
Id INTEGER Yes No No
ProcessName NVARCHAR(50) No No No
WorkingSet BIGINT No No No

Script

using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;

Process[] processes = Process.GetProcesses();

Table.Total = processes.Length;

IEnumerable<Process> range = processes.Skip(Table.Filter.Skip)
                                      .Take(Table.Filter.Limit ?? processes.Length)
                                      .ToList();

foreach (Process process in range)
{
    EventRow row = Table.CreateRow();

    row["Id"].Value = process.Id;
    row["ProcessName"].Value = process.ProcessName;
    row["WorkingSet"].Value = process.WorkingSet64;
}

Limitations

This example does not support the following features:

  • Sorting
  • Filtering
  • Keyword Search