UiPath Activities

The UiPath Activities Guide

Extract Table Data

📘

Note:

The Object Repository does not currently support this activity.

UiPath.UIAutomationNext.Activities.NExtractData

Description

Extracts data from a specified web page or application. Use this activity to extract structured information such as table data or web search results that can span multiple pages. Follow the Extract Wizard to indicate what information to extract. This activity must be added inside a Use Application/Browser activity.

Properties

Common

  • Continue on error - Specifies if the automation should continue even when the activity throws an error. This field only supports Boolean values (True, False). The default value is False. As a result, if the field is blank and an error is thrown, the execution of the project stops. If the value is set to True, the execution of the project continues regardless of any error.
  • Delay after - Delay (in seconds) between the time this activity is completed and the time the next activity begins any operations. The default value is 0.3 seconds. Adding a delay between activities ensures that one activity has enough time to complete before the next activity begins.
  • Delay before - Delay (in seconds) between the time the previous activity is completed and the time this activity begins performing any operations. The default value is 0.2 seconds. Adding a delay between activities ensures that one activity has enough time to complete before the next activity begins.
  • DisplayName - The name displayed for the activity in the Designer panel.
  • Timeout - Specify a number of seconds for which to wait for the activity to be executed before throwing an error. The default value is 30 seconds.

Input

  • ExtractMetadata - An XML string that enables you to define what data to extract from the indicated web page.

Misc

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Options

  • DataTable - The information extracted from the indicated web page. This field supports only DataTable variables.
  • Delay between pages - The amount of time (in seconds) to wait until the next page is loaded. The default value is 0.3 seconds. If the loading time of the page is longer, this value should be higher.
  • Input mode - Select how to execute the click on the next page link if the data spans multiple pages:
    • Same as App/Browser - Use the same input mode as the Use Application/Browser activity. This is the default selection.
    • Window Messages - Sends a specific message to the target application. This input method can work in the background, is compatible with most desktop apps, but it is not the fastest of the methods.
    • Hardware Events - Simulates the click by using the hardware driver. This is the slowest method, it cannot work in the background, but it is compatible with all desktop apps.
    • Simulate - Simulates the click using the technology of the target application. This input method is the fastest and works in the background.
  • Maximum results - The maximum number of results to be extracted. If the value is 0, all the identified elements are added to the output. The default value is 100.

UiPath.UIAutomationNext.Activities.NExtractData

Description

Extracts data from a specified web page or application. Use this activity to extract structured information such as table data or web search results that can span multiple pages. Follow the Extract Wizard to indicate what information to extract. This activity must be added inside a Use Application/Browser activity.

To learn how to use this activity, see Tutorial: Extracting Table Data from a Web Page and Editing It in Excel.

Configuring the Activity

In the Body of the Activity

  • Click Indicate target on screen to indicate the data to extract by following the Extract Wizard.
  • Extract to - Click Plus plus button on the right side of the field and then, from the menu, select what to do with the extracted data:
    • Select an Excel file and then a sheet, named range, or table where to copy the data. Alternatively you can click Indicate in Excel to select directly from the file.
    • Save for Later Use - Use the data later in your project as input for another activity.
    • Open in Advanced Editor - Enter a VB expression.
  • After you indicate the target, click Menu Options button to access the following options:
    • Indicate target on screen - Indicate the target again.
    • Configure Next Link - Configure the link to click for moving to the next page if the data spans multiple pages.
    • Test Extraction - Run a test of the data extraction with the current configuration. The result is displayed in the Preview Data window.

In the Properties Panel

Common

  • Continue on error - Specifies if the automation should continue even when the activity throws an error. This field only supports Boolean values (True, False). The default value is False. As a result, if the field is blank and an error is thrown, the execution of the project stops. If the value is set to True, the execution of the project continues regardless of any error.
  • Delay after - Delay (in seconds) between the time this activity is completed and the time the next activity begins any operations. The default value is 0.3 seconds. Adding a delay between activities ensures that one activity has enough time to complete before the next activity begins.
  • Delay before - Delay (in seconds) between the time the previous activity is completed and the time this activity begins performing any operations. The default value is 0.2 seconds. Adding a delay between activities ensures that one activity has enough time to complete before the next activity begins.
  • DisplayName - The name displayed for the activity in the Designer panel.
  • Timeout - Specify a number of seconds for which to wait for the activity to be executed before throwing an error. The default value is 30 seconds.

Input

  • ExtractMetadata - An XML string that enables you to define what data to extract from the indicated web page.

Misc

  • Private - If selected, the data used by the activity is not saved to the StudioX logs when the project is executed.

Options

  • DataTable - See Extract to in the body of the activity.
  • Delay between pages - The amount of time (in seconds) to wait until the next page is loaded. The default value is 0.3 seconds. If the loading time of the page is longer, this value should be higher.
  • Input mode - Select how to execute the click on the next page link if the data spans multiple pages:
    • Same as App/Browser - Use the same input mode as the Use Application/Browser activity. This is the default selection.
    • Window Messages - Sends a specific message to the target application. This input method can work in the background, is compatible with most desktop apps, but it is not the fastest of the methods.
    • Hardware Events - Simulates the click by using the hardware driver. This is the slowest method, it cannot work in the background, but it is compatible with all desktop apps.
    • Simulate - Simulates the click using the technology of the target application. This input method is the fastest and works in the background.
  • Maximum results - The maximum number of results to be extracted. If the value is 0, all the identified elements are added to the output. The default value is 100.

Updated 12 days ago


Extract Table Data


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.