MCP Server for HubSpot

Build 24.0.9300

Orders

Lists all order records in HubSpot for managing order workflows.

Columns

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

Unique identifier of the object.

Archived Bool True True

Whether the object is archived or not.

CreatedAt Datetime True False

When the object was created.

UpdatedAt Datetime True False

When the object was last updated.

All teams String True False

The team IDs, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom

Business units String False False

The business units this record is assigned to.

All owner ids String True False

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

All team ids String True False

The team ids corresponding to all owner referencing properties for this object, both default and custom.

Billing City String False False

The city for the billing address.

Billing Country String False False

The country for the billing address.

Billing Email String False False

Customer's email from billing information

Billing First Name String False False

Customer's first name from billing information

Billing Last Name String False False

Customer's last name from billing information

Billing Phone Number String False False

The phone number for the billing address.

Billing ZIP/Postal Code String False False

The ZIP/postal code for the billing address.

Billing State String False False

The state for the billing address.

Billing Street String False False

The street for the billing address.

Buyer Accepts Marketing Bool False False

Indicates whether the customer has opted in/out of receiving marketing emails.

Cancellation Reason String False False

The reason given for cancelling the order.

Closed Date Datetime True False

Date when the order was closed, null otherwise, set automatically

Created by user ID Decimal True False

The user that created this object. This value is automatically set by HubSpot and may not be modified.

Object create date/time Datetime True False

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

Currency Code String False False

The currency code used in the order.

Customer Phone String False False

Phone number of Customer placing the Order

Date entered 'Stage 1 (Pipeline 1)' Datetime True False

The date and time when the order entered the 'Stage 1' stage, 'Pipeline 1' pipeline

Date exited 'Stage 1 (Pipeline 1)' Datetime True False

The date and time when the order exited the 'Stage 1' stage, 'Pipeline 1' pipeline

Discount Codes String False False

Discount Codes on an order.

Exchange rate Decimal False False

This is the exchange rate used to convert the cart amount into your company currency.

Canceled Date Datetime False False

Date the order is canceled.

Cart ID String False False

Unique identifier in an external system for the cart associated with the order.

Checkout ID String False False

Unique identifier in an external system for the checkout associated with the order.

Created Date Datetime False False

Date the order is created.

Modified Date Datetime False False

Most recent order modified date.

Order ID String False False

Unique identifier in an external system for the order.

Status String False False

Current status of the order as recorded on the source system.

Order URL String False False

An URL that links to an external site where the orders details can be viewed.

Fulfillment Status String False False

Current fulfillment/shipping status of the order.

Amount in company currency Decimal False False

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

Landing Site String False False

The URL of the first page on the sellers site that the customer landed on prior to them placing the order.

Object last modified date/time Datetime True False

Most recent timestamp of any property update for this object. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.

Merged record IDs String True False

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

Record ID Decimal True False

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

Record Creation Source String True False

Raw internal propertySource present in the RequestMeta when this record was created

Record Source Detail 1 String True False

First level of detail on how this record was created

Record Source Detail 2 String True False

Second level of detail on how this record was created

Record Source Detail 3 String True False

Third level of detail on how this record was created

Record Creation Source ID String True False

Raw internal sourceId present in the RequestMeta when this record was created

Record Source String True False

How this record was created

Record Creation Source User ID Decimal True False

Raw internal userId present in the RequestMeta when this record was created

Discount Decimal False False

Total Discount on an order as an amount.

Name String False False

Unique ID as represented by a number.

Notes String False False

A block of text associated with the order.

Payment Processing Method String False False

Type of payment processing method.

Payment Status String False False

Current Payment status of the order.

Pinned engagement ID Decimal False False

The object ID of the current pinned engagement. This will only be shown if there is already an association to the engagement.

Pipeline String False False

The pipeline that contains this order

Stage String False False

The order pipeline stage.

Processed Date Datetime False False

The date/time the order was imported into HubSpot.

Read Only Object Bool True False

Is the object read only

Referring Site String False False

The URL of the site that the customer came from to arrive at the sellers site prior to placing their order.

Refund Amount Decimal False False

Refunded amount, if any, associated with an order.

Shared Team IDs String True False

The team IDs of all teams that have shared access to this object

Shared User IDs String True False

The user IDs of all users that have shared access to this object

Shipping City String False False

The city for the shipping address.

Shipping Country String False False

The country for the shipping address.

Shipping Phone Number String False False

The phone number for the shipping address.

Shipping ZIP/Postal Code String False False

The ZIP/postal code for the shipping address.

Shipping State String False False

The state for the shipping address.

Shipping Street String False False

The street for the shipping address.

Shipping Cost Decimal False False

The base cost (i.e. undiscounted), in the orders associated currency, associated with shipping the order.

Shipping Status URL String False False

URL to Shipping status for the order.

Shipping Tracking Number String False False

List of Shipment tracking IDs associated with the order.

Source ID Decimal True False

HubSpot developer App ID from where this order data is first synced.

Source Store String False False

Data used to identify which store the order came from.

Subtotal Price Decimal False False

Total order amount before discounts, tax, duties etc.

Tags String False False

A collection of tag strings associated with the order.

Tax Price Decimal False False

Tax amount associated with the order, including duties.

Time in 'Stage 1 (Pipeline 1)' Decimal True False

The total time in seconds spent by the order in the 'Stage 1' stage, 'Pipeline 1' pipeline

Total Price Decimal False False

Sum Total amount associated with this order.

Total Weight String False False

The total weight of the order for shipping purposes.

Unique creation key String True False

Unique property used for idempotent creates

Updated by user ID Decimal True False

The user that last updated this object. This value is automatically set by HubSpot and may not be modified.

User IDs of all notification followers String True False

The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications

User IDs of all notification unfollowers String True False

The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications

User IDs of all owners String True False

The user IDs of all owners of this object

Performed in an import Bool True False

Object is part of an import

Owner Assigned Date Datetime True False

The most recent date an owner was assigned to this object. This is set automatically by HubSpot and can be used for segmentation and reporting.

Owner String False False

The owner of the object.

HubSpot Team String True False

The primary team of the owner.

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