Olena Romanchuk
posted this
01 December 2021
edited 01 December 2021
posted
01 December 2021
Admin
Hello Dave,
Skyvia works with Zendesk through their API and is bounded with its limitations.
The TicketComments, TicketAudit and other Ticket* tables are related to the Ticket table as child entities. It means that to retrieve the data from these tables Skyvia reads all existing records from the Ticket table first.
We also see the filtering condition in the query by the ID field, but please note that the ID fields used in the "Where" clause are the TicketComment and TicketAudit Id fields, not the Ticket Id. If you want to filter these records by the Ticket Id value, you should use the TicketId field in the "Where" clause of your query.
Best regards,
Olena
Technical Support Engineer