SSIS Components for Asana

Build 25.0.9434

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

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

StickerName String False

The name of the sticker in this story. null if there is no sticker.

The allowed values are green_checkmark, people_dancing, dancing_unicorn, heart, party_popper, people_waving_flags, splashing_narwhal, trophy, yeti_riding_unicorn, celebrating_people, determined_climbers, phoenix_spreading_love.

Type String True

Story type (comment or system)

Previews String True

A collection of previews to be displayed in the story. This property only exists for comment stories.

OldName String True

OldName

NewName String True

NewName

OldDatesStartOn Date True

The day on which work for this goal begins, or null if the goal has no start date. This takes a date with YYYY-MM-DD format, and cannot be set unless there is an accompanying due date.

OldDatesDueAt Datetime True

The UTC date and time on which this task is due, or null if the task has no due time. This takes an ISO 8601 date string in UTC and should not be used together with due_on.

OldDatesDueOn Date True

The localized day on which this goal is due. This takes a date with format YYYY-MM-DD.

NewDatesStartOn Date True

The day on which work for this goal begins, or null if the goal has no start date. This takes a date with YYYY-MM-DD format, and cannot be set unless there is an accompanying due date.

NewDatesDueAt Datetime True

The UTC date and time on which this task is due, or null if the task has no due time. This takes an ISO 8601 date string in UTC and should not be used together with due_on.

NewDatesDueOn Date True

The localized day on which this goal is due. This takes a date with format YYYY-MM-DD.

OldResourceSubtype String True

OldResourceSubtype

NewResourceSubtype String True

NewResourceSubtype

StoryId String True

Globally unique identifier of the resource, as a string.

StoryResourceType String True

The base type of this resource.

StoryCreatedAt Datetime True

The time at which this resource was created.

StoryCreatedById String True

Globally unique identifier of the resource, as a string.

StoryCreatedByResourceType String True

The base type of this resource.

StoryCreatedByName String True

Read-only except when same user as requester. The user's name.

StoryResourceSubtype String True

The subtype of this resource. Different subtypes retain many of the same fields and behavior, but may render differently in Asana or represent resources with different semantic meaning.

StoryText String True

Human-readable text for the story or comment. This will not include the name of the creator. This is not guaranteed to be stable for a given type of story. For example, text for a reassignment may not always say 'assigned to ...' as the text for a story can both be edited and change based on the language settings of the user making the request. Use the resource_subtype property to discover the action that created the story.

AssigneeId String True

Globally unique identifier of the resource, as a string.

AssigneeResourceType String True

The base type of this resource.

AssigneeName String True

Read-only except when same user as requester. The user's name.

FollowerId String True

Globally unique identifier of the resource, as a string.

FollowerResourceType String True

The base type of this resource.

FollowerName String True

Read-only except when same user as requester. The user's name.

OldSectionId String True

Globally unique identifier of the resource, as a string.

OldSectionResourceType String True

The base type of this resource.

OldSectionName String True

Read-only except when same user as requester. The user's name.

NewSectionId String True

Globally unique identifier of the resource, as a string.

NewSectionResourceType String True

The base type of this resource.

NewSectionName String True

Read-only except when same user as requester. The user's name.

StoryTaskId String True

Globally unique identifier of the resource, as a string.

StoryTaskResourceType String True

The base type of this resource.

StoryTaskName String True

The name of the task.

TaskResourceSubtype String True

The subtype of this resource. Different subtypes retain many of the same fields and behavior, but may render differently in Asana or represent resources with different semantic meaning.

TaskCreatedById String True

Globally unique identifier of the resource.

TaskCreatedByResourceType String True

The type of resource.

ProjectId String True

Globally unique identifier of the resource, as a string.

ProjectResourceType String True

The base type of this resource.

ProjectName String True

Name of the project. This is generally a short sentence fragment that fits on a line in the UI for maximum readability. However, it can be longer.

TagId String True

Globally unique identifier of the resource, as a string.

TagResourceType String True

The base type of this resource.

TagName String True

Name of the tag. This is generally a short sentence fragment that fits on a line in the UI for maximum readability. However, it can be longer.

CustomField String True

CustomField

OldTextValue String True

OldTextValue

NewTextValue String True

NewTextValue

OldNumberValue Integer True

OldNumberValue

NewNumberValue Integer True

NewNumberValue

OldEnumValue String True

OldEnumValue

NewEnumValue String True

NewEnumValue

OldDateValue String True

OldDateValue

NewDateValue String True

NewDateValue

OldPeopleValue String True

OldPeopleValue

NewPeopleValue String True

NewPeopleValue

OldMultiEnumValues String True

OldMultiEnumValues

NewMultiEnumValues String True

NewMultiEnumValues

NewApprovalStatus String True

The new value of approval status.

OldApprovalStatus String True

The old value of approval status.

DuplicateOf String True

DuplicateOf

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434