Azure Data Factory Zendesk Connector Missing Tickets

Tomasz Swinarski 0 Reputation points
2023-01-11T11:54:42.4666667+00:00

Hello,

We are trying to integrate Zendesk data into our Azure SQL DB using Azure Data Factory.

I am using Zendesk connector available in ADF to load tickets (Mapping Data Flow).

Tickets are loaded to sink but to my surprise not all of them - just fraction of all of the tickets available in this particular Zendesk instance.

The earliest creation date month of the tickets loaded to sink is July 2022 but of course there are thousands of tickets created in Zendesk before that. Moreover July 2022 and August 2022 tickets are mostly missing as well for example for 16th August 2022 there are more than 100 hundred tickets created in zendesk but only one has been loaded to sink using ADF... Tickets created in January 2023 have all been loaded fine.

I would be grateful for any help you can provide.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,305 questions
{count} votes