Stories

To Create, Update, Delete and Query from stories table. A story represents an activity associated with an object in the Asana system. Stories are generated by the system whenever users take actions such as creating or assigning tasks, or moving tasks between projects.

Table Specific Information

Select

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

Id supports the '=' comparison.
TaskId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Stories WHERE Id = '1126938691750986'

SELECT * FROM Stories WHERE TaskId = '1129514033997892'

Insert

TaskId is a mandatory column for inserting into Stories table. For example:

INSERT INTO Stories (Text, TaskId, IsPinned) VALUES ('InProgress', '1129514033997892', false)

Update

Following is an example of how to update a Stories table:

UPDATE Stories SET Text = 'story line' WHERE Id = '1126938691750986'

Delete

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

DELETE FROM Stories WHERE Id = '1126938691750986'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique ID of the story.
Text	String	False		Formatted text for the story or comment.
CreatedAt	Datetime	True		The time at which this story was created.
creatorId	String	True	Users.Id	The user who created the story.
creatorName	String	False	Users.Name	The user who created the story.
Source	String	True		The component of the Asana product the user used to create the story.
TaskId	String	False	Tasks.Id	The story under the task.
Liked	Boolean	True		True if the story is liked by the authorized user, false if not.
IsPinned	Boolean	False		This field is only present on comment and attachment stories.
IsEdited	Boolean	True		Whether the text of the story has been edited after creation.
ResourceType	String	True		The resource type of this resource.
ResourceSubType	String	True		The type of story. This provides fine-grained information about what triggered the story creation.
HtmlText	String	True		HTML formatted text for a comment.
DuplicateTaskOf	String	True	Tasks.Id	The task is the basic object around which many operations in Asana are centered.
DependencyTaskId	String	True	Tasks.Id	The task is the basic object around which many operations in Asana are centered.
NumberofLikes	Integer	True		The number of users who have liked this story.
Likes	String	True		Array of likes for users who have liked this story.