TeamDesk.Select

TeamDesk.Select

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

Description

Retrieves the data from select columns in provided table. You can also apply an additional filter for results as well as change the order in which records are retrieved.

Category

Accessing data

Examples

Selects text and date columns

TeamDesk.Select("https://www.teamdesk.net/secure/db/57692", "Meeting", { "Starter", "Start Date", "Participants" })

table(

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

)