1. Using Robots in Oracle Integration 3
  2. Build a Robot
  3. Add an Action to a Robot
  4. Add a Web Table Action

Add a Web Table Action

The web table action lets you to identify the columns in a table that you are interested in. Add more actions to interact with the table cells.

Use Cases

Consider a table that contains invoice numbers in one column and a hyperlink in another column. Use a web table action to identify the two columns. Then, use a get text action to get each invoice number, and use a click element action to select each link. Include both of these actions within a foreach loop, which lets you iterate on multiple rows of data.

For a real-world scenario, see Use Case: Save Values After Iterating on a Table.

Requirements and Output

  • You can use this action only for a UI element that is coded as a table.

  • Create the web table definition first, and then add a web table action to a robot.

    The web table definition identifies the table that the robot interacts with. If the table changes, update the web table definition as needed.

    Then, when you add a web table action to a robot, you choose the web table definition to use.

  • This action returns an output: A collection of HTML table rows for the columns that you select. Each row consists of key-value pairs:

    • The key is a column name.

    • The value is the XPath of a row cell.

  • Only the get text and click element actions can interact with the XPath values that this action returns.

Step 1. Create a Web Table Definition

See Create a Web Table Definition.

Step 2. Add a Web Table Action

Note:

You must use the low-code capabilities to add this action to a robot. Keep reading for step-by-step instructions.
  1. Open the robot to edit.
  2. Add the action to the robot.
    1. On the canvas, point to an action, and click +.
      A mouse cursor points to an action in the canvas and hovers over the plus sign button, which appears at the bottom of the rectangle that represents the action. A plus sign button also appears at the top of the rectangle, for adding an action after the current action.

      A menu of available actions appears.

    2. Select Web Table.

      A Web Table action appears on the canvas, and the Web Table panel appears.

  3. In the panel, enter a Name and Description for the action.

    The Name appears on the action in the canvas and should help you and others understand the goal of the action.

  4. On the Input tab, select the web table definition that the action interacts with.
    1. Click within the Web Table field, and select Web Table Web table definition.

      The Web table definitions panel appears.

    2. Drag a web table definition to the Web Table field.
  5. On the Input tab, specify whether to capture any screenshots as part of the action.
  6. On the Output tab, review the variable name that the table information is saved to.

    The web table action creates a custom data type and variable. The properties of the data type are the columns that you identified in the web table action. The variable is a collection of the data type that the web table action created.

  7. On the Pre Validate and Post Validate tabs, specify whether to complete any validation before and after the action.
  8. Click OK.
  9. Above the canvas, select Save.

Your next steps depend upon your goals: