JDBC Driver for Asana

Build 23.0.8839

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 driver 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 driver.

  • 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

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

The task is the basic object around which many operations in Asana are centered.

DependencyTaskId String True

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.

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