Get All Properties For All contacts on my HubSpot Account

Developer Support APIs & Integrations
1

Dear Community

How can I pull *all the Data for HubSpot’s default contact properties like :

Contact information:

  • Annual revenue.
  • Associated deals.
  • Became a customer date.
  • Became a lead date.
  • Became a marketing qualified lead date.
  • …
  • …

I tried to use this Endpoint but I didn’t get the same contact properties.

https://developers.hubspot.com/docs/api/crm/properties?_ga=2.252583625.1918557733.1622443519-976316432.1619699650

*: I mean here how i can avoid the limitations of the results using ‘Paging’

Big Thanks!

2

@MichaelC , want to field this one :grinning_face:

3

Thanks @dennisedson ! Here is a screenshot how it looks like on my account(some of them).

4

Hi @BBI

There are no page limitation when it comes to getting all the properties using the api.

/crm/v3/properties/

Can you show me an example of the call you make such as:

1. The method you use (example: GET, POST, PUT, PATCH AND MORE).
2. The URL you use to make the call (such as https://api.hubapi.com/crm/v3/properties/contacts)
NOTE: Remove your HAPI key token before posting it here.

3. Your request header

NOTE: Remove any access tokens if you use that in your header before posting it here.

4. Your request body (if there is one)

5

Hi @MichaelC

Here is my script (I have posted it as photo because i got an Error-massage: Your post has been changed because invalid HTML was found in the message body. The invalid HTML has been removed. Please review the message and submit the message when you are satisfied).

I hope that works for you

BBI_0-1622792739053.png
BBI_0-1622792739053.png1284×580 80.7 KB

Thanks!

6

@BBI getting the properties in the API properties/contacts

You are not allowed to use the properties parameter in the string. You will get all properties in the call without filters. And then you have to do the work of filtering the response in your own code. The only thing you may filter is if the properties are archived or not.

7

@BBI One option is to export all of your CRM data using Ultimate Data Export for HubSpot. Ultimate Data Export is available free of charge in the HubSpot App Marketplace.

With the Ultimate Data Export for HubSpot you can export the following data tables and their associations:

    • Contacts
    • Web Analytics
    • Companies
    • Deals
    • Deal History
    • Owners
    • Campaigns
    • Engagements
    • Emails
    • Products
    • Tickets
    • and more related subdata such as Pipelines and Associations.

Here is a brief explainer video on the app. I realize that this may be more data than you are looking for, but it’s free and you will receive an Excel file than you can easily use for importing data into other apps.