Profile

GreyHamilton
Participant | Elite Partner
Participant | Elite Partner
Member since ‎Jul 15, 2020
Message
  • solutions
    6
  • Replies
    9
  • Upvotes Given
    4
  • Upvotes Received
    15
  • Ideas
    0

about

Please sign in to the Community or get HubSpot free to view user profiles

Following

    Friends list is empty

Grey Hamilton

This user hasn't created a bio yet. Edit your own profile here!

Activity

RedKnight on March 25, 2024
SQL Query to Pull Email recipeint List
Hi i am currently working on building a power bi report that reports on one of our email campaigns. Im using the Datawarehouse Power Bi connector to query our instance of HubSpot. I have found the list of events associated to the particular email ca read more
Reply Discussion Marketing Email
0 upvote
4 Replies
GreyHamilton
Participant | Elite Partner
March 25, 2024
Hey @RedKnight See if this SQL gets you closer to what you're looking for. The top 100 is only for testing since it can sometimes be a rather lar...read more
Toni_Atanasov on February 17, 2023
Enumeration property has no options
I'm performing a GET request to the deals API to fetch the options for a given enumeration field. However, for some fields, the options array is empty. Here's an example: $response = $hubspot->crm()->properties()->coreApi()->getByNa read more
Reply Discussion Deals PHP
1 upvote
5 Replies
GreyHamilton
Participant | Elite Partner
January 17, 2024
I've found that if the request comes back with externalOptions: true then the enumeration values are stored in a different table. If you're just...read more
Solved
AnzeKoprivec on January 17, 2024
Properties API returns 0 options on Pipeline/Dealstage/Owner properties
Hitting the properties API on certain enumeration properties returns no options. I'm guessing it does these on all properties where the options are defined by HubSpot. So far I've been hit with this on the dealstage,pipeline, owner properties. Examp read more
Reply Discussion Professional
0 upvote
4 Replies
GreyHamilton
Participant | Elite Partner
January 17, 2024
Got it. Yeah those 3 and one you might encounter is Team which is in the Settings API | User Provisioning (hubspot.com) and Currency which has it's...read more
Solved
AnzeKoprivec on January 17, 2024
Properties API returns 0 options on Pipeline/Dealstage/Owner properties
Hitting the properties API on certain enumeration properties returns no options. I'm guessing it does these on all properties where the options are defined by HubSpot. So far I've been hit with this on the dealstage,pipeline, owner properties. Examp read more
Reply Discussion Professional
0 upvote
4 Replies
GreyHamilton
Participant | Elite Partner
January 17, 2024
Got it. Yeah those 3 and one you might encounter is Team which is in the Settings API | User Provisioning (hubspot.com) and Currency which has it's...read more
Solved
DLalonde on January 12, 2024
Field Mapping & SalesForce
Hello! Currently, my organization is trying to switch from Formstack to Hubspot Forms. We have certain custom fields in Salesforce for Patient types in the form of checkboxes. However, when building out a Hubspot form, I can't seem to get th read more
Reply Discussion Forms
0 upvote
2 Replies
GreyHamilton
Participant | Elite Partner
January 16, 2024
You got it @BérangèreL . It looks like your Patient field on the Salesforce side is a checkbox which I believe functions as a True/False. HS M...read more
Solved
IBalta on April 17, 2023
PowerBi Reporting
Hi All, I am trying to pull our data into a PowerBi dashboard, via datawarehouse.io connector, but I am having troubles seeing the MQLs and the SQLs by month and by brand. The issue is that there is a low fidelity between the data fields and read more
Reply Discussion Data Sync
0 upvote
2 Replies
GreyHamilton
Participant | Elite Partner
April 17, 2023
Hey @IBalta , That should be the hs_date_entered_marketingqualifiedlead and hs_date_entered_salesqualifiedlead fields with the connector. ...read more
View latest posts
Bookmark content for quick access to your most helpful threads.
Get started
Everyone has to start somewhere! Why not kick-start your journey by telling us a bit more about your interests.
Introduce yourself

Following

Connecting with fellow members is one of the best ways to get the most out of your experience. Here are some folks to get you started.
Community Badges

My Groups

Find your people by joining Groups based on shared interests. Check out some of our current faves, and feel free to
  • badge
    Content Marketing

    A place for content marketers to share ideas, learn, network, and be inspired.

  • badge
    Social Media

    A place for social media professionals to share ideas, learn, network, and be inspired.

  • badge
    HubFans

    A spot for HubSpot fans to connect and grow.