-
Notifications
You must be signed in to change notification settings - Fork 7
/
DataflowConnector.m
27 lines (19 loc) · 1013 Bytes
/
DataflowConnector.m
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
let
// Connect to the Power Platform Dataflows
Source = PowerPlatform.Dataflows([]),
// Specify the Workspace Id. Replace <id> with your actual Workspace Id
_Workspace = "<id>",
// Specify the Dataflow Id. Replace <id> with your actual Dataflow Id
_Dataflow = "<id>",
// Specify the Entity (table) name. Replace <name> with your actual entity name
_Entity = "<name>",
// Access the list of Workspaces from the Dataflows source
Workspaces = Source{[Id = "Workspaces"]}[Data],
// Retrieve the specific Workspace using its Id
Workspace = Workspaces{[workspaceId = _Workspace]}[Data],
// Access the Dataflow within the specified Workspace using its Id
Dataflow = Workspace{[dataflowId = _Dataflow]}[Data],
// Retrieve the specific table (entity) data from the Dataflow. If a version is not specified, it defaults to the latest version
TableData = Dataflow{[entity = _Entity, version = ""]}[Data]
in
TableData