Skip to main content

TeamDesk.Select

Syntax​

TeamDesk.Select(
    url as Uri.Type,
    optional table as text,
    optional columns as any,
    optional filter as text,
    optional orderBy as any
) as table

Remarks​

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.

Examples​

Example #1​

Selects text and date columns

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

Result:

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