Power Query
Search…
TeamDesk.SelectView

TeamDesk.SelectView

function (url as text, optional table as nullable any, optional view as nullable any, optional filter as nullable any) as table

Description

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

Category

Accessing data

Examples

Retrieve all meetings from List All view
TeamDesk.SelectView("https://www.teamdesk.net/secure/db/57692", "Meeting", "List All")

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()")

table(

{ "Starter", "Start Date", "Participants" },
{
{ ""Joe"", #date(2018, 10, 12), 10 },
// ...
}
)
Copy link
On this page
TeamDesk.SelectView
Description
Category
Examples