ADO.NET Provider for Asana

Build 20.0.7655


Get task count of a project

Table Specific Information


The provider will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the provider.

  • ProjectId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM TaskStatuses where ProjectId = '1136437449978157'


Name Type References Description
ProjectId String


Globally unique ID of the project.
NumberofTasks Integer The number of tasks in a project.
CompletedTasks Integer The number of completed tasks in a project.
IncompleteTasks Integer The number of incomplete tasks in a project.
NumberofMilestones Integer The number of milestones in a project.
CompletedMilestones Integer The number of completed milestones in a project.
InCompleteMilestones Integer The number of incomplete milestones in a project.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655