Hi,
I hope you are well.
I’m trying to get some ticket properties in powerbi using ticket API but, only a limited list of properties that i can get.
i need to get a property “Ticket Owner name”, “Ticket source” and “ticket status”, but i don’t knowe well their internal property names to rquest via properties query parameters.
here is the API with property names i used:
“https://api.hubapi.com/crm-objects/v1/objects/tickets/paged?” &
“&properties=status” &
“&properties=source” &
“&properties=hubspot_owner_name” &"
is that correct? if no, please tell me the correct names and if yes, why i didn’t get any data?
and can you please mention a guide i can follow when i want to get more properties if there is?
Thanks in advance.
Hi, @AVidanagamage 
Are you asking for an example? If so, the request URL using your properties will look like this:
https://api.hubapi.com/crm/v3/objects/tickets/?properties=hs_ticket_priority%2Chubspot_owner_id%2Csubject%2Chs_lastmodifieddate&archived=false
You can play around with different properties by using the on-page example here — CRM | Tickets API. Click the endpoints tab and scroll down to the Read example. You’ll enter your properties comma-seperated (like your example) but the formatting used in the actual URL has to be %2C. Here’s a great explanation from Google on URL Encoding.
Have fun building! — Jaycee
Hey @FatmaNagy You can these internal values two ways, in-app and via the Properties API. Here’s an example for both.
In-app:
- Settings > Properties > Tickets and search for the property name — owner, status, source
- click into the property details
- click the </> icon to reveal the internal name (screenshot)
Properties API:
- Read all properties GET
/crm/v3/properties/{objectType}
- Search the JSON response for the property name and labels
Have fun building! — Jaycee
Thank you so much for your effort and solution
