Cmdlets for HubSpot

Build 25.0.9434

Quotes

Lists all quote records in HubSpot, useful for sales proposal management.

Table Specific Information

In HubSpot, quotes are used to share pricing information with potential buyers.

SELECT

When selecting quotes, filtering can be applied to columns marked as "Filterable." For these columns, the only supported server-side operator is =. 

SELECT * FROM Quotes WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42';
SELECT * FROM Quotes WHERE Archived = TRUE;

INSERT


INSERT INTO Quotes ([Quote Title]) VALUES ('title')

UPDATE


UPDATE Quotes SET [Quote Title] = 'new title' WHERE ID = '75229453'

DELETE


DELETE FROM Quotes WHERE ID = '75229453'

Columns

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

Unique identifier assigned to each quote record in HubSpot.

Archived Bool True True

Indicates whether the quote is archived and no longer editable.

CreatedAt Datetime True False

Timestamp when the quote was initially created.

UpdatedAt Datetime True False

Timestamp when the quote was most recently updated.

Business units String False False

Business units assigned to this quote for organizational tracking and segmentation.

Allowed Payment Methods String False False

Accepted payment methods for the quote if using HubSpot Payments, such as credit card or ACH.

Quote Approver String False False

User who approved the quote. May be blank if approval is not required.

Collect Billing Address Bool False False

Indicates whether the quote form should require a billing address from the customer.

Created by user ID Decimal True False

HubSpot user ID of the individual who created the quote record. Automatically generated.

Create date Datetime True False

Date the quote record was created in HubSpot.

Quote Domain String False False

Domain URL where the quote is publicly hosted.

ESign Date Datetime True False

Date and time when the quote was electronically signed by all required signers.

Expiration Template Path String False False

Internal HubSpot path for the expiration template associated with the quote.

Quote approval feedback String False False

Feedback or comments provided during the quote approval process.

Language String False False

Language selected for displaying the quote publicly.

Last modified date Datetime True False

Most recent timestamp when any property of the quote was updated.

Global Term Line Item Discount Percentage String False False

Internal HubSpot setting for a globally applied discount percentage across all line items.

Global Term Line Item Discount Percentage Enabled Bool False False

Indicates whether the global discount percentage setting is enabled for the quote.

Global Term Line Item Recurring Billing Period String False False

Internal HubSpot setting specifying the recurring billing period term for products in the quote.

Global Term Line Item Recurring Billing Period Enabled Bool False False

Indicates whether the recurring billing period global setting is enabled for the quote.

Global Term Line Item Recurring Billing Start Date String False False

Internal HubSpot setting specifying the recurring billing start date for line items.

Global Term Line Item Recurring Billing Start Date Enabled Bool False False

Indicates whether the global setting for recurring billing start date is enabled for the quote.

Global Term Line Item Recurring Billing Frequency String False False

Internal HubSpot setting specifying how often products are billed under the quote terms.

Global Term Line Item Recurring Billing Frequency Enabled Bool False False

Indicates whether the global billing frequency setting is enabled for the quote.

Locale String False False

Locale setting used for formatting language, dates, and numbers when the quote is displayed publicly.

Locked Bool True False

Indicates whether the quote is locked, preventing any further edits.

Merged object IDs String True False

List of object IDs that have been merged into this quote record. Automatically managed by HubSpot.

Record ID Decimal True False

Unique HubSpot-assigned ID for the quote record.

Payment date Datetime True False

Date when payment was completed for the quote by the customer.

Payment Status String True False

Current payment status of the quote, such as Paid or Pending.

Payment Type String False False

Payment method used for the quote if payment is enabled, such as credit card or ACH.

Quote PDF download link String True False

Direct link to download a PDF version of the quote.

Proposal Domain String True False

Domain from which the associated proposal is served, if different from the quote domain.

Proposal Slug String True False

URL path segment used to access the associated proposal.

Proposal Template String False False

Template path used to render the proposal associated with the quote.

Public URL key String True False

Key used to construct the public URL for accessing the quote document.

Quote Total Preference String False False

Specifies which line item property is used to calculate the total amount of the quote.

Read Only Object Bool True False

Indicates whether the quote object is read-only and cannot be modified.

Sender image URL String False False

URL to the image used as the sender's avatar on the quote document.

Quote Slug String False False

