GetListItem

The GetListItem component enables you to return specific items that are defined in a particular query.

ScreenShot

Supported Functions

Double Click on the GetListItem component title bar to launch the GetListItem Editor Window.

ScreenShot

To create input variables click on the ScreenShot icon. Once an index is created, its data type could be changed and each index that is created will expose a Data out port.

Ports

The GetListItem component exposes Control In, Control Out, Data In and dynamic Data Out ports by default.

Port Description
Control In Must be connected to the Control Out port of one or more components.
Control Out Must be connected to the Control In port of any other component.
Data In Must be connected to the Data Out port of another component from where data is to be collected. The For Loop component exposes the From and To of the Data In ports.
Dynamic Data Out Must be connected to the Data In port of another component where data is to be displayed (Object). This port is displayed when we add items into the component.

Properties

To edit the properties of the GetListItem component, in the Properties window, change the required property. You can edit the following properties:

Property Description
Search Search for the respective property.
Delay After Execution Specifies the wait time (in seconds) after the action is executed.
Delay Before Execution Specifies the wait time (in seconds) before the action is executed.

Example

Let us consider an example of retrieving data from a return statement.

ScreenShot

To use the Get List Item component in this scenario:

  1. Add the Data Reader component:

    • In the Toolbox, expand Utilities and expand Data Reader.

    • Drag the ReadFromExcel component to the design surface.

    • Specify the filepath and sheet name.

    • Drag the For Each component and drop it on the Design surface.

  2. Add the GetListItem component.

    • In the Toolbox, expand Utilities and expand Reflections.

    • Drag the GetListItem component to the design surface.

    • Double click on the GetListItem title bar to launch the Get List Item editor.

    • Click on the ScreenShot to add additional parameters.

  3. Add a FORMAT TEXT component.

    • In the Toolbox, expand General.

    • Drag the Format Text component to the design surface.

    • Double click the FORMAT TEXT component title bar to open the Text Format Editor.

    • Enter the following format as shown below.

      ScreenShot

    • Click OK.

  4. Add a Message Box component to display output of the Get List Item component.

    • In the Toolbox, expand General.

    • Expand the MessageBox component, drag Show component and drop it on the Design surface.

  5. Connect:

    • The control ports of all components.

    • The Data Out port of the ReadFromExcel component to the Data In port of the For Each component.

    • The Data out port of the ReadFromExcel component to the Data In port of the For Each component.

    • The Loop out port of the For Each component to the control in port of the GetListItem.

    • The Object {0} Data out port of the GetListItem component to the {0} Data In port of the FormatText component.

    • The Object {1} Data out port of the GetListItem component to the {1} Data In port of the FormatText component.

    • The Data Out port of the FormatText component to the Data In port of the Message Box component.

  6. In the toolbar, click Run. The output with the retrieved value is displayed.

    ScreenShot