Parameters   Output Objects  

Searches and updates Asana data.

Syntax

Invoke-Asana [parameters]

Remarks

The Invoke-Asana cmdlet allows you to use SQL statements to execute any SQL statement directly. Below is the syntax for a parameterized query:

$query = Invoke-Asana -Connection $connection -Query 'SELECT * FROM projects WHERE Archived=@Archived' -Params @{'@Archived'='true'}

This cmdlet is also useful for executing stored procedures. Use the EXEC keyword to call a stored procedure:

$query = Invoke-Asana -Connection $connection -Query 'EXEC UploadAttachment TaskId = @TaskId' -Params @{"1128092964672854"}