Navigation: Catalog: Tasks > Schemas

Tasks: HubSpot Tasks

ListRead a page of tasks. Control what is returned via the `properties` query param.

Catalog: Tasks

Schema: Basic

Label: Tasks

Retrieve: true

Insert: true

Update: false

Delete: false

Parameters of Table Function

The following parameters can be used to control the behaviour of the table function Tasks. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name	Data Type	Required	Default Value	Documentation
after		☐		The paging cursor token of the last successfully read resource will be returned as the `paging.next.after` JSON property of a paged response containing more results.
archived		☐		Whether to return only results that have been archived.

Columns of Table Function

The columns of the table function Tasks are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert.

Name	Data Type	Label	Required	Documentation
archived	char	Archived	☐	Whether the object is archived.
archivedAt	datetime	Archived at	☐	The timestamp when the object was archived, in ISO 8601 format.
associations	varchar2	Associations	☐	A list defining relationships with other objects.
createdAt	datetime	Created at	☐	The timestamp when the object was created, in ISO 8601 format.
id	varchar2	ID	☐	The unique ID of the object.
objectWriteTraceId	varchar2		☐	An identifier used for tracing the creation or update request of the object.
prop_hs_all_accessible_team_ids	varchar2	All Accessible Team IDs	☐
prop_hs_all_assigned_business_unit_ids	varchar2	All Assigned Business Unit IDs	☐
prop_hs_all_owner_ids	varchar2	All Owner IDs	☐
prop_hs_all_team_ids	varchar2	All Team IDs	☐
prop_hs_associated_company_labels	varchar2		☐
prop_hs_associated_contact_labels	varchar2		☐
prop_hs_at_mentioned_owner_ids	varchar2	At Mentioned Owner IDs	☐
prop_hs_attachment_ids	varchar2	Attachment IDs	☐
prop_hs_body_preview_html	varchar2	Body Preview (HTML)	☐
prop_hs_body_preview_is_truncated	char	Body Preview is Truncated	☐
prop_hs_body_preview	varchar2	Body Preview	☐
prop_hs_calendar_event_id	varchar2	Calendar Event ID	☐
prop_hs_created_by_user_id	decimal	Created by User ID	☐
prop_hs_created_by	decimal	Created by	☐
prop_hs_createdate	datetime	Created at	☐
prop_hs_date_entered_60b5c368_04c4_4d32_9b4a_457e159f49b7_13292096	datetime		☐
prop_hs_date_entered_61bafb31_e7fa_46ed_aaa9_1322438d6e67_1866552342	datetime		☐
prop_hs_date_entered_af0e6a5c_2ea3_4c72_b69f_7c6cb3fdb591_1652950531	datetime		☐
prop_hs_date_entered_dd5826e4_c976_4654_a527_b59ada542e52_2144133616	datetime		☐
prop_hs_date_entered_fc8148fb_3a2d_4b59_834e_69b7859347cb_1813133675	datetime		☐
prop_hs_date_exited_60b5c368_04c4_4d32_9b4a_457e159f49b7_13292096	datetime		☐
prop_hs_date_exited_61bafb31_e7fa_46ed_aaa9_1322438d6e67_1866552342	datetime		☐
prop_hs_date_exited_af0e6a5c_2ea3_4c72_b69f_7c6cb3fdb591_1652950531	datetime		☐
prop_hs_date_exited_dd5826e4_c976_4654_a527_b59ada542e52_2144133616	datetime		☐
prop_hs_date_exited_fc8148fb_3a2d_4b59_834e_69b7859347cb_1813133675	datetime		☐
prop_hs_engagement_source_id	varchar2	Engagement Source ID	☐
prop_hs_engagement_source	varchar2	Engagement Source	☐
prop_hs_engagements_last_contacted	datetime		☐
prop_hs_follow_up_action	varchar2	Follow-up Action	☐
prop_hs_gdpr_deleted	char	GDPR Deleted	☐
prop_hs_lastmodifieddate	datetime	Last Modified Date	☐
prop_hs_marketing_studio_node_id	varchar2		☐
prop_hs_marketing_task_category_id	decimal		☐
prop_hs_marketing_task_category	varchar2		☐
prop_hs_merged_object_ids	varchar2	Merged Object IDs	☐
prop_hs_modified_by	decimal	Modified by	☐
prop_hs_msteams_message_id	varchar2	Microsoft Teams Message ID	☐
prop_hs_obj_coords	varchar2		☐
prop_hs_object_id	decimal	Object ID	☐
prop_hs_object_source_detail_1	varchar2		☐
prop_hs_object_source_detail_2	varchar2		☐
prop_hs_object_source_detail_3	varchar2		☐
prop_hs_object_source_id	varchar2		☐
prop_hs_object_source_label	varchar2		☐
prop_hs_object_source_user_id	decimal		☐
prop_hs_object_source	varchar2		☐
prop_hs_owning_teams	varchar2		☐
prop_hs_partner_map_category	varchar2		☐
prop_hs_partner_map_year	varchar2		☐
prop_hs_pinned_engagement_id	decimal	Pinned Engagement ID	☐
prop_hs_pipeline_stage	varchar2	Pipeline Stage	☐
prop_hs_pipeline	varchar2	Pipeline	☐
prop_hs_product_name	varchar2	Product Name	☐
prop_hs_queue_membership_ids	varchar2	Queue Membership IDs	☐
prop_hs_read_only	char	Read-only	☐
prop_hs_repeat_status	varchar2	Repeat Status	☐
prop_hs_scheduled_tasks	varchar2	Scheduled Tasks	☐
prop_hs_start_date	datetime		☐
prop_hs_task_assigned_by_user_id	varchar2		☐
prop_hs_task_body	varchar2	Task Body	☐
prop_hs_task_campaign_guid	varchar2		☐
prop_hs_task_completion_count	decimal	Task Completion Count	☐
prop_hs_task_completion_date	datetime	Task Completion Date	☐
prop_hs_task_contact_timezone	varchar2	Task Contact Timezone	☐
prop_hs_task_family	varchar2	Task Family	☐
prop_hs_task_for_object_type	varchar2	Task for Object Type	☐
prop_hs_task_is_all_day	char	Task Is All Day	☐
prop_hs_task_is_completed_call	decimal	Task Is Completed Call	☐
prop_hs_task_is_completed_email	decimal	Task Is Completed Email	☐
prop_hs_task_is_completed_linked_in	decimal	Task Is Completed LinkedIn	☐
prop_hs_task_is_completed_sequence	decimal	Task Is Completed Sequence	☐
prop_hs_task_is_completed	decimal	Task Is Completed	☐
prop_hs_task_is_overdue	char		☐
prop_hs_task_is_past_due_date	char		☐
prop_hs_task_is_sub_task	char		☐
prop_hs_task_last_contact_outreach	datetime	Task Last Contact Outreach	☐
prop_hs_task_last_sales_activity_timestamp	datetime	Task Last Sales Activity Timestamp	☐
prop_hs_task_missed_due_date_count	decimal		☐
prop_hs_task_missed_due_date	char		☐
prop_hs_task_ms_teams_payload	varchar2		☐
prop_hs_task_parent_task_associated_objects	varchar2		☐
prop_hs_task_parent_task_id	decimal		☐
prop_hs_task_parent_task_owner_ids	varchar2		☐
prop_hs_task_priority	varchar2	Task Priority	☐
prop_hs_task_probability_to_complete	decimal	Task Probability to Complete	☐
prop_hs_task_relative_reminders	varchar2	Task Relative Reminders	☐
prop_hs_task_reminders	varchar2	Task Reminders	☐
prop_hs_task_repeat_interval	varchar2	Task Repeat Interval	☐
prop_hs_task_send_default_reminder	char	Task Send Default Reminder	☐
prop_hs_task_sequence_enrollment_active	char	Task Sequence Enrollment Active	☐
prop_hs_task_sequence_id	varchar2		☐
prop_hs_task_sequence_step_enrollment_contact_id	varchar2		☐
prop_hs_task_sequence_step_enrollment_id	varchar2	Task Sequence Step Enrollment ID	☐
prop_hs_task_sequence_step_order	decimal	Task Sequence Step Order	☐
prop_hs_task_status	varchar2	Task Status	☐
prop_hs_task_sub_task_at_mentioned_owner_ids	varchar2		☐
prop_hs_task_sub_task_ids	decimal		☐
prop_hs_task_sub_task_owner_ids	varchar2		☐
prop_hs_task_subject	varchar2	Task Subject	☐
prop_hs_task_template_id	decimal	Task Template ID	☐
prop_hs_task_type	varchar2	Task Type	☐
prop_hs_task_uncompleted_sub_task_ids	decimal		☐
prop_hs_time_in_60b5c368_04c4_4d32_9b4a_457e159f49b7_13292096	decimal		☐
prop_hs_time_in_61bafb31_e7fa_46ed_aaa9_1322438d6e67_1866552342	decimal		☐
prop_hs_time_in_af0e6a5c_2ea3_4c72_b69f_7c6cb3fdb591_1652950531	decimal		☐
prop_hs_time_in_dd5826e4_c976_4654_a527_b59ada542e52_2144133616	decimal		☐
prop_hs_time_in_fc8148fb_3a2d_4b59_834e_69b7859347cb_1813133675	decimal		☐
prop_hs_timestamp	datetime	Timestamp	☐
prop_hs_unique_creation_key	varchar2	Unique Creation Key	☐
prop_hs_unique_id	varchar2	Unique ID	☐
prop_hs_updated_by_user_id	decimal	Updated by User ID	☐
prop_hs_user_ids_of_all_notification_followers	varchar2	User IDs of All Notification Followers	☐
prop_hs_user_ids_of_all_notification_unfollowers	varchar2	User IDs of All Notification Unfollowers	☐
prop_hs_user_ids_of_all_owners	varchar2	User IDs of All Owners	☐
prop_hs_was_imported	char	Was Imported	☐
prop_hubspot_owner_assigneddate	datetime	Owner Assigned Date	☐
prop_hubspot_owner_id	varchar2	Owner ID	☐
prop_hubspot_team_id	varchar2	Team ID	☐
updatedAt	datetime	Updated at	☐	The timestamp when the object was last updated, in ISO 8601 format.
url	varchar2	URL	☐	The URL on the API that provide direct navigation to the corresponding UI pages for the connectors.

Please enable JavaScript to view this site.

HubSpot API Data Model

Tasks: HubSpot Tasks

Parameters of Table Function

Columns of Table Function

Important Safety and Usage Information