Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,029 questions
DataFactory HubSpot Tickets?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 37%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Jason Grey
1
Reputation point
The DataFactory hubspot connector doesn't seem to show service tickets in the list of tables.
I have added the ticket scope to our token, so that part should be fine.
Are tickets just not supported? or am I missing something?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee2022-03-23T22:06:12.57+00:00 Hello @Anonymous ,
Thanks for the question and using MS Q&A platform.
As we understand the ask here is to know if the service tickets tables can we accessed using ADF . please do let us know if its not accurate.
Looking at the document it does not looks like it talks about that , we are reaching out to the internal team to get some help on this . We will update you once we hear back from them.
Thanks
Himanshu -
Jason Grey 1 Reputation point
2022-03-24T14:52:30.257+00:00 Yes, that's correct. Service tickets (and, in our case, we need to specify a list of custom properties as well)
-
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
2022-04-20T18:38:21.687+00:00 Hello @Anonymous ,
Thanks for the question and using MS Q&A platform.Apoloziges for the delayed response on my side . I just reacived the below response from the internal team .
Because we work at hubspotobject level, if there is table for tickets like Companies, we should be able to query. Can CX check with Hubspot on that? Also, customer case use REST api https://developers.hubspot.com/docs/api/crm/tickets to get tickets.Please do let me if you have any queries.
Thanks
Himanshu -
Jason Grey 1 Reputation point
2022-04-20T18:53:59.867+00:00 Yes - understood on "Also, customer case use REST api https://developers.hubspot.com/docs/api/crm/tickets to get tickets."
And we indeed did do that for now - however, it was not easy to do in data factory, so we did it elsewhere as custom code, dumped the data into our db, then pull from db into data factory.
We were expecting more of a "no code" solution here, because the Hubspot connector existed. I will keep an eye on this ticket, if support does eventually come in data factory, I'd love to get rid of our custom code.
-
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
2022-04-27T18:54:58.927+00:00 Hello @Anonymous ,
It was great to know that you were able to get to a resolution . We expect you to keep using this forum and also motivate others to do that same . You can always help other community members by answering to their queries ..
Thanks
Himanshu
Sign in to comment
Sign in to answer