---
sourceDocument: Yokohama Data and Automation
sourceDocumentLink: https://www.servicenow.com/docs/r/yokohama/integrate-applications

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Data and Automation

ft:clusterId :

    - crint

bundleId :

    - crint

workflow :

    - Creator


---

# Use the Get Table component

# Use the Get Table component {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read

Extract and display data and the count of rows from the grids, lists, combo boxes,
and HTML tables, by using the Get Table component in the RPA Desktop Design Studio.

## Before you begin

Role required: none

## About this task

Many properties of the Get Table component are common with other Actions UI
components, to configure these properties, see [Properties of Actions (UI) components](https://www.servicenow.com/docs/xu9MB7eY4nbVP2n93pGwBg "Learn about the properties of the Actions (UI) group components. All components under the Actions (UI) group have both unique and common properties.").  
The properties unique to the Get Table component are given.{#use-actionsui-get-table__table_jng_r2q_c5b__entry__2}

| Property | Description |
|-|-|
| Ignore Header | Option to specify whether the automation captures or ignores the header of the table. The default value is False. |
[Table 1. Get Table component properties]

{#use-actionsui-get-table__table_jng_r2q_c5b}

## Procedure

1. In the Toolbox pane, navigate to Actions (UI)Get Table.
2. Drag the Get Table component to the Design surface.
3. In the Get Table component, click the camera icon (![Camera icon.]()).  
   The Press "CTRL+SHIFT" for selection message appears.
4. Press the Ctrl + Shift keys.  
   The mouse device turns into a crossover icon (![Crossover icon.]()).
5. Drag the mouse device over the application to cover the table and release.  
   The selected area of the element is captured as an image in the Get Table component.
6. Drag the green plus icon (![Green plus icon.]()) over the captured image and place on the location where you want the component to perform an action.
7. **Optional:** Add an anchor to the captured image by doing the following actions:  
   An anchor is a unique identifier that enables the Get Table component to identify the application where the component will perform an action. Although adding an anchor is a good approach, it's optional. If you don't add an anchor, the Get Table component treats the whole captured image as an anchor. To know more about an anchor, see the steps to use the [Anchor](https://www.servicenow.com/docs/aIVkN_YpZS9zVpQGAFOdlg "An anchor is a unique identifier which is identified on the screen. It helps specify the target area for a simulated user interaction by defining a static area from which actions can be defined at a relative distance. The position of actions is calculated based on the anchor and the actions are performed relative to it.").
   1. In the Get Table component, right-click the image and click Add Anchor.  
      The anchor appears as a yellow rectangle with red borders.
   2. Drag and place the anchor on the captured image.  
      Tip:  
      To change the dimensions of the anchor, position the mouse device along
      the edge of the anchor until the mouse device turns into a diagonal two-sided arrow (![Two-sided arrow.]()) and then drag the anchor.
   {#use-actionsui-get-table__substeps_wmn_fg2_krb}
8. **Optional:** Capture alternate images by doing the following actions:  
   Alternate images prevent an execution failure when the Get Table component doesn't find the image that was captured first. In that case, the Get Table component then searches for alternate images to execute. You can add as many alternate images as you need.
   1. In the ALTERNATE IMAGES window, click the add image icon (![Add image icon.]()).
   2. Click the camera icon (![Camera icon.]()).  
      The Press "CTRL+SHIFT" for selection message appears.
   3. Drag the mouse device over the application to cover the table and release.  
      The selected area is captured as an image in the ALTERNATE IMAGES window.
   4. Drag the green plus icon (![Green plus icon.]()) over the captured image and place on the location where you want the component to perform an action.
   5. To close the ALTERNATE IMAGES window, click OK.
   {#use-actionsui-get-table__substeps_bc5_xg2_krb}
9. **Optional:** To configure the ways that the output fields show the output, see [Configure output port properties](https://www.servicenow.com/docs/G3cLiqA8Qx5IlG~aBGi0qw "Configure the ways the output ports or fields of components or methods return output in the RPA Desktop Design Studio.").
10. **Optional:** Connect the ports as described in the following table.  
    {#use-actionsui-get-table__table_jnw_jn1_krb__entry__5}

    | Port type | Port name | Data type | Purpose of connection | Mandatory? |
    |-|-|-|-|-|
    | Data out | Count | Integer | Returns the total count of rows. | Not applicable |
    | Data out | DataTable | Not applicable | Returns the table. | Not applicable. |
    [ ]

    {#use-actionsui-get-table__table_jnw_jn1_krb}
11. To test the component, right-click the component bar and then click Run From Here.

## Extract data from an HTML table to an Excel
file {#use-actionsui-get-table__example_llv_hfq_c5b}

The Get Table component extracts data from an HTML table and passes
the data through the DataTable Data Out port. The data is passed through the Data In
port of the WriteToExcel component (To use the WriteToExcel component, see [Use the WriteToExcel component](https://www.servicenow.com/docs/rgdpM~9o3cjH1fEzQxr39g "Write the data to a worksheet of a Microsoft Excel file as part of an automation Workflow by using the WriteToExcel component in RPA Desktop Design Studio.")). The data is written to the sheet
specified in the SheetName field of the Excel document
specified in the Filepath field
.

*[\>]: and then