Zendesk Query Timeout

  • 35Views
  • Last Post 13 February 2019
John Collins posted this 08 February 2019

This query just times out.  Won't run and seems it should:


SELECT Tickets_User_Requester.Name, Ticket.Id, Ticket.Status, Tickets_Organization.Name, Tickets_User_Assignee.Name, Ticket.Subject, Ticket."Est Hrs", Ticket."Act Hrs", Ticket.Billable, Ticket.Created, Ticket.Updated

  FROM Ticket

INNER JOIN User AS Tickets_User_Requester ON Ticket.RequesterId = Tickets_User_Requester.Id

LEFT OUTER JOIN Organization AS Tickets_Organization ON Ticket.OrganizationId = Tickets_Organization.Id

LEFT OUTER JOIN User AS Tickets_User_Assignee ON Ticket.AssigneeId = Tickets_User_Assignee.Id

WHERE (Ticket.Updated > '2019-01-01 00:00:00' AND Ticket.Status = 'Closed')


Order By: Standard | Newest | Votes
Mariia Zaharova posted this 11 February 2019

How much time passes before the error?

We checked similar query and it does not fail, we were able to get results (in about 201 sec).

Please note, there are several joins in your query (Tickets_User_Assignee, Tickets_Organization, Tickets_User_Requester) and, probably, you have a lot of tickets in your Zendesk and that's why it takes so much time to get the necessary data.

John Collins posted this 11 February 2019

Hello Mariia,

I pasted the script code into the Skyvia Query web console and ran it and it worked.  But it continues to time out when I try to run it from a Google Sheet using the Skyvia Google sheet tool. I really need it to return results to the Google Sheet. Is there a timeout value there I can alter or something like that?

Simon Bubnov posted this 13 February 2019

This is a known issue and we are working on it. We will notify you when we get any results.

Is there a timeout value there I can alter or something like that?

There is no such possibility.