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

Tasks

CData BizTalk Adapter for HubSpot 2019 - Build 19.0.7424

Retrieve task events for Calendar.

Table Specific Information

Retrieve task events for Calendar. A shortcut of the standard events call for finer-grained control.

Select

You can filter through results with StartDate, EndDate, EmailCampaignId, IncludeNoCampaigns. In case StartDate is not specified its default value will be 01/01/2010. In case EndDate is not specified its default value will be the actual date. For example:

The following query will return results in the range of the specified dates satisfying other conditions as well:

SELECT * FROM Tasks WHERE StartDate = '2014-01-01 12:00:00' And EndDate = '2019-01-01 12:00:00' And IncludeNoCampaigns = 'true'
SELECT * FROM Tasks WHERE EmailCampaignId IN ('12345678', '2345689') AND StartDate = '2014-01-01 12:00:00Z' And EndDate = '2019-01-01 12:00:00'

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The unique id of the task.

Name String False

Name of Task.

Description String False

Description of Task.

EventType String False

Type of calendar event; for tasks this is always PUBLISHING_TASK.

EventDate Datetime False

When the task is set to be due.

Category String False

Type of task; one of BLOG_POST, EMAIL, LANDING_PAGE, CUSTOM.

CategoryId Integer False

Numeric value corresponding to the type of task; one of 3 (BLOG_POST), 2 (EMAIL), 1 (LANDING_PAGE), 0 (CUSTOM).

ContentId Long False

Id value of the COS content object associated with the task, null if nothing associated.

ContentGroupId Long False

The ID of the content group (aka blog) that the associated Blog Post belongs to, if any. Otherwise null. Only populated for single task GETs and for Blog Post Tasks..

PortalId Integer False

The hub id.

State String False

Value of TODO or DONE.

EmailCampaignId String False

EmailCampaigns.Id

Value of campaign GUID associated with Task.

Url String False

URL of the task.

OwnerId Long False

Owners.OwnerId

HubSpot id of the user that the task is assigned to.

CreatedBy Long False

Owners.OwnerId

HubSpot id of the user that the task was created by.

PreviewKey String False

The preview key.

SocialUsername String False

The username.

SocialDisplayName String False

The display name.

AvatarUrl String False

User avatar url.

TopicIds String False

BlogPosts.Id

The list of ids of topics associated with the associated Blog Post, if any. Otherwise null. Only populated for single task GETs and for Blog Post Tasks..

IsRecurring Boolean False

Boolean indicating whether is the task recurring.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source. For more information, see the WHERE clause section.

Name Type Description
IncludeNoCampaigns Boolean

The beginning value of the query range.

StartDate Datetime

The beginning value of the query range.

EndDate Datetime

Include tasks without a campaign specified (true, false). Defaults to false.

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