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

Tickets

CData BizTalk Adapter for HubSpot 2019 - Build 19.0.7424

Get all tickets from a portal.

Table Specific Information

Tickets, along with contacts, companies and deals, are a foundational object in HubSpot CRM. A ticket represents a customer request for help, support, service, or a response, and the responses generated in reply to this request. Tickets are similar to companies: They both have a number of custom properties that will be dynamically determined and added to the table from your HubSpot Hub.

Select

When selecting Tickets, they can only be filtered by the Id. The accepted filters are illustrated below:

SELECT * FROM Contacts WHERE Id = 123456789
SELECT * FROM Contacts WHERE Id IN (123, 456)

Columns

Name Type ReadOnly References Description
Id [KEY] Long False

The internal ID for this ticket.

PortalId Long False

The Portal or Hub ID that this object belongs to.

Version Long False

Version of the ticket.

IsDeleted Boolean False

Whether or not the ticket is deleted. Deleted records will not be included unless you specifically request that deleted records be included.

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