TeamDesk.SelectView
Syntax
TeamDesk.SelectView(
url as Uri.Type,
optional table as text,
optional view as text,
optional filter as text
) as table
Remarks
Retrieves the data from provided table and view. You can also apply an additional filter for results.
Examples
Example #1
Retrieve all meetings from List All view
TeamDesk.SelectView("https://www.teamdesk.net/secure/db/57692", "Meeting", "List All")
Result:
#table(
{ "Starter", "Start Date", "Participants" },
{
{ ""Joe"", #date(2018, 10, 12), 10 },
// ...
}
)
Example #2
Retrieve today's meetings from List All view
TeamDesk.SelectView("https://www.teamdesk.net/secure/db/57692", "Meeting", "List All", "[Start Date] = Today()")
Result:
#table(
{ "Starter", "Start Date", "Participants" },
{
{ ""Joe"", #date(2018, 10, 12), 10 },
// ...
}
)