EndPoint Get Table Rows
Name
get_table_rows
Description
Reads a Table of a Dataset.
Parameters
| Parameter |
Label |
Required |
Options |
Description |
| TableName |
TableName |
YES |
|
|
| DatasetId |
DatasetId |
NO |
|
|
| WorkspaceId |
WorkspaceId |
NO |
|
|
| DaxFilter |
DaxFilter |
NO |
| Option |
Value |
| All Rows |
true |
| 'Equal to' operator example |
[Column] = "AnyValue" |
| 'And' operator example |
[Column1] = "AnyValue1" && [Column2] = "AnyValue2" |
| 'And' and 'Or' operators used together |
[Column1] = "AnyValue" && ([Column2] = 1234 || [Column3] < 1000) |
| 'IN' operator example |
[Column] IN { "Value1", "Value2"} |
|
[API reference]
|
Output Columns
| Label |
Data Type (SSIS) |
Data Type (SQL) |
Length |
Raw |
Description |
| [$parent.Column Name$] |
DT_WSTR
|
nvarchar(4000)
|
4000 |
False |
|
Input Columns
| Label |
Data Type (SSIS) |
Data Type (SQL) |
Length |
Raw |
Description |
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. |
