Bring data from Asana to your Lakehouse.
https://app.asana.com/admin/
. Alternatively, if you’re logged in with your account, you can click this link and simply copy the gid
value.Tip: The stream can be found more easily by typing its name.Select the streams and click Next.
Projects
gid
: Unique identifier for the projectname
: Name of the projectresource_type
: The project typeTasks
gid
: Unique identifier for the taskname
: Name/title of the taskresource_type
: The resource type (task)resource_subtype
: The resource subtype (e.g., default_task)created_by
: User who created the task (includes gid, resource_type)approval_status
: The approval status of the taskassignee_status
: Status of the task for the assigneecompleted
: Whether the task is completedcompleted_at
: When the task was completedcompleted_by
: User who completed the task (includes gid, resource_type, name)created_at
: When the task was createddependencies
: Array of tasks this task depends ondependents
: Array of tasks that depend on this taskdue_at
: The due time for the taskdue_on
: The due date for the taskhtml_notes
: Task notes in HTML formatnotes
: Task notes in plain texthearted
: Whether the task is hearted/favoritedhearts
: Array of hearts on the task (includes user details)is_rendered_as_separator
: Whether the task is rendered as a separatorliked
: Whether the task is likedlikes
: Array of likes on the task (includes user details)modified_at
: When the task was last modifiednum_hearts
: Number of hearts on the tasknum_likes
: Number of likes on the tasknum_subtasks
: Number of subtasksstart_at
: The start time for the taskstart_on
: The start date for the taskactual_time_minutes
: The actual time spent on the task in minutesassignee
: User assigned to the task (includes gid, resource_type, name)assignee_section
: Section this task is assigned to (includes gid, resource_type, name)custom_fields
: Array of custom fields with detailed information including:
custom_type
: Custom type for this task (includes gid, resource_type, name)custom_type_status_option
: Custom type status option (includes gid, resource_type, name)followers
: Array of users following this task (includes gid, resource_type, name)parent
: Parent task details (includes gid, name, resource_type, created_by)projects
: Array of projects this task belongs to (includes gid, resource_type, name)tags
: Array of tags applied to this task (includes gid, resource_type, name)workspace
: Workspace this task belongs to (includes gid, resource_type, name)permalink_url
: Direct URL to the task in AsanaSubtasks
gid
: Unique identifier for the subtasktask_id
: Parent task ID from contextresource_type
: The resource type (task)name
: Name of the subtaskresource_subtype
: The resource subtype (e.g., default_task)created_by
: User who created this subtaskapproval_status
: Approval status of the subtaskassignee_status
: Assignee status of the subtaskcompleted
: Whether the subtask is completedcompleted_at
: When the subtask was completedcompleted_by
: User who completed this subtaskcreated_at
: When the subtask was createddependencies
: Array of tasks this subtask depends ondependents
: Array of tasks that depend on this subtaskdue_at
: Due time for the subtaskdue_on
: Due date for the subtaskhtml_notes
: Subtask notes in HTML formatnotes
: Subtask notes in plain texthearted
: Whether the current user hearted the subtaskhearts
: Array of hearts on the subtaskis_rendered_as_separator
: Whether rendered as a separatorliked
: Whether the current user liked the subtasklikes
: Array of likes on the subtaskmodified_at
: When the subtask was last modifiednum_hearts
: Number of hearts on the subtasknum_likes
: Number of likes on the subtasknum_subtasks
: Number of subtasks of this subtaskstart_at
: Start time for the subtaskstart_on
: Start date for the subtaskactual_time_minutes
: Actual time spent in minutesassignee
: User assigned to this subtaskassignee_section
: Section this subtask is assigned tocustom_fields
: Array of custom fields with detailed informationcustom_type
: Custom type for this subtaskcustom_type_status_option
: Custom type status optionfollowers
: Array of users following this subtaskparent
: Parent task detailsprojects
: Array of projects this subtask belongs totags
: Array of tags applied to this subtaskworkspace
: Workspace this subtask belongs topermalink_url
: Direct URL to the subtask in AsanaTeams
gid
: Unique identifier for the teamname
: Name of the teamresource_type
: The resource type (team)description
: Team descriptionhtml_description
: Team description in HTML formatorganization
: Organization this team belongs to (includes gid, resource_type, name)visibility
: Visibility of the team (public, private)created_at
: When this team was createdupdated_at
: When this team was last updatedpermalink_url
: Direct URL to the team in AsanaUsers
gid
: Unique identifier for the username
: User’s full nameresource_type
: The resource type (user)email
: User’s email addressphoto
: User’s profile photo URLs in various sizes:
workspaces
: Array of workspaces the user belongs to (includes gid, resource_type, name)Tags
Stories
gid
: Unique identifier for the storytask_id
: The parent task ID this story belongs toresource_type
: The resource type (story)created_at
: When the story was createdcreated_by
: User who created the story (includes gid, resource_type, name)resource_subtype
: The resource subtype (e.g., comment_added)text
: The plain text of the storyhtml_text
: The HTML text of the storyis_editable
: Whether the story is editabletarget
: Target object of this story (includes gid, resource_type, name)action_taken
: The action takenold_resource_subtype
: The old resource subtypenew_resource_subtype
: The new resource subtypeold_text
: The old textnew_text
: The new textold_name
: The old namenew_name
: The new nameold_dates
: Previous dates (due_on, due_at, start_on, start_at)new_dates
: Updated dates (due_on, due_at, start_on, start_at)old_number_value
: The old number valuenew_number_value
: The new number valueold_enum_value
: Previous enum value detailsnew_enum_value
: Updated enum value detailsold_multi_enum_values
: Previous multi-enum valuesnew_multi_enum_values
: Updated multi-enum valuesold_custom_field_value
: Previous custom field value detailsnew_custom_field_value
: Updated custom field value detailspreviews
: Array of previews for this story (includes text, links, headers)attachments
: Array of attachments (includes metadata and URLs)Custom Fields
gid
: Unique identifier for the custom fieldresource_type
: The resource type (custom_field)resource_subtype
: The resource subtype (e.g., text, number, enum)name
: Name of the custom fielddescription
: Description of the custom fieldtype
: Type of the custom field (text, number, enum, multi_enum, date, people)enum_options
: Array of possible values for enum custom fields, each containing:
enabled
: Whether the custom field is enabledrepresentation_type
: The representation type of the custom fieldid_prefix
: The ID prefix for the custom fieldis_formula_field
: Whether it’s a formula fieldnumber_value
: The number value for number custom fieldstext_value
: The text value for text custom fieldsdisplay_value
: The display value for the custom fielddate_value
: The date value for date custom fields (date and date_time)enum_value
: The enum value for enum custom fieldsmulti_enum_values
: Array of values for multi_enum custom fieldspeople_value
: Array of users for people custom fieldscreated_by
: User who created the custom fieldprecision
: Number of decimal places for number fieldsformat
: Format of the custom fieldcurrency_code
: Currency code for currency fieldscustom_label
: Custom label for the fieldcustom_label_position
: Position of custom label (prefix, suffix)is_global_to_workspace
: Whether global to workspacehas_notifications_enabled
: Whether notifications are enabledasana_created_field
: The Asana created field typeis_value_read_only
: Whether the value is read-onlyprivacy_setting
: Privacy setting for the custom fielddefault_access_level
: Default access level for the custom fieldPortfolios
gid
: Unique identifier for the portfolioname
: Name of the portfolioresource_type
: The portfolio typearchived
: Whether the portfolio is archivedcolor
: Color assigned to the portfoliocreated_at
: When the portfolio was createdcreated_by
: User who created the portfolio (includes gid, resource_type, name)custom_field_settings
: Array of custom field settings with detailed configurationcurrent_status_update
: Current status update details (includes title and type)due_on
: Due date for the portfoliocustom_fields
: Array of custom fields with values and configurationmembers
: Array of users who are members of this portfolioowner
: Owner of this portfolio (includes gid, resource_type, name)start_on
: Start date for the portfolioworkspace
: Workspace this portfolio belongs to (includes gid, resource_type, name)permalink_url
: Direct URL to the portfolio in Asanapublic
: Whether the portfolio is public to its teamdefault_access_level
: Default access level for the portfolioprivacy_setting
: Privacy setting for the portfolioproject_templates
: Array of project templates associated with this portfolioPortfolio Items
gid
: Unique identifier for the project/itemresource_type
: The resource type (project)name
: The project/item nameportfolio_id
: The portfolio ID this item belongs toPortfolio Custom Fields
gid
: Unique identifier for the custom field settingresource_type
: The resource type (custom_field_setting)project
: Project this setting belongs to (if applicable)portfolio
: Portfolio this setting belongs tocustom_field
: Detailed custom field information including:
is_important
: Whether this custom field is marked as importantparent
: Parent portfolio/project for this settingcreated_at
: When this setting was createdcreated_by
: User who created this settingportfolio_id
: Portfolio ID this setting belongs toProject Custom Fields
gid
: Unique identifier for the custom field settingresource_type
: The resource type (custom_field_setting)project
: Project this setting belongs tocustom_field
: Detailed custom field information including:
is_important
: Whether this custom field is marked as importantparent
: Parent project for this settingcreated_at
: When this setting was createdcreated_by
: User who created this settingproject_id
: Project ID this setting belongs toProject Statuses
gid
: Unique identifier for the status updateproject_id
: The parent project ID this status belongs toresource_type
: The resource type (project_status)title
: Title of the status updatetext
: Text content of the status updatehtml_text
: HTML content of the status updatecolor
: Color of the statuscreated_at
: When the status was createdcreated_by
: User who created the status (includes gid, resource_type, name)author
: Author of the status (includes gid, resource_type, name)modified_at
: When the status was last modifiedstatus_type
: Type of status (on_track, at_risk, off_track, on_hold, complete)liked
: Whether the current user has liked this statuslikes
: Array of users who liked this statusnum_likes
: Number of likes on this statushearts
: Array of users who hearted this statusnum_hearts
: Number of hearts on this statusTime Tracking Entries
gid
: Unique identifier for the time entryresource_type
: The resource type (time_tracking_entry)created_at
: When the time entry was createdcreated_by
: User who created the entry (includes gid, resource_type, name)completed
: Whether the entry is completedcompleted_at
: When the entry was completedduration_minutes
: Duration of the entry in minutesnotes
: Notes for the time entryhtml_notes
: Notes in HTML formatuser
: User who performed this time trackingtask
: Task this entry is associated with (includes gid, resource_type, name)project
: Project this entry is associated with (includes gid, resource_type, name)workspace
: Workspace this entry belongs to (includes gid, resource_type, name)time_period
: Time period details including:
Allocations
gid
: Unique identifier for the allocationproject_id
: The project ID from contextresource_type
: The resource type (allocation)resource_subtype
: The resource subtype (e.g., project_allocation)start_date
: Start date of the allocation periodend_date
: End date of the allocation periodeffort
: Effort details including:
assignee
: User assigned to this allocation (includes gid, name, resource_type)created_by
: User who created this allocation (includes gid, name, resource_type)parent
: Parent project this allocation belongs to (includes gid, name, resource_type)Goals
gid
: Unique identifier for the goalresource_type
: The resource type (goal)name
: Name of the goalhtml_notes
: Goal notes in HTML formatnotes
: Goal notes in plain textdue_on
: Due date for the goalstart_on
: Start date for the goalis_workspace_level
: Whether the goal is workspace-levelliked
: Whether the current user liked the goallikes
: Array of likes on the goalnum_likes
: Number of likes on the goalteam
: Team associated with this goal (includes gid, resource_type, name)workspace
: Workspace this goal belongs to (includes gid, resource_type, name)followers
: Array of users following this goaltime_period
: Time period details including:
metric
: Associated metric details including:
owner
: Owner of this goal (includes gid, resource_type, name)current_status_update
: Current status update detailsstatus
: Status of the goal (green, yellow, red)