Solved: HubSpot Community - List API - Retrieving the records - HubSpot Community

[NMetnik]

Hello, 

I'm trying to return records I can see in my defined list I set up in Hubspot. I have a list that contains ticket info and associated data but the List API seems to just bring the json at the bottom back.  Am I missing something?  I also tried the search list call and same result.  I'm expecting to see all records and columns I specified...

POST: crm/v3/lists/118

{"list":{"listId":"118","listVersion":1,"createdAt":"2025-06-17T12:36:06.935Z","updatedAt":"2025-06-17T12:36:06.935Z","filtersUpdatedAt":"2025-06-17T12:36:06.935Z","processingStatus":"COMPLETE","createdById":"xxx","updatedById":"xxx","processingType":"DYNAMIC","objectTypeId":"0-5","name":"Closed Tickets","size":1366,"listPermissions":{"teamsWithEditAccess":[],"usersWithEditAccess":[]},"membershipSettings":{"membershipTeamId":null,"includeUnassigned":null}}}

[sylvain_tirreau · Accepted solution]

Go to the ticket properties to see the IDs of the properties you want to retrieve, and use what's in your portal (Settings > Properties > Select object tickets). For me, it's "hubspot_owner_id," and I don't have a "companyId" property, but it depends on your configuration. You can create this field and populate it with a workflow.
Come back and tell us if you found the properties you want; if not, you may need to query the contact.
If you don't want to query the contact associated with the ticket again, it's best to create the missing properties that you can populate with a workflow (when a ticket is created, retrieve the contact's company ID and insert it into the companyId property). All CRMs have different properties, so it is recommended to always check the property IDs before making API requests, especially when the ID is given by someone who does not have access to your portal 😉

[NMetnik · Accepted solution]

I'll mark this as the answer because I didn't know you can define that and fill it in a workflow.  I'm new to hupspot.

Further more I figure this out:

For anyone that stumble on this, I needed to add "&associations=company,contact" in the querystring and I can now see those ids, just not with the properties... They come back in their own JSON array.

[GRajput · Accepted solution]

Hi @NMetnik 

Get the list membership API to retrieve the list tickets, this will provide you a list of all the tickets id inside that list, then you can use the ticket api to get the details/properties. I hope this will solve your problrm statement here.

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

Thanks!

[BérangèreL]

Hi @NMetnik, I hope that you are well!

Thanks for asking the HubSpot Community!

Which associated data you'd like to get from the list, please? Are these the contacts that are associated with the tickets in the list?

Here are some resources that might be of interest to you:

- Retrieve lists API
- Search API
- Tickets API

Also, I'd love to ask our Top Experts: Hi @sylvain_tirreau, @MBERARD and @zach_threadint do you have suggestions to help @NMetnik, please?

Have a fantastic day and thanks so much in advance!
Bérangère

[NMetnik]

Hello!

The list I built is all closed tickets with the subject, close date, and a few others. The associated records I'm looking for is the companyId and the ticket ownerId (assigned to id).  

Thank you!

[sylvain_tirreau]

Hello @NMetnik,

You have to do this in two stages.

First you retrieve all the members of your list:

GET https://api.hubapi.com/crm/v3/lists/118/memberships?limit=100

You go through all the results pages and retrieve all the recordIds.

Then you retrieve all the tickets in question with the recordId:

POST https://api.hubapi.com/crm/v3/objects/tickets/batch/read

You send the recordId in the input and you indicate the properties you want to retrieve with something like this:

{
  "inputs": [
    { "id": "12345" },
    { "id": "67890" },
    ...
  ],
  "properties": [
    "subject",
    "closedate",
    "companyId",
    "hs_ticket_owner_id"
  ]
}

Best,

[NMetnik]

Hello,

I tried what you marked as the accepted solution but when I make that call, the properties "companyId" and "hs_ticket_owner_id" where ignored/did not come back with all the other ticket data.  Therefore I had to un-mark this as a solution.  Not sure why it was upvoted if it doesn't work either but am I missing something?  I tried batch and then I decided to go back to just listing all the tickets for a sanity check:

https://api.hubapi.com/crm/v3/objects/tickets?limit=10&archived=false&properties=subject,product_amount,product_used_name,createdate,lastmodifieddate,hs_ticket_category,hs_pipeline_stage,hs_ticket_priority,hours_to_complete_ticket,companyId,hs_ticket_owner_id 

Again, the last two properties are not included.  

Thanks again for your help.  Please allow me to mark the solution when it works.

[sylvain_tirreau · Accepted solution]

Go to the ticket properties to see the IDs of the properties you want to retrieve, and use what's in your portal (Settings > Properties > Select object tickets). For me, it's "hubspot_owner_id," and I don't have a "companyId" property, but it depends on your configuration. You can create this field and populate it with a workflow.
Come back and tell us if you found the properties you want; if not, you may need to query the contact.
If you don't want to query the contact associated with the ticket again, it's best to create the missing properties that you can populate with a workflow (when a ticket is created, retrieve the contact's company ID and insert it into the companyId property). All CRMs have different properties, so it is recommended to always check the property IDs before making API requests, especially when the ID is given by someone who does not have access to your portal 😉

[NMetnik · Accepted solution]

I'll mark this as the answer because I didn't know you can define that and fill it in a workflow.  I'm new to hupspot.

Further more I figure this out:

For anyone that stumble on this, I needed to add "&associations=company,contact" in the querystring and I can now see those ids, just not with the properties... They come back in their own JSON array.

[NMetnik]

Thank you but what about the associated properties for company id and the ticket owner id?

[sylvain_tirreau]

What exactly do you want to know? In my example, these properties are requested with the properties variable.

[NMetnik]

Hi, sorry, I missed that. I just assumed it wouldn't bring over the associated ids like that. I'll give it a try. 

thanks again!