Hi all, trying to ingest Hubspot tickets info into my DW via tap-hubspot extractor, but i have info i don't seem to find. Using

meltano invoke tap-hubspot --discover >  tap-hubspot.catalog.json

I see that I have access to tickets and _ticket_pipelines_, but I needed more detail. I would like to have access to the message level, like one would get via

GET /v2/support/tickets/:ticketId

using HubSpot API endpoint. Can anyone share a pointer in the right direction? Has anyone faced a similar challenge? Thanks!

which variant are you using?

but i have info i don't seem to find

This would also be useful to know. Maybe the stream is just missing some field declarations.

which variant are you using?

meltano==3.4.x ~ 3.5.x

Ok, so in the documented example for /crm/v3/objects/tickets/{ticketId}, a ticket looks like this:

{
  "associations": {},
  "createdAt": "2023-11-07T05:31:56Z",
  "archived": true,
  "archivedAt": "2023-11-07T05:31:56Z",
  "propertiesWithHistory": {},
  "id": "<string>",
  "objectWriteTraceId": "<string>",
  "properties": {},
  "updatedAt": "2023-11-07T05:31:56Z"
}

are the ticket messages nested under

properties

?