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

Deals

CData BizTalk Adapter for HubSpot 2019 - Build 19.0.7424

Retrieve the available Deals in HubSpot.

Columns

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

Unique identifier of the deal.

Archived Bool True false

Whether the deal is archived or not.

CreatedAt Datetime True false

When the deal was created.

UpdatedAt Datetime True false

When the deal was last updated.

Amount_in_company_currency Double True true

The amount of the deal, using the exchange rate, in your company's currency

Days_to_close Double True true

The number of days the deal took to close

Currency String False true

Currency code for the deal.

Original_Source_Type String False true

Original source for the contact with the earliest activity for this deal.

Original_Source_Data_1 String True true

Additional information about the original source for the associated contact, or associated company if there is no contact, with the oldest value for the Time first seen property.

Original_Source_Data_2 String True true

Additional information about the original source for the associated contact, or associated company if there is no contact, with the oldest value for the Time first seen property.

HubSpot_Campaign String False true

The marketing campaign the deal is associated with

Closed_Deal_Amount Double True true

Returns the amount if the deal is closed. Else, returns 0.

Closed_Deal_Amount_In_Home_Currency Double True true

Returns the amount in home currency if the deal is closed. Else, returns 0.

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.

Deal_amount_calculation_preference String False true

Specifies how deal amount should be calculated from line items

Deal_Stage_Probability Double True true

The probability between 0 and 1 of deal stage. Defaults to 0 for unknown deal stages.

Is_Deal_Closed_ Bool True true

True if the deal was won or lost.

Last_Modified_Date Datetime True true

The most recent date that any property on a deal was updated. This is updated automatically by HubSpot.

Likelihood_to_close_by_the_close_date Double True true

Hubspot predicted likelihood between 0 and 1 of the deal to close by the close date.

Merged_object_IDs String True true

The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.

Deal_ID Double True true

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

The_predicted_deal_amount Double True true

Returns the multiplication of the deal amount times the predicted likelihood of the deal to close by the close date.

The_predicted_deal_amount_in_your_company_s_currency Double True true

Returns the multiplication of the deal amount in your company's currency times the predicted likelihood of the deal to close by the close date.

Projected_Deal_Amount Double True true

Returns the multiplication of the amount times the probability of the deal closing.

Projected_Deal_Amount_in_Home_Currency Double True true

Returns the multiplication of the amount in home currency times the probability of the deal closing.

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 the most recent deal owner was assigned to a deal. This is updated automatically by HubSpot.

Deal_Name String False true

The name given to this deal.

Amount Double False true

The total amount of the deal

Deal_Stage String False true

The stage of the deal. Deal stages allow you to categorize and track the progress of the deals that you are working on.

Pipeline String False true

The pipeline the deal is in. This determines which stages are options for the deal.

Close_Date Datetime False true

The expected close date of the deal

Create_Date Datetime False true

The date the deal was created. This property is set automatically by HubSpot.

Date_of_last_meeting_booked_in_meetings_tool Datetime True true

The date of the most recent meeting an associated contact has booked through the meetings tool.

Campaign_of_last_booking_in_meetings_tool String True true

This UTM parameter shows which marketing campaign (e.g. a specific email) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.

Medium_of_last_booking_in_meetings_tool String True true

This UTM parameter shows which channel (e.g. email) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.

Source_of_last_booking_in_meetings_tool String True true

This UTM parameter shows which site (e.g. Twitter) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.

Latest_meeting_activity Datetime True true

The date of the most recent meeting (past or upcoming) logged for, scheduled with, or booked by a contact associated with this deal.

Recent_Sales_Email_Replied_Date Datetime True true

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

Deal_owner String False true

The owner of the deal

Last_Contacted Datetime True true

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

Last_Activity_Date Datetime True true

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

Next_Activity_Date Datetime True true

The date of the next upcoming activity for a deal. This property is set automatically by HubSpot based on user action. This includes logging a future call, sales 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_times_contacted Double True true

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

Number_of_Sales_Activities Double True true

The total number of sales activities (notes, calls, emails, meetings, or tasks) logged for a deal. This is updated automatically by HubSpot.

HubSpot_Create_Date Datetime True true

The date the deal was created. This property is set automatically by HubSpot.

HubSpot_Team String True true

The team of the owner of the deal.

Deal_Type String False true

The type of deal. By default, categorize your deal as either a New Business or Existing Business.

All_owner_ids String True true

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

Deal_Description String False true

Description of the deal

All_team_ids String True true

The team ids 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

Number_of_Contacts Double True true

The number of contacts associated with this deal. This property is set automatically by HubSpot.

Closed_Lost_Reason String False true

Reason why this deal was lost

Closed_Won_Reason String False true

Reason why this deal was won

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