TeamDesk.SelectView

Updated on

TeamDesk.SelectView is a Power Query M function that retrieves data from a provided table and view. It also allows for the application of an additional filter for results.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

TeamDesk.SelectView(
   url as text,
   optional table as nullable text,
   optional view as nullable text,
   optional filter as nullable text,
) as table

Description

Retrieves the data from provided table and view. You can also apply an additional filter for results.

Examples

Retrieve all meetings from List All view

TeamDesk.SelectView( "https://www.teamdesk.net/secure/db/57692", "Meeting", "List All" )

 /* Output: 
#table( 
{ "Starter", "Start Date", "Participants" },
{
{ ""Joe"", #date( 2018, 10, 12 ), 10 },
// ...
}
 )
 */ 

Retrieve today’s meetings from List All view

TeamDesk.SelectView( "https://www.teamdesk.net/secure/db/57692", "Meeting", "List All", "[Start Date] = Today()" )

 /* Output: 
#table( 
{ "Starter", "Start Date", "Participants" },
{
{ ""Joe"", #date( 2018, 10, 12 ), 10 },
// ...
}
 )
 */ 

Other functions related to TeamDesk.SelectView are:

Contribute » | Contributors: Rick de Groot