Unable to get community name from properties of hubspot contact v3 API

Developer Support APIs & Integrations
,
1

which i am making get request to https://api.hubapi.com/crm/v3/objects/contacts , i am response as

{‘results’: [{‘id’: ‘1’, ‘properties’: {‘createdate’: ‘2015-11-02T21:36:39.992Z’, ‘email’: ‘’, ‘firstname’: ‘Brian’, ‘hs_object_id’: ‘1’, ‘lastmodifieddate’: ‘2023-04-13T17:26:42.082Z’, ‘lastname’: ‘Halligan (Sample Contact)’}, ‘createdAt’: ‘2015-11-02T21:36:39.992Z’, ‘updatedAt’: ‘2023-04-13T17:26:42.082Z’, ‘archived’: False}, {‘id’: ‘4502’, ‘properties’: {‘createdate’: ‘2015-12-31T18:53:32.009Z’, ‘email’: ‘’, ‘firstname’: ‘Chris’, ‘hs_object_id’: ‘4502’, ‘lastmodifieddate’: ‘2023-04-13T17:31:43.147Z’, ‘lastname’: ‘Pirtle’}, ‘createdAt’: ‘2015-12-31T18:53:32.009Z’, ‘updatedAt’: ‘2023-04-13T17:31:43.147Z’, ‘archived’: False}, {‘id’: ‘4504’, ‘properties’: {‘createdate’: ‘2015-12-31T18:53:32.009Z’, ‘email’: ‘’, ‘firstname’: ‘A’, ‘hs_object_id’: ‘4504’, ‘lastmodifieddate’: ‘2023-04-13T17:26:42.084Z’, ‘lastname’: ‘Rosenberg’}, ‘createdAt’: ‘2015-12-31T18:53:32.009Z’, ‘updatedAt’: ‘2023-04-13T17:26:42.084Z’, ‘archived’: False}, {‘id’: ‘4505’, ‘properties’: {‘createdate’: ‘2015-12-31T18:53:32.009Z’, ‘email’: ‘’, ‘firstname’: ‘Abduljabar’, ‘hs_object_id’: ‘4505’, ‘lastmodifieddate’: ‘2023-04-13T17:26:42.306Z’, ‘lastname’: ‘Totonji’}, ‘createdAt’: ‘2015-12-31T18:53:32.009Z’, ‘updatedAt’: ‘2023-04-13T17:26:42.306Z’, ‘archived’: False}, {‘id’: ‘4506’, ‘properties’: {‘createdate’: ‘2015-12-31T18:53:32.009Z’, ‘email’: ‘’, ‘firstname’: ‘Abby’, ‘hs_object_id’: ‘4506’, ‘lastmodifieddate’: ‘2023-04-13T17:26:42.447Z’, ‘lastname’: ‘Fisher’}, ‘createdAt’: ‘2015-12-31T18:53:32.009Z’, ‘updatedAt’: ‘2023-04-13T17:26:42.447Z’, ‘archived’: False}, {‘id’: ‘4507’, ‘properties’: {‘createdate’: ‘2015-12-31T18:53:32.009Z’, ‘email’: ‘’, ‘firstname’: ‘Abena’, ‘hs_object_id’: ‘4507’, ‘lastmodifieddate’: ‘2023-04-13T18:30:39.174Z’, ‘lastname’: ‘Lewis-Mhoon’}, ‘createdAt’: ‘2015-12-31T18:53:32.009Z’, ‘updatedAt’: ‘2023-04-13T18:30:39.174Z’, ‘archived’: False}, {‘id’: ‘4508’, ‘properties’: {‘createdate’: ‘2015-12-31T18:53:32.009Z’, ‘email’: ‘’, ‘firstname’: ‘Aaron’, ‘hs_object_id’: ‘4508’, ‘lastmodifieddate’: ‘2023-04-13T18:27:14.647Z’, ‘lastname’: ‘Adams’}, ‘createdAt’: ‘2015-12-31T18:53:32.009Z’, ‘updatedAt’: ‘2023-04-13T18:27:14.647Z’, ‘archived’: False}, {‘id’: ‘4509’, ‘properties’: {‘createdate’: ‘2015-12-31T18:53:32.009Z’, ‘email’: ‘’, ‘firstname’: ‘Abigal’, ‘hs_object_id’: ‘4509’, ‘lastmodifieddate’: ‘2023-04-13T17:29:26.795Z’, ‘lastname’: ‘Alcott’}, ‘createdAt’: ‘2015-12-31T18:53:32.009Z’, ‘updatedAt’: ‘2023-04-13T17:29:26.795Z’, ‘archived’: False}, {‘id’: ‘4510’, ‘properties’: {‘createdate’: ‘2015-12-31T18:53:32.009Z’, ‘email’: ‘’, ‘firstname’: ‘accter’, ‘hs_object_id’: ‘4510’, ‘lastmodifieddate’: ‘2023-04-13T17:26:42.441Z’, ‘lastname’: ‘accrer’}, ‘createdAt’: ‘2015-12-31T18:53:32.009Z’, ‘updatedAt’: ‘2023-04-13T17:26:42.441Z’, ‘archived’: False}, {‘id’: ‘4511’, ‘properties’: {‘createdate’: ‘2015-12-31T18:53:32.009Z’, ‘email’: ‘’, ‘firstname’: ‘Adam’, ‘hs_object_id’: ‘4511’, ‘lastmodifieddate’: ‘2023-04-13T18:27:11.673Z’, ‘lastname’: ‘Thocher’}, ‘createdAt’: ‘2015-12-31T18:53:32.009Z’, ‘updatedAt’: ‘2023-04-13T18:27:11.673Z’, ‘archived’: False}], ‘paging’: {‘next’: {‘after’: ‘4512’, ‘link’: ‘https://api.hubapi.com/crm/v3/objects/contacts?after=4512’}}}

but i need to extract community from this response which i could not able to see the under the properties section from the response

2

Hey, @SOza :waving_hand: Did you get this resolved? If not, I have a question + two places you can start:
Question:

Next Step (either one will work):

  • Navigate in-app to Settings > Properties > Contacts and search for the property, You can grab the internal value from here to make sure you are using the correct name in your queries
  • Use the Properties API endpoint, GET/crm/v3/properties/{objectType}/{propertyName} to get the internal value for this property
  • Additionally, make sure the property is included in your request. For example, https://api.hubapi.com/crm/v3/objects/contacts?properties=community

One potential reason it isn’t returned in your request, if you’re including it already, is that the specific contact doesn’t have a value for that property. From the endpoint documentation, “If any of the specified properties are not present on the requested object(s), they will be ignored.”

Have fun building! — Jaycee

3

@Jaycee_Lewis I want to add few points that we are fecthing data from paid social (facebook ad leads) and paid search (google ad leads) with communities and total number of leads per community. In data base i want output columns like community, leads, and start date and end date. But i am getting few communities and in leads zero data i am getting. This problem i am facing from after migrating hubspot into private app. from previous i use to fetch data from this url f"https://api.hubapi.com/analytics/v2/reports/sources/total?hapikey={API_KEY}&d1=paid-social&d2=Facebook&start={start_date}&end={end_date}. Please help how to fetch data for community and leads?