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

LineItems

CData BizTalk Adapter for HubSpot 2019 - Build 19.0.7424

Retrieve the available LineItems in HubSpot.

Columns

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

Unique identifier of the line item.

Archived Bool True false

Whether the line item is archived or not.

CreatedAt Datetime True false

When the line item was created.

UpdatedAt Datetime True false

When the line item was last updated.

Amount Double True true

The amount of a line item

Create_Date Datetime False true

The date the line item was created

Product_description String False true

Full description of product

Discount_Amount Double False true

The discount amount applied

Cost_of_goods_sold Double False true

The amount that sold goods cost the HubSpot customer

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.

Object_create_date_time Datetime True true

The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.

Discount_Percentage Double False true

The discount percentage applied

Last_Modified_Date Datetime True true

The date any property on this product was modified

Currency String False true

Currency code for the line item.

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.

Object_ID Double True true

The unique ID for this object. This value is automatically set by HubSpot and may not be modified.

Position_on_quote Double False true

The order which the line item appears on the quotes

Product_ID Double False true

ID of the product this was copied from

End_Date Date True true

Recurring billing end date for a line item

Term String False true

Product recurring billing duration

Start_Date Date False true

Recurring billing start date for a line item

Sync_amount Double True true

The amount set by Ecommerce sync

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.

Name String False true

Product name

Product_price Double False true

Cost of product

Quantity Double False true

How many units of a product are in this line item

Recurring_billing_frequency String False true

How frequently the product is billed

Tax Double False true

The tax amount applied

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