Endpoint Get Dataflows
Name
get_dataflows
Description
Get Dataflows from default or specified Workspace. If WorkspaceId parameter is not supplied, default Workspace will be used. [API reference]
Related Tables
Parameters
| Parameter | Required | Options |
|---|---|---|
|
Name:
Label: WorkspaceId |
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
|---|---|---|---|---|
| Id |
DT_STR
|
varchar(36)
|
36 | |
| Name |
DT_WSTR
|
nvarchar(150)
|
150 | |
| Description |
DT_WSTR
|
nvarchar(1000)
|
1000 | |
| ConfiguredBy |
DT_WSTR
|
nvarchar(500)
|
500 | |
| Users |
DT_NTEXT
|
nvarchar(MAX)
|
||
| Generation |
DT_I4
|
int
|
Input Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Examples
SSIS
Use Power BI Connector in API Source or in API Destination SSIS Data Flow components to read or write data.
API Source
This Endpoint belongs to the Dataflows table, therefore it is better to use it, instead of accessing the endpoint directly:
| Optional Parameters | |
|---|---|
| WorkspaceId | |
API Destination
This Endpoint belongs to the Dataflows table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get dataflows:
| Optional Parameters | |
|---|---|
| WorkspaceId | |
ODBC application
Use these SQL queries in your ODBC application data source:
Dataflows - Get Dataflows
SELECT *
FROM Dataflows
get_dataflows endpoint belongs to
Dataflows
table(s), and can therefore be used via those table(s).
SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Dataflows - Get Dataflows
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT *
FROM Dataflows';
EXEC (@MyQuery) AT [LS_TO_POWER_BI_IN_GATEWAY];
get_dataflows endpoint belongs to
Dataflows
table(s), and can therefore be used via those table(s).