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.

• Topic Participants

• Chinmayee Mishra

  

• Mike Karaffa

• Ash | Zoho Desk

  

• Hugues

• Jake Ashton

• Sticky Posts

• Register for Zoho Desk Beta Community

  With the start of the year, we have decided to take a small step in making the life of our customers a little easier. We now have easy access to all our upcoming features and a faster way to request for beta access. We open betas for some of our features

• Share your Zoho Desk story with us!

  Tell us how you use Zoho Desk for your business and inspire others with your story. Be it a simple workflow rule that helps you navigate complex processes or a macro that saves your team a lot of time; share it here and help the community learn and grow with shared knowledge. 

• Tip #1: Learn to pick the right channels

  Mail, live chat, telephony, social media, web forms—there are so many support channels out there. Trying to pick the right channels to offer your customers can get pretty confusing. Emails are most useful when the customer wants to put things on record. However, escalated or complicated issues should not be resolved over email because it's slow and impersonal.  When you need immediate responses, live chat is more suitable. It's also quick and convenient, so it's the go-to channel for small issues. 

• Welcome to Zoho Desk Community - Say hello here!

  Hello everyone! Though we have been here for a while, it’s time to formally establish the Zoho Desk Community; we’re really happy to have you all here! This can be the place where you take a moment to introduce yourself to the rest of the community. We’d love to hear all about you, what you do, what company or industry you work for, how you use Zoho Desk and anything else that you will like to share! Here’s a little about me. I am Chinmayee. I have been associated with Zoho since 2014. I joined here

• Webinar 1: Blueprint for Customer Service

  With the launch of a host of new features in Zoho Desk, we thought it’ll be great to have a few webinars to help our customers make the most of them. We’re starting off with our most talked about feature, Blueprint in Zoho Desk. You can register for the Blueprint webinar here: The webinar will be delivered by our in-house product experts. This is a good opportunity to ask questions to our experts and understand how Blueprint can help you automate your service processes. We look forward to seeing

• Recent Topics

• Use of Zia within Forms

  I have noticed that recently you have added Zia to help create forms from scratch. Would it be possible to add Zia functionality to free text fields for form submissions or if this is already on the roadmap an ETA for this please? We have a lot of field

• Default in fields on Form B based on the user selection in Form A

  Hi Everyone, I have added an action button to a form report to bring up a new form based on user selection, see it indicated in red below: Then when the ne form loads, I want to default in some of the fields based on the record the user was selected on.

• Last activity time is acting like last modified time

  When i edit the description or any field in the potential, account, contact and lead, the Last Activity Time is being updated like the Modified Time. This is messing all workflows and reports and we are unable to track real last time of activities like

• Enhancements to the formula field in Zoho CRM: Auto-refresh formulas with the "Now" function, stop formula executions based on criteria, and include formulas within formulas

  Dear Customers, We hope you're well! By their nature, modern businesses rely every day on computations, whether it's to calculate the price of a product, assess ROI, evaluate the lifetime value of a customer, or even determine the age of a record. With

• HEX/RGB Color Input in Visual Editor

  Hello Zoho Pagesense Team, We hope you're doing well. We’d like to submit a feature request to improve the color selection options in the Pagesense popup editor. Current Limitation: Currently, to set text colors, users must move the color slider manually.

• CRM and Campaigns- tags not integrating?

  Hi! I am setting up an automation in zoho campaigns and it says the crm is integrated...but when I want to use a trigger of a certain tag I created for people in the crm to denote those who purchased, it doesnt have that tag available as an option in

• Maximum limit of rows exceeded

  I am trying to add a row to a spreadsheets that has fewer than 60 rows. I keep getting an error message that says I have exceeded the maximum limit of 65,536 rows. Any ideas out there?

• Tip #7: 5 formas de mantener tus listas de correo electrónico

  Tips and Tricks #7, adaptado de Susmit Sen ¡Hola, comunidad! Esta semana volvemos con nuestros Tips and Tricks para Zoho Campaigns. En esta ocasión, voy a darte algunos consejos para mantener limpias tus listas de correo electrónico, y empezar el 2021