Path segment used to generate the public URL for accessing this quote.

Template Type String False False

Indicates whether the quote was generated using HubSpot's default templates.

Test mode Bool False False

Indicates whether the quote is in test mode and not intended for real transactions.

Unique creation key String True False

Unique property used for idempotent creation of the quote to prevent duplication.

Updated by user ID Decimal True False

HubSpot user ID of the individual who most recently updated the quote.

User IDs of all notification followers String True False

List of user IDs who chose to follow the quote for notification updates.

User IDs of all notification unfollowers String True False

List of user IDs who opted out of receiving notifications about this quote.

User IDs of all owners String True False

List of user IDs assigned as owners of the quote record.

Owner assigned date Datetime True False

Date and time when an owner was assigned to the quote.

Sender company name String False False

Name of the company sending the quote.

Sender first name String False False

First name of the person sending the quote.

Quote title String False False

Title assigned to the quote document.

Expiration date Datetime False False

Date when the quote will expire and no longer be available.

Sender company domain String False False

Domain name of the company sending the quote.

Sender last name String False False

Last name of the person sending the quote.

Comments to buyer String False False

Comments or messages included for the buyer on the quote document.

Sender company street address String False False

Street address of the company sending the quote.

Sender email String False False

Email address of the sender of the quote.

Sender company street address 2 String False False

Second line of the street address for the company sending the quote, if applicable.

Sender phone number String False False

Phone number for contacting the sender of the quote.

Terms String False False

Relevant information about pricing, purchasing terms, and agreements included in the quote.

Logo URL String False False

URL to the company logo displayed on the quote.

Sender company city String False False

City where the company sending the quote is located.

Sender job title String False False

Job title of the individual sending the quote.

Sender company state_region String False False

State or region where the company sending the quote is located.

Space for written signature Bool False False

Indicates whether a designated space for a handwritten signature is included on the quote.

Branding color String False False

Color value used for branding elements on the quote document.

Recent Sales Email Replied Date Datetime True False

Timestamp of the last time a tracked sales email related to this quote received a reply.

Sender company postal code String False False

Postal code for the company's address listed on the quote.

Space for written countersignature Bool False False

Indicates whether a designated space for a handwritten countersignature is included on the quote.

Quote owner String False False

User who is assigned as the owner of the quote.

Last Contacted Datetime True False

Last time a call, email, or meeting was logged related to the quote.

Last Activity Date Datetime True False

Most recent time a note, call, email, meeting, or task was logged regarding the quote.

Next Activity Date Datetime True False

Scheduled date of the next upcoming activity associated with the quote.

Number of times contacted Decimal True False

Number of times a call, email, or meeting was logged in relation to the quote.

Number of Sales Activities Decimal True False

Total number of sales activities, such as emails or calls, associated with the quote.

Currency String False False

Currency code used for the quote amount, such as USD or EUR.

Sender company country String False False

Country where the company sending the quote is located.

HubSpot team String True False

Primary HubSpot team associated with the owner of the quote.

All owner ids String True False

List of all owner referencing IDs, both default and custom, associated with the quote.

Sender company image URL String False False

URL of the image for the sender company's branding used on the quote.

Time zone String False False

Timezone used for displaying date and time fields on the quote document.

All team ids String True False

List of team IDs associated with the ownership properties for the quote.

Payment enabled Bool False False

Indicates whether payment collection is enabled directly through the quote link.

All accessible team ids String True False

List of all accessible team IDs, including inherited hierarchy, related to ownership of the quote.

ESign enabled Bool False False

Indicates whether electronic signature (eSign) functionality is enabled for the quote.

Associated Deals Decimal True False

Number of deals associated with the quote, automatically populated by HubSpot.

ESign number of signers required Decimal True False

Total number of required signers needed to fully complete the eSign process for the quote.

Legacy Quote Template String False False

Path to the legacy template used to render the quote. Legacy templates were sunset as of December 12, 2022.

ESign completed signatures Decimal True False

Number of completed electronic signatures collected for the quote.

Quote amount Decimal True False

Total amount due for the quote, based on associated line items.

Quote approval status String False False

Approval status of the quote, such as Approved or Rejected.

Quote number String False False

Reference number displayed on the quote document for internal or external tracking.

Collect shipping address Bool False False

Indicates whether the quote form should require a shipping address from the customer.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434