topic Re: Contacts API, /contacts/v1/lists/all/contacts/all returns empty response in APIs & Integrations

Contacts API, /contacts/v1/lists/all/contacts/all returns empty response

IM_Developer — Thu, 21 Mar 2024 13:21:08 GMT

Hi there,
Requesting contact list

GET https://api.hubapi.com/contacts/v1/lists/all/contacts/all?count=10&property=email&property=lastname&property=hs_lifecyclestage_opportunity_date&property=utm_campaign&property=utm_source&property=utm_medium&property=hs_analytics_source&property=hs_analytics_source_data_1&property=hs_analytics_source_data_2&property=hs_lead_status&property=recent_conversion_event_name&property=recent_conversion_date&property=affiliate_lead&property=number_of_employees_range_&property=recent_deal_amount

I got an empty response

{
"contacts": [],
"has-more": false,
"vid-offset": 0
}

However, on UI Contacts list shows 57454 records.

portalId is 9089349, token has required scope "crm.objects.contacts.read" (following documentation😞

"scopes": [

"content",

"business-intelligence",

"oauth",

"integration-sync",

"crm.objects.contacts.read",

"crm.objects.marketing_events.read",

"crm.schemas.custom.read",

"crm.schemas.contacts.read",

"crm.objects.feedback_submissions.read",

"crm.objects.companies.read",

"crm.objects.deals.read",

"crm.schemas.companies.read",

"crm.schemas.deals.read",

"crm.objects.owners.read",

"crm.objects.quotes.read",

"crm.schemas.quotes.read",

"crm.objects.line_items.read",

"crm.schemas.line_items.read"

Please advise how to resolve this issue.

Thanks & regards,

Evgeniy

Re: Contacts API, /contacts/v1/lists/all/contacts/all returns empty response

GRajput — Thu, 21 Mar 2024 14:58:07 GMT

Hi @IM_Developer

Here's the curl command that should help you:

curl --request GET \ --url 'https://api.hubapi.com/crm/v3/objects/contacts?limit=100&properties=email&properties=firstname&properties=lastname&properties=hs_object_id&properties=phone&properties=company&archived=false' \ --header 'authorization: Bearer YOUR_ACCESS_TOKEN'

I hope this will help you out. Please mark it as Solution Accepted and upvote to help another Community member.
Thanks!

Re: Contacts API, /contacts/v1/lists/all/contacts/all returns empty response

IM_Developer — Fri, 22 Mar 2024 07:54:52 GMT

Hi @GRajput ,

Thank you for replying!

I've checked v3 endpoint and found the data I'm looking for.

And one more question here: in v1 API, the response for contacts contains a "form-submissions" array, and we use "page-url" element from this array.

Could you please explain how I can get such value in v3 API?

Thanks & regards,

Evgeniy

Re: Contacts API, /contacts/v1/lists/all/contacts/all returns empty response

GRajput — Fri, 22 Mar 2024 09:13:55 GMT

Hi @IM_Developer

Hi,
Here's the curl command that should help you:

curl --request GET \ --url 'https://api.hubapi.com/crm/v3/objects/contacts?limit=10&properties=recent_conversion_event_name&properties=email&properties=firstname&properties=lastname&properties=phone&properties=company&propertiesWithHistory=recent_conversion_event_name&archived=false' \ --header 'authorization: Bearer YOUR_ACCESS_TOKEN'

The curl command returned a "propertyWithHistory" array, which includes the most recent conversion. To clarify, "recent conversion" refers to the latest form submitted by the contact. Additionally, "propertyWithHistory" provides all form submissions from the specific page URL.

I hope this will help you out. Please mark it as Solution Accepted and upvote to help another Community member.
Thanks!

Re: Contacts API, /contacts/v1/lists/all/contacts/all returns empty response

IM_Developer — Fri, 22 Mar 2024 09:51:28 GMT

Gaurav,

I added param propertiesWithHistory=recent_conversion_event_name but unfortunately didn't find a value for 'form-submissions.page-url' that was returned from v1 for one of contacts, e.g. "https://meetings.hubspot.com/william-lewis/1-on-1-with-dr-bill-lewis".

Here's a propertiesWithHistory value for the same contact from v3:

"propertiesWithHistory": { "recent_conversion_event_name": [ { "value": "Meetings Link: william-lewis/1-on-1-with-dr-bill-lewis", "timestamp": "2021-11-13T17:15:20.256Z", "sourceType": "CALCULATED" }, { "value": "Meetings Link: drmccracken", "timestamp": "2021-08-20T07:59:14.294Z", "sourceType": "MIGRATION", "sourceId": "BackfillReadtimeCalculatedPropertiesJob" } ] },

Thanks & regards,

Evgeniy