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


CData BizTalk Adapter for HubSpot 2019 - Build 19.0.7424

Email campaigns in HubSpot allow you to keep track of and update email marketing campaigns. This table allows you to create, update, and delete your email campaigns in HubSpot.

Table Specific Information

Email campaigns in HubSpot represent email marketing campaigns you may send to many different contacts.


Email campaign data can only be retrieved from HubSpot via a direct request for a specific HubSpot id. To retrieve all campaigns, first all campaign ids must be retrieved. Then one request for individual campaign data at a time must be submitted. These requests are done automatically, but because of the number of individual requests made for data, this can cause for slow response times.

When selecting email campaigns, may be filtered by the Id. For example:

SELECT * FROM EmailCampaigns WHERE Id = '123456789'

The LastUpdatedTime will not normally be return with a value. It will only come back when specifying WHERE LastUpdatedTime > 'value'. This will trigger a request to HubSpot for recently modified EmailCampaigns. However, be aware that HubSpot only provides a way to retrieve recently modified EmailCampaigns. Not all campaigns that match the criteria may be returned.


Name Type ReadOnly References Description
Id [KEY] Long True

The Id of the email campaign.

AppName String False

The name of the app associated with the email campaign.

AppId Long True

The Id of the app associated with the email campaign.

LastUpdatedTime Datetime True

When the email campaign was lasted updated.

Name String True

The name of the campaign.

ContentId Long True

The ContentId of the email campaign.

NumberBounced Long True

The number bounced.

NumberClick Long True

The number of clicks.

NumberDeferred Long True

The number deferred.

NumberDelivered Long True

The number delivered.

NumberDropped Long True

The number dropped.

NumberIncluded Long True

The number included.

NumberMTADropped Long True

The number mta dropped.

NumberOpen Long True

The number open.

NumberProcessed Long True

The number processed.

NumberQueued Long True

The number queued.

NumberSent Long True

The number sent.

NumberStatusChanged Long True

The number where the status was changed.

NumberUnsubscribed Long True

The number unsubscribed.

ProcessingState String True

The processing state of the email campaign.

Type String True

The type of email campaign.

SubType String True

The subtype of the email campaign.

Subject String True

The subject of the email campaign.

LastProcessingStartedAt Datetime True

Last date the email campaign last began processing at.

LastProcessingFinishedAt Datetime True

When the email campaign last finished processing at.

LastProcessingStateChangeAt Datetime True

The last time the email campaign's processing state changed.

ExtraUrlParameters String True

An input only property for specifying additional parameters when selecting data from HubSpot. Specify the parameters as name=value pairs in a comma separated list. For instance, 'param1=value1,param2=value2,param3=value3'.

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