How to get Contacts in Pandas Dataframe using HuSpot Apps

Astroraf — Mon, 30 Jan 2023 19:50:35 GMT

I am trying to figure out how to get the Contacts from Hubspot into a pandas Dataframe using the Private Apps key. I can access the contacts but it keeps telling me the object is not subscriptable. This is my coe thus far.

```

access_token_key_contacts = 'xxxxxxxxxxxxxxxx'

api_client_contacts = HubSpot(access_token= access_token_key_contacts)

Contacts = api_client_contacts.crm.contacts.get_all()

Contact_lst = []

for contact in Contacts:

Contact_lst.append(contact)

```

When this is printed out, I get a list of Contacts but then I can't access this information like a normal list of dictionaries in python.

I am not sure what to do at this point. Any and all help will be much appreciated.

Re: How to get Contacts in Pandas Dataframe using HuSpot Apps

JTimmins — Tue, 31 Jan 2023 05:35:00 GMT

Looks like `contact` is an object, not a dictionary, so you'll need to access it via Python's dot notation. If you print out `contact.__dict__()`, it'll probably show you the objects properties.

You can also print out the object type (`print type(contact)`), and then look up that class in GitHub to see the built-in properties and methods. https://github.com/HubSpot/hubspot-api-python

topic How to get Contacts in Pandas Dataframe using HuSpot Apps in APIs & Integrations

How to get Contacts in Pandas Dataframe using HuSpot Apps

Re: How to get Contacts in Pandas Dataframe using HuSpot Apps