ADO.NET Provider for HubSpot

Build 21.0.8137

Products

Retrieve the available Products in HubSpot. This table supports both OAuth and APIKey authentications.

Table Specific Information

In HubSpot, products represent the goods or services you sell. Building a product library allows you to quickly add products to deals, generate quotes, and report on product performance.

Select

When selecting products, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators are =, !=, <, <=, >, >=. Further filtering is available using AND and OR combinations. A maximum of 2 OR operators are supported server-side, with each of these operators supporting up to 2 AND operators inside of them. For example:

SELECT * FROM Products WHERE [Created by user ID] = 4465089 AND [Product price] > 250
SELECT * FROM Products WHERE [Created by user ID] = 4465089 OR [Created by user ID] = 4465090

In the below server-offloading examples, "{Column}" represents any column you'd like to filter and "{Value}" represents any value you want to filter it on:

SELECT * FROM Products WHERE {Column} = {Value} AND {Column} < {Value} AND {Column} > {Value}
SELECT * FROM Products WHERE {Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}
SELECT * FROM Products WHERE ({Column} = {Value} AND {Column} = {Value}) OR ({Column} != {Value} AND {Column} >= {Value})
SELECT * FROM Products WHERE ({Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}) OR ({Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}) OR ({Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value})

Insert


INSERT INTO Products([Product description]) VALUES('description')

Update


UPDATE Products SET [Product description] = 'new description' WHERE ID='75229453'

Delete


DELETE FROM Products WHERE ID='75229453'

Columns

Name Type ReadOnly References Filterable Description
Id [KEY] Long False True

Unique identifier of the product.

Archived Bool True False

Whether the product is archived or not.

CreatedAt Datetime True False

When the product was created.

UpdatedAt Datetime True False

When the product was last updated.

Create_Date Datetime False True

The date the product 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

Folder_Id Double False True

The id of the folder that contains this product

Last_Modified_Date Datetime True True

The date any property on this product was modified

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.

Term String False True

Product recurring billing duration

Start_Date Date False True

Recurring billing start date for a line item

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

Recurring_billing_frequency String False True

How frequently the product is billed

Tax Double False True

The tax amount applied

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137