SSIS Components for Asana

Build 20.0.7656

UserTaskList

Generated schema file.

Table Specific Information

Select

The component will use the Asana API to process WHERE clause conditions built with the following column and operator. The [UserId and workspaceId] or Id is required to make a request and the rest of the filter is executed client side within the component.

  • Id supports the '=' comparison.
  • UserId supports the '=' comparison.
  • workspaceId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM UserTaskList WHERE Id = '1126938837961837'

SELECT * FROM UserTaskList WHERE UserId = '1126938691750986' and workspaceId = '1126938837961830'

Columns

Name Type References Description
Id [KEY] String

WorkspaceMembership.UserTaskListId

Globally unique ID of the user task list.
Name String The name of the user task list.
UserId String

Users.Id

The owner of the user task list
workspaceId String

Workspaces.Id

The workspace in which the user task list is located
ResourceType String The resource type of this resource.

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