Automation #3 - Auto-sync email attachments to tickets

Automation #3 - Auto-sync email attachments to tickets

This is a monthly series where we pick some common use cases that have been either discussed or most asked about in our community and explain how they can be achieved using one of the automation capabilities in Zoho Desk.

Most of our customers use email as their primary channel for customer support. Keeping that in mind we ensured Zoho Desk's multi-channel capability allowed for every email received in your inbox to be automatically converted into tickets in Zoho Desk. But for some time now, we have been receiving question on how to convert email attachments into ticket attachments within Zoho Desk. This process, which is mostly achieved manually now by many customers, can be automated using a simple script.

This automation involves two components: a connection and a workflow rule. We will first start by creating the connection and then set up the workflow rules to execute the custom function.

To create the connection, perform the following steps:

1. Go to Setup > Connections under Developer Space
2. Click "Create Connection"
3. Select "Zoho Desk" under "Default Services"
4. Give the connection name as "ticketattachment"
5. Under Scope below values
   Desk.tickets.READ
   Desk.tickets.UPDATE
6. Click "Create and Connect"
   
   
   
7. Click "Connect" and click "Accept"
   
   
   

Connection is created successfully.

To create workflow rule and associate custom function, perform the following steps:

1. Go to Setup, and under Automation, click Workflows.
2. On the left panel, under Workflows, click Rules > Create Rule,
   In the Basic Information section, carry out the following steps:
3. In the Module drop-down menu, select Tickets.
4. Enter a name and description for the rule.
5. If you want to activate the rule right away, select the Active checkbox. Else, you can just create the rule now and activate it later, on the Rules page.
6. Click Next.
   In the Execute on section, perform the following steps:
7. Select the Create checkbox to execute this rule every time a new ticket is created. 
   NOTE: If you would like to fetch all the attachment sent out and received in tickets, select "Customer Reply" and "Agent Response"
8. Click Next, skip the "Criteria" and Click Next.
9. In the Actions section, carry out the following steps:
10. Click the + icon under "Action" and select "New" next to Custom Functions
11. Enter a name and description for the custom function.
12. In the script window, input the Custom Function you find below:
    
    
    
    1. deskDomain = "https://desk.zoho.com";
       
    2. //Replace your zoho desk URL accordingly
    3. getTicketThread = invokeurl
    4. [
    5. url :deskDomain + "/api/v1/tickets/" + ticketID + "/latestThread"
    6. type :GET
    7. connection:"ticketattachment"
    8. ];
    9. dir = getTicketThread.get("direction");
    10. info "Direction " + dir;
    11. if(dir == "in")
    12. {
    13. prefix = "customer_";
    14. }
    15. else
    16. {
    17. prefix = "agent_";
    18. }
    19. listAttachments = getTicketThread.get("attachments");
    20. for each  attach in listAttachments
    21. {
    22. attachmentURL = attach.get("href");
    23. filename = prefix + attach.get("name");
    24. getAttachment = invokeurl
    25. [
    26. url :attachmentURL
    27. type :GET
    28. connection:"ticketattachment"
    29. ];
    30. if(getAttachment != null)
    31. {
    32. if(isText(getAttachment))
    33. {
    34. getAttachment = getAttachment.toFile(filename);
    35. }
    36. //info getAttachment;
    37. param = Map();
    38. param.put(filename,getAttachment);
    39. getAttachment.setParamName("file");
    40. uploadResponse = invokeurl
    41. [
    42. url :deskDomain + "/api/v1/tickets/" + ticketID + "/attachments"
    43. type :POST
    44. parameters:param
    45. headers: {"Content-Type":"multipart/form-data"}
    46. connection:"ticketattachment"
    47. ];
    48. info uploadResponse;
    49. }
    50. }
    
    

    
    
    
    
13. Click Edit Arguments
14. In the Name field type TicketID, and from the Value drop-down list select Ticket Id under Ticket Information. 
15. Click "Save" to save the custom function
    
    
    
16. Click "Save" again to save the workflow.
    

This should help you fetch attachments from incoming or outgoing response of a ticket and update them under tickets attachments tab.