Navigation: Catalog: Tickets3 > Schemas

Tickets: HubSpot Tickets

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

Catalog: Tickets3

Schema: Basic

Label: Tickets

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 Tickets. 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	string	☐		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	boolean	☐		Whether to return only results that have been archived.

Columns of Table Function

The columns of the table function Tickets 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
archived	boolean	Archived	☐
archivedAt	datetime	Archived at	☐
associations	string	Associations	☐
createdAt	datetime	Created at	☐
id	string	ID	☐
prop_closed_date	datetime	Closed Date	☐
prop_content	string	Content	☐
prop_created_by	decimal	Created by	☐
prop_createdate	datetime	Created at	☐
prop_first_agent_reply_date	datetime	First Agent Reply Date	☐
prop_hs_all_accessible_team_ids	string	All Accessible Team IDs	☐
prop_hs_all_associated_contact_companies	string	{res:itgen_hubspot_prop_hs_all_associated_contact_companies}	☐
prop_hs_all_associated_contact_emails	string	{res:itgen_hubspot_prop_hs_all_associated_contact_emails}	☐
prop_hs_all_associated_contact_firstnames	string	{res:itgen_hubspot_prop_hs_all_associated_contact_firstnames}	☐
prop_hs_all_associated_contact_lastnames	string	{res:itgen_hubspot_prop_hs_all_associated_contact_lastnames}	☐
prop_hs_all_associated_contact_mobilephones	string	{res:itgen_hubspot_prop_hs_all_associated_contact_mobilephones}	☐
prop_hs_all_associated_contact_phones	string	{res:itgen_hubspot_prop_hs_all_associated_contact_phones}	☐
prop_hs_all_conversation_mentions	string	All Conversation Mentions	☐
prop_hs_all_owner_ids	string	All Owner IDs	☐
prop_hs_all_team_ids	string	All Team IDs	☐
prop_hs_applied_sla_rule_config_at	datetime	{res:itgen_hubspot_prop_hs_applied_sla_rule_config_at}	☐
prop_hs_applied_sla_rule_config_id	decimal	{res:itgen_hubspot_prop_hs_applied_sla_rule_config_id}	☐
prop_hs_assigned_team_ids	string	{res:itgen_hubspot_prop_hs_assigned_team_ids}	☐
prop_hs_assignment_method	string	Assignment Method	☐
prop_hs_auto_generated_from_thread_id	decimal	Auto-generated from Thread ID	☐
prop_hs_conversations_originating_message_id	string	Conversations Originating Message ID	☐
prop_hs_conversations_originating_thread_id	decimal	Conversations Originating Thread ID	☐
prop_hs_created_by_user_id	decimal	Created by User ID	☐
prop_hs_createdate	datetime	Created at	☐
prop_hs_custom_inbox	decimal	Custom Inbox	☐
prop_hs_date_entered_1	datetime	Date Entered #1	☐
prop_hs_date_entered_2	datetime	Date Entered #2	☐
prop_hs_date_entered_3	datetime	Date Entered #3	☐
prop_hs_date_entered_4	datetime	Date Entered #4	☐
prop_hs_date_exited_1	datetime	Date Exited #1	☐
prop_hs_date_exited_2	datetime	Date Exited #2	☐
prop_hs_date_exited_3	datetime	Date Exited #3	☐
prop_hs_date_exited_4	datetime	Date Exited #4	☐
prop_hs_email_subject	string	Email Subject	☐
prop_hs_external_object_ids	string	External Object IDs	☐
prop_hs_file_upload	string	File Upload	☐
prop_hs_first_agent_message_sent_at	datetime	First Agent Message Sent at	☐
prop_hs_form_id	string	{res:itgen_hubspot_prop_hs_form_id}	☐
prop_hs_form_submission_conversion_id	string	{res:itgen_hubspot_prop_hs_form_submission_conversion_id}	☐
prop_hs_helpdesk_sort_timestamp	datetime	Helpdesk Sort Timestamp	☐
prop_hs_in_helpdesk	boolean	In Helpdesk	☐
prop_hs_inbox_id	decimal	Inbox ID	☐
prop_hs_is_latest_message_failed	boolean	{res:itgen_hubspot_prop_hs_is_latest_message_failed}	☐
prop_hs_is_latest_message_hidden_from_all	boolean	{res:itgen_hubspot_prop_hs_is_latest_message_hidden_from_all}	☐
prop_hs_is_visible_in_help_desk	boolean	{res:itgen_hubspot_prop_hs_is_visible_in_help_desk}	☐
prop_hs_last_closed_date	datetime	{res:itgen_hubspot_prop_hs_last_closed_date}	☐
prop_hs_last_email_activity	string	Last Email Activity	☐
prop_hs_last_email_date	datetime	Last Email Date	☐
prop_hs_last_email_id	decimal	{res:itgen_hubspot_prop_hs_last_email_id}	☐
prop_hs_last_email_type	string	{res:itgen_hubspot_prop_hs_last_email_type}	☐
prop_hs_last_message_from_visitor	boolean	Last Message from Visitor	☐
prop_hs_last_message_received_at	datetime	Last Message Received at	☐
prop_hs_last_message_sent_at	datetime	Last Message Sent at	☐
prop_hs_lastactivitydate	datetime	Last Activity Date	☐
prop_hs_lastcontacted	datetime	Last Contacted	☐
prop_hs_lastmodifieddate	datetime	Last Modified Date	☐
prop_hs_latest_message_attachment_types	string	{res:itgen_hubspot_prop_hs_latest_message_attachment_types}	☐
prop_hs_latest_message_is_forwarded_email	boolean	{res:itgen_hubspot_prop_hs_latest_message_is_forwarded_email}	☐
prop_hs_latest_message_seen_by_agent_ids	string	Latest Message Seen by Agent IDs	☐
prop_hs_latest_message_visible_to_visitor_sent_at	datetime	{res:itgen_hubspot_prop_hs_latest_message_visible_to_visitor_sent_at}	☐
prop_hs_latest_message_visible_to_visitor	string	{res:itgen_hubspot_prop_hs_latest_message_visible_to_visitor}	☐
prop_hs_merged_object_ids	string	Merged Object IDs	☐
prop_hs_most_relevant_sla_status	string	{res:itgen_hubspot_prop_hs_most_relevant_sla_status}	☐
prop_hs_most_relevant_sla_type	string	{res:itgen_hubspot_prop_hs_most_relevant_sla_type}	☐
prop_hs_msteams_message_id	string	Microsoft Teams Message ID	☐
prop_hs_nextactivitydate	datetime	Next Activity Date	☐
prop_hs_notes_next_activity_type	string	{res:itgen_hubspot_prop_hs_notes_next_activity_type}	☐
prop_hs_num_associated_companies	decimal	Number of Associated Companies	☐
prop_hs_num_associated_conversations	decimal	{res:itgen_hubspot_prop_hs_num_associated_conversations}	☐
prop_hs_num_times_contacted	decimal	Number of Times Contacted	☐
prop_hs_object_id	decimal	Object ID	☐
prop_hs_object_source_detail_1	string	{res:itgen_hubspot_prop_hs_object_source_detail_1}	☐
prop_hs_object_source_detail_2	string	{res:itgen_hubspot_prop_hs_object_source_detail_2}	☐
prop_hs_object_source_detail_3	string	{res:itgen_hubspot_prop_hs_object_source_detail_3}	☐
prop_hs_object_source_id	string	{res:itgen_hubspot_prop_hs_object_source_id}	☐
prop_hs_object_source_label	string	{res:itgen_hubspot_prop_hs_object_source_label}	☐
prop_hs_object_source_user_id	decimal	{res:itgen_hubspot_prop_hs_object_source_user_id}	☐
prop_hs_object_source	string	{res:itgen_hubspot_prop_hs_object_source}	☐
prop_hs_originating_channel_instance_id	string	Originating Channel Instance ID	☐
prop_hs_originating_email_engagement_id	decimal	Originating Email Engagement ID	☐
prop_hs_originating_generic_channel_id	string	Originating Generic Channel ID	☐
prop_hs_pinned_engagement_id	decimal	Pinned Engagement ID	☐
prop_hs_pipeline_stage	string	Pipeline Stage	☐
prop_hs_pipeline	string	Pipeline	☐
prop_hs_primary_company_id	decimal	{res:itgen_hubspot_prop_hs_primary_company_id}	☐
prop_hs_primary_company_name	string	{res:itgen_hubspot_prop_hs_primary_company_name}	☐
prop_hs_primary_company	string	{res:itgen_hubspot_prop_hs_primary_company}	☐
prop_hs_read_only	boolean	Read-only	☐
prop_hs_resolution	string	Resolution	☐
prop_hs_sales_email_last_replied	datetime	Sales Email Last Replied	☐
prop_hs_seen_by_agent_ids	string	{res:itgen_hubspot_prop_hs_seen_by_agent_ids}	☐
prop_hs_thread_ids_to_restore	string	Thread IDs to Restore	☐
prop_hs_ticket_category	string	Ticket Category	☐
prop_hs_ticket_id	decimal	Ticket ID	☐
prop_hs_ticket_priority	string	Ticket Priority	☐
prop_hs_time_in_1	decimal	Time in #1	☐
prop_hs_time_in_2	decimal	Time in #2	☐
prop_hs_time_in_3	decimal	Time in #3	☐
prop_hs_time_in_4	decimal	Time in #4	☐
prop_hs_unique_creation_key	string	Unique Creation Key	☐
prop_hs_updated_by_user_id	decimal	Updated by User ID	☐
prop_hs_user_ids_of_all_notification_followers	string	User IDs of All Notification Followers	☐
prop_hs_user_ids_of_all_notification_unfollowers	string	User IDs of All Notification Unfollowers	☐
prop_hs_user_ids_of_all_owners	string	User IDs of All Owners	☐
prop_hs_was_imported	boolean	Was Imported	☐
prop_hubspot_owner_assigneddate	datetime	Owner Assigned Date	☐
prop_hubspot_owner_id	string	Owner ID	☐
prop_hubspot_team_id	string	Team ID	☐
prop_last_engagement_date	datetime	Last Engagement Date	☐
prop_last_reply_date	datetime	Last Reply Date	☐
prop_notes_last_contacted	datetime	Notes Last Contacted	☐
prop_notes_last_updated	datetime	Notes Last Updated	☐
prop_notes_next_activity_date	datetime	Notes Next Activity Date	☐
prop_nps_follow_up_answer	string	NPS Follow-up Answer	☐
prop_nps_follow_up_question_version	decimal	NPS Follow-up Question Version	☐
prop_nps_score	string	NPS Score	☐
prop_num_contacted_notes	decimal	Number of Contacted Notes	☐
prop_num_notes	decimal	Number of Notes	☐
prop_source_ref	string	Source Reference	☐
prop_source_thread_id	string	Source Thread ID	☐
prop_source_type	string	Source Type	☐
prop_subject	string	Subject	☐
prop_tags	string	Tags	☐
prop_time_to_close	decimal	Time to Close	☐
prop_time_to_first_agent_reply	decimal	Time to First Agent Reply	☐
updatedAt	datetime	Updated at	☐

18-12-2024 20:09 Version 24.1.33-BETA+5180

Please enable JavaScript to view this site.

HubSpot API Data Model

Tickets: HubSpot Tickets

Parameters of Table Function

Columns of Table Function

Important Safety and Usage Information