• Mail Merge related Lists

  When I try to merge an associated list the fields do not have a checkbox to choose them as it does in the tutorials. Am I missing something? Any ideas would be appreciated.

• create-a-purchase-receive API issues

  Hello all, I'm trying to use the create a purchase receive inventory API documented here (https://www.zoho.com/inventory/api/v1/purchasereceives/#create-a-purchase-receive) however when I do am getting the following error {"code":9,"message":"The purchase

• Zoho Pagesense really this slow??? 5s delay...

  I put the pagesense on my website (hosted by webflow and fast) and it caused a 5s delay to load. do other people face similar delays?

• Heatmap: Missing Content Elements - Zoho Page Sense

  Hi there, I'm trying out Zoho Page Sense to generate heatmaps for my Wix pages. My problem: Some parts of my Wix pages don't show on my heatmap, the heatmap is just empty there. Maybe Wix default lazy loading setting causes this error? Is there a way

• Marketing Tip #3: Use social proof to build trust

  People trust people. Showcasing reviews, testimonials, or “bestseller” badges on your product pages can nudge hesitant buyers toward purchase. Try this today: Add one customer testimonial or highlight your top-selling product on your homepage. Or, do

• Make CAMPAIGNS email look as simple as possible

  Hi there I'm trying to make my Campaigns email look as much like a normal email as possible. I'm a bit stuck with the "justification" of the email email block. Can I LEFT JUSTIFY the "whole email" to make it look "normal"? (Please see screenshot attached)

• Zoho Sign Reminder email template

  Is there a template we can edit for the reminder emails? I don't see it in Settings / Choose a template

• Preview an upload PDF or File

  I have a form where the customer has to upload a file (normally PDF - never jpeg)  When in report view I want to be able to preview the uploaded file without having to download it.  If I click on the upload it downloads to my computer, I want to be able

• How to filter emails by Reply-to field?

  I receive a very particular newsletter from an association A registered on a website W (that is used by many associations), and the emails fields are not great: the From just contains the generic website's W's email, while A is only mentioned in the Reply-to

• How to invite friends on other social media platforms to one of my group chats in arattai?

  Hello, I have formed chat groups in arattai. I want to invite my friends on other social media platforms like WhatsApp/ FB to one of my groups. Different friends would be invited to different groups. How to share an invite link of one of my groups to

• Line spacing

  I coudn't decrease the line spacing to space smaller then a single line. There is too much space between the lines that make the document look ugly. Please fix that. Liran. fonar

• Control Position of “X” (Close) Button in Popup Editor

  Hello Zoho PageSense Team, We hope you're doing well. We would like to request a customization improvement in the PageSense popup editor. Current Limitation: Currently, the position of the “X” (close) button is fixed and cannot be customized in the popup

• Add Standalone “Save” Button in Pagesense Popup Editor

  Hello Zoho Pagesense Team, We hope you're doing well. We would like to request an important usability improvement in the Pagesense popup editor. Current Limitation: There is currently no dedicated Save button while building a popup. The only way to save

• Text Direction Control in Pagesense Popup Editor

  Hello Zoho Pagesense Team, We hope you're doing well. We’d like to submit a feature request to add text direction control in the Pagesense popup editor. Current Limitation: Currently, the popup editor does not provide native support for RTL (Right-to-Left)

• Autosave in Pagesense Popup Editor

  Hello Zoho Pagesense Team, We hope you're doing well. We’d like to submit a feature request to enhance the Pagesense editor with an autosave functionality. Current Limitation: Currently, changes made in the Pagesense editor must be manually saved. In

• Billing frequency is not displayed correctly.

  Hello There is an issue while displaying the billing frequency on a subscription quote. I am able to activate the subscription details and get this lovely overview: If I am adding a Plan which I charge quarterly, first of all it should be possible to

• Creating Secret via Vault API

  Hi I am trying to create a secret through vault api.  This is the response I get. One thing I am not sure is how to decrypt the secretdata, how to get the secrettypeid? {     "operation": {         "result": {             "error_code": "",             "message": "Sorry, we are unable to process your request.",

• Is It Possible to Hide Menu Option from Main Navigation?

  Is it possible to hide a menu option, e.g. Admin, from the Main Navigation based on some criteria, e.g. login = zoho.adminuser

• Unleash the power of detail, with Table View.

  What use is context that's not available where you need it? With this in mind, we bring you the Table View. This feature will add more power to the way you organize and work through your ticket load. Table View comes in handy when you want more control over the ticket information you see. This is a nifty tool for users who find themselves limited in terms of the level of information that is being offered in the Classic View and Compact View. With an upper limit of 15 columns, agents can glean most

• Kaizen #126 - Circuits in Zoho CRM - Part 1

  Hello everyone! Welcome back to another week of Kaizen! Today, we will discuss an exciting topic—Circuits in Zoho CRM. For starters, we will discuss what Circuits are, how beneficial they are for businesses, different views of a Circuit, and the different

• Workdrive on Android - Gallery Photo Backups

  Hello, Is there any way of backing up the photos on my android phone directly to a specific folder on Workdrive? Assuming i have the workdrive app installed on the phone in question. Emma

• Dynamically Fetching Lookup Field Display Value

  I have an audit trail form, Audit_Changes, that tracks old vs new values across different forms. For lookup fields, the old/new value is the ID, but I also need the display value. What's a best practice for dynamically fetching the display value of the

• I have a problem. I use Zoho invoice

  I have a problem. I use Zoho invoice, which is that when I create an invoice for a customer with specific items, let's say the value of these items is 2100, but my customers are not the type who pay the entire invoice amount at once, as they divide the

• Ability to Create New Items When Zoho Trident is Minimized via tray or taskbar icon

  Allow users to create new items (emails, calendar events, tasks, etc.) directly from the system tray icon or by right clicking the task bar icon, even when the window is minimized or not actively running in the foreground. This enables quick access to

• I can not see Undeliverable emails from my Mass Email Leads activity in CRM

  I am sending email templates and I can not see the Undeliverables? I only receive the "Out of Office" replies and any manual replies from the lead. Can you please let me know where the Undeliverable emails are sent so I can use the information to clean up the database?

• Select Zoho Contacts as Meeting Participants in Zoho Cliq

  Hello Zoho Cliq Team, We hope you're doing well. We would like to request an enhancement to the meeting scheduling functionality in Zoho Cliq. Current Limitation: When scheduling a meeting in Zoho Cliq, participants can only be selected from: Organization

• Ability to Select External Users from Participants List When Scheduling Meetings

  Hello Zoho Cliq Team, We hope you're doing well. We would like to request an enhancement to the meeting scheduling experience in Zoho Cliq. Current Limitation when scheduling a meeting in Zoho Cliq: External users can be selected from the list only under

• Kaizen #212 - Map Dependency Fields in Zoho CRM using APIs

  Hi Everyone!! Welcome back to another week of Kaizen series! Over the past few weeks, we have been addressing your questions and feedback shared through our Kaizen 200th feedback form. Thank you for your continued engagement and thoughtful queries. We

• Outdated state in mexico

  Hello Zoho team, the drop down to add the state for customers, when they introduce their state in mexico has a city named “Distrito Federal” that name changed many years ago to “ciudad de mexico”. could you please update this so my clients can find the

• Is anyone using Zoho Flow with airtable?

  I need to build a flow that collects data from airtable and uses some of that data to create folders and files in google drive. I have fully function version of this in zapier and want to migrate to zoho. I am trying to perform a very basic fetch from

• AI in Zoho Workplace: A Sneak Peek into What’s Coming!

  Hello everyone, We’re super excited to share something we’ve been working on and we want you to be part of it! You may have seen our announcement blog post introducing a major evolution in how AI works within Zoho Workplace. Want to be among the first

• Best way to share/download presentation files in Zoho without losing formatting?

  Hello Zoho Community, I often work with PPT/PDF files in Zoho Docs and share them with colleagues. While PDFs usually give a direct download option, I’ve noticed that PPT/PPTX files sometimes only open in the viewer without a clear download link. Is there

• Next Page