Excel Add-In for Asana

Build 24.0.9060

StatusUpdates

A status update is an update on the progress of a particular object, and is sent out to all followers when created.

Table Specific Information

Select

The add-in 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 add-in.

  • Id supports the '=' comparison.
  • ParentId supports the '=' comparison.

For example, the following queries are processed server side: 

SELECT * FROM StatusUpdates

SELECT * FROM StatusUpdates WHERE Id = '1126938837961834'

SELECT * FROM StatusUpdates WHERE ParentId = '1126938837961834'

Insert

Text, StatusType and ParentId are mandatory columns for inserting into StatusUpdates table. For example: 

INSERT INTO StatusUpdates(ParentId,Title,Text,StatusType) VALUES('1203125557018928','asd','tewr','on_track')

Delete

Following is an example of how to delete from StatusUpdates table: 

DELETE FROM StatusUpdates WHERE Id = '1161963899354167'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Globally unique identifier of the resource, as a string.

AuthorId String True

A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. Globally unique identifier of the resource.

AuthorName String True

A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. The user�s name.

AuthorResourceType String True

A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. The base type of this resource.

CreatedAt Datetime True

The time at which this resource was created.

CreatedById String True

A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. Globally unique identifier of the resource.

CreatedByName String True

A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. The user�s name.

CreatedByResourceType String True

A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. The base type of this resource.

Liked Boolean True

True if the status is liked by the authorized user, false if not.

Likes String True

Array of likes for users who have liked this status.

ModifiedAt Datetime True

The time at which this project status was last modified.

NumLikes Integer True

The number of users who have liked this status.

ParentId String False

Id of parent of the status update.

ParentName String True

Name of parent of the status update.

ParentResourceType String True

Resource type of parent of the status update.

ResourceSubtype String True

The subtype of this resource.

ResourceType String True

The base type of this resource.

StatusType String False

The type associated with the status update.

The allowed values are on_track, at_risk, off_track, on_hold, complete, achieved, partial, missed, dropped.

Text String False

The text content of the status update.

HTMLText String False

The text content of the status update with formatting as HTML.

Title String False

The title of the status update.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060