CData BizTalk Adapter for HubSpot 2019 - Online Help
Questions / Feedback?

Tickets

CData BizTalk Adapter for HubSpot 2019 - Build 19.0.7424

Retrieve the available Tickets in HubSpot.

Columns

Name Type ReadOnly Filterable Description
Id [KEY] Long False true

Unique identifier of the ticket.

Archived Bool True false

Whether the ticket is archived or not.

CreatedAt Datetime True false

When the ticket was created.

UpdatedAt Datetime True false

When the ticket was last updated.

Close_date Datetime False true

The date the ticket was closed

Created_by Double False true

VID of contact that created the ticket

Create_date Datetime False true

The date the ticket was created

First_agent_email_response_date Datetime True true

The date of the first email response from an agent after a ticket was created

Conversations_originating_thread_id Double False true

Thread that this ticket was originally created for

Created_by_user_ID Double True true

The user that created this object. This value is automatically set by HubSpot and may not be modified.

Hubspot_create_date Datetime True true

Internal read-only property representing the date the ticket was created in Hubspot

Custom_inbox_ID Double False true

ID of the custom inbox the ticket is associated with

External_object_ids String False true

Unique ids corresponding to tickets in a system outside of HubSpot

Last_CES_survey_comment String True true

Last CES survey comment that this contact gave for this ticket

Last_CES_survey_rating String True true

Last CES survey rating that this contact gave for this ticket

Last_CES_survey_date Datetime True true

The time that this contact last submitted a CES survey response. This is automatically set by HubSpot.

File_upload String False true

Files attached to a support form by a contact.

Last_email_activity String True true

The type of the last email activity with the contact associated with the ticket.

Last_email_date Datetime True true

The date of the last email activity with the contact associated with the ticket.

Last_activity_date Datetime True true

The last time a note, call, email, meeting, or task was logged for a ticket. This is updated automatically by HubSpot.

Last_contacted_date Datetime True true

The last time a call, conversation, email, or meeting was logged for this ticket. This is set automatically by HubSpot based on user actions.

Last_modified_date Datetime True true

The last time any property on the ticket was modified

Merged_ticket_ids String True true

All ticket ids for this ticket

Next_activity_date Datetime True true

The date of the next upcoming activity for a ticket. This property is set automatically by HubSpot based on user action. This includes logging a future call, email, or meeting using the Log feature, as well as creating a future task or scheduling a future meeting. This is updated automatically by HubSpot.

Number_of_companies Double True true

Number of companies associated with this ticket

Number_of_times_contacted Double True true

The number of times a call, email, or meeting was logged on the ticket

Object_ID Double True true

The unique ID for this ticket. This unique ID is automatically populated by HubSpot and cannot be changed.

Originating_email_engagement_id Double True true

Engagement id of the email originating this ticket

Pipeline String False true

The pipeline that contains this ticket

Ticket_status String False true

The pipeline stage that contains this ticket

Resolution String False true

The action taken to resolve the ticket

Category String False true

Main reason customer reached out for help

Ticket_ID Double True true

The unique ID for this ticket. This unique ID is automatically populated by HubSpot and cannot be changed.

Priority String False true

The level of attention needed on the ticket

Updated_by_user_ID Double True true

The user that last updated this object. This value is automatically set by HubSpot and may not be modified.

Owner_assigned_date Datetime True true

The date an owner was assigned to the ticket

Date_of_last_engagement Datetime True true

The date of the last reply or note

Last_customer_reply_date Datetime True true

The date of the last customer response

NPS_follow_up String False true

Answer to NPS follow up question

NPS_follow_up_question Double False true

Specific version of NPS follow up question that was asked

Conversation_NPS_score String False true

NPS score received after ticket resolution

Reference_to_email_thread String False true

The id of an email thread with ticket conversation

Time_to_close Double True true

The time between when the ticket was created and closed

Time_to_first_agent_email_reply Double True true

The time from the ticket create date to the first agent email reply

Ticket_name String False true

Short summary of ticket

Ticket_description String False true

Description of the ticket

Source String False true

Channel where ticket was originally submitted

Reference_to_sourceSpecific_object String False true

The id of a connected source object

Tags String False true

Tags associated with your tickets

Recent_Sales_Email_Replied_Date Datetime True true

The last time a tracked sales email was replied to for this ticket

Ticket_owner String False true

The user from your team that the ticket is assigned to. You can assign additional users to a ticket record by creating a custom HubSpot user property.

Last_Contacted_Ticket_Note_ Datetime True true

The last timestamp when a call, email or meeting was logged for this ticket

Last_Activity_Date_Ticket_Note_ Datetime True true

The last time a note, call, email, meeting, or task was logged for a ticket. This is set automatically by HubSpot based on user actions in the ticket record.

Next_Activity_Date_Ticket_Note_ Datetime True true

The date of the next upcoming activity for this ticket

Number_of_times_contacted_Ticket_Note_ Double True true

The number of times a call, email or meeting was logged for this ticket

Number_of_Sales_Activities Double True true

Number of sales activities for this ticket

HubSpot_team String True true

The Primary team of the ticket owner for the ticket. This property is set automatically by HubSpot.

All_owner_ids String True true

The value of all owner referencing properties for this object, both default and custom

All_team_ids String True true

The team IDs, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom

All_accessible_team_ids String True true

The team IDs, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7424.0