Fetch Individual HubSpot Records with the [HubSpot.Property:] Macro

Magic Suite ReportMagic
, ,
1

Need to retrieve specific HubSpot records by ID? The [HubSpot.Property:] macro lets you fetch individual Companies, Contacts, Deals, and Owners with precise control over properties and associations.

What Does It Do?

The macro retrieves a single HubSpot entity by ID and returns it as a JSON object. It’s perfect for lookup operations, drill-down reports, or enriching data when you know the entity’s unique identifier.

Supported Types:

  • Account (Company) - Organizations
  • Contact - Individual people
  • Deal - Sales opportunities
  • Owner - HubSpot users

Key Features

:white_check_mark: Custom Properties - Request specific fields or get defaults
:white_check_mark: Association Loading - Fetch related entities in one call
:white_check_mark: JSON Path Extraction - Extract specific values from results
:white_check_mark: Variable Storage - Save results for reuse with =>VariableName

Quick Examples

Get Deal with Contacts

[HubSpot.List: type=Deal, =>DealsList]
[ForEach: values={=DealsList}, storeAs=Deal]
[.:Deal.id, =>DealId]
[HubSpot.Property: id={DealId}, type=Deal, associations=Contact, =>DealData]
[EndForEach:]

Extract Company Domain

[HubSpot.List: type=Account, =>AccountsList]
[ForEach: values={=AccountsList}, storeAs=Account][.:Account.id, =>AccountId]
Domain: [HubSpot.Property: id={AccountId}, type=Account, jsonPath=properties.domain]
[EndForEach:]

Get Owner Email

[HubSpot.List: type=Owner, =>OwnersList]
[ForEach: values={=OwnersList}, storeAs=Owner][.:Owner.id, =>OwnerId]
Email: [HubSpot.Property: id={OwnerId}, type=Owner, jsonPath=email]
[EndForEach:]

Parameters

Required

  • id - HubSpot entity ID (long integer)
  • type - Entity type: Account, Contact, Deal, or Owner

Optional

  • properties - Semicolon-separated list (e.g., name;domain;industry)
  • associations - Related entities: Account, Contact, or Deal
  • jsonPath - Extract specific values (e.g., properties.domain)
  • connectionName - Override default connection
  • storeAs / => - Store result in variable

Limitations

  • properties and associations have no effect for Owner type
  • Uses HubSpot API v3
  • Single entity only (use HubSpot.List for bulk operations)

Getting Started

Simple test to verify your connection:

[HubSpot.List: type=Owner, =>Owners]
[Json.Item: value={=Owners}, jsonPath=`$[0].id`, =>FirstOwnerId]
[HubSpot.Property: id={FirstOwnerId}, type=Owner, =>OwnerDetails]
Owner: [.:OwnerDetails.firstName] [.:OwnerDetails.lastName]
Email: [.:OwnerDetails.email]

More details can be found in the Docs app here.

Questions? Share your HubSpot integration use cases in the comments!