Zendesk Query Timeout

  • 25Views
  • Last Post 2 weeks ago
0
votes
John Collins posted this 2 weeks ago

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
0
votes
Mariia Zaharova posted this 2 weeks ago

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.

0
votes
John Collins posted this 2 weeks ago

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?

0
votes
Simon Bubnov posted this 2 weeks ago

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.

Close