查询视图数据

UiPath.Tableau.Activities.QueryViewData

使用 Tableau API以获取呈现为 CSV 的视图数据，并将其下载到您选择的文件夹中，和/或将数据保留在内存DataTable （视图数据）变量中。

工作方式

以下步骤是活动从设计时（即活动依赖项和输入/输出属性）到运行时如何工作的示例。

1. 完成设置步骤。
2. 将“Tableau 作用域”活动添加到您的项目中。
3. Add the Query View Data activity inside the Tableau Scope activity.
4. 创建并为“输入”属性输入值。
5. 输入“输出”属性的值。
6. 为“输出”属性创建并输入ResponseStatus变量。

在活动正文中

• Site ID - The ID of the site that contains the view. Enter a string or String variable or click the Find button to display the Find site window, where you can see all the site IDs found on the Tableau instance.
  1. Select a site ID and click Done. The Site ID property is automatically populated with the selected value.
  2. Copy the Site ID string, to use it in the View ID property.
• View ID - The ID of the view to render as data. Enter a string or String variable or click the Find button to display the Find View window.
  1. Paste the Site ID in the Site ID search field and click Find, to identify your View ID.
  2. Select your view and click Done. The View ID property is automatically populated with the correct value.
• Folder Path - The folder to download the report to. Enter a string or String variable.
• File Name - The filename you wish to use. Enter a string or String variable.
• 筛选值- 要用于筛选 workbook 视图的字段的值。输入字符串或String变量。格式： vf_<fieldname>=filter-value 。例如，具有筛选器vf_year=2017的 workbook 将仅显示 2017 年的数据。
• Max Age Minutes - The maximum number of minutes view data will be cached before being refreshed. Enter a string or String variable. To prevent multiple view data requests from overloading the server, the shortest interval you can set is one minute. There is no maximum value.
• View Data - The view data of the report. Enter a DataTable variable.

属性

常见

• DisplayName - The display name of the activity. This field supports only strings or String variables.

输入

• Client Timeout - Defines the client read timeout in seconds. Default value is 100.

其他

• “私有”- 选中后将不再以“Verbose”级别记录变量和参数的值。

输出

• ResponseStatus - The status of the request (success/failure information). This field supports only ResponseStatus variables.