Unable to Download CRM Contact Data: WorkDrive Integration Issues

Unable to Download CRM Contact Data: WorkDrive Integration Issues

## Problem Description
We need to let users download contact information from CRM as CSV files to their local computers. Since we couldn't implement a direct download option, we're trying to use WorkDrive as a workaround - but we're encountering issues with the WorkDrive integration.

## Current Working Solution (Not Ideal)
We currently save the data as a note in CRM:

```javascript
string button.CRMtoJobBuilder1(String contact_id)
{
    response = "";
    contact_details = zoho.crm.getRecordById("Contacts",contact_id.toNumber());
    if(contact_details != null)
    {
        // Format CSV data
        note_content = "zcrm_" + contact_id + "," + contact_details.get("Last_Name") + "," + 
            contact_details.get("Full_Name") + "," + contact_details.get("Mailing_City") + "," + 
            contact_details.get("Mailing_State") + "," + contact_details.get("Mailing_Street") + "," + 
            contact_details.get("Mailing_Zip");
        
        // Create note
        noteMap = Map();
        noteMap.put("Note_Title","CSV");
        noteMap.put("Note_Content",note_content);
        noteMap.put("Parent_Id",contact_id);
        noteMap.put("$se_module","Contacts");
        note_response = zoho.crm.createRecord("Notes",noteMap);
        
        if(note_response.get("id") != null)
        {
            response = "Success";
        }
        else
        {
            response = "Error: " + note_response.toString();
        }
    }
    else
    {
        response = "Contact not found";
    }
    return response;
}
```

## What We've Tried

### 1. WorkDrive Setup
- Created WorkDrive connection in Developer Space > Functions > Connections
- Selected required scopes:
  - WorkDrive.files.READ
  - WorkDrive.files.UPDATE
  - WorkDrive.libraries.CREATE
- Connection shows active (green status)
- Have valid WorkDrive folder ID

### 2. Upload Attempts
The `uploadFile` method requires specific parameters:
```
uploadFile(FILE file, TEXT parent_id, TEXT fileName, TRUE/FALSE override-name-exist, TEXT connection)
```

We've tried multiple approaches:

1. Direct parameter passing:
```javascript
file_response = zoho.workdrive.uploadFile(fileContent, fileName, parentId);
// Error: No. of arguments mismatch
```

2. Using Map:
```javascript
upload_params = Map();
upload_params.put("parentId", folder_id);
upload_params.put("fileName", "test_connection.txt");
upload_params.put("content", "Test file content");
file_response = zoho.workdrive.uploadFile(upload_params);
// Error: No. of arguments mismatch
```

3. All parameters:
```javascript
file_response = zoho.workdrive.uploadFile(null, parent_id, fileName, false, "");
// Error: Argument type mismatches at index 1
```

4. Creating FILE type:
```javascript
testFile = file("test_connection.txt", fileContent);
// Error: Not able to find 'file' function
```

## Main Issues
1. Can't find documentation on creating a FILE type object in Deluge
2. Not clear if we're missing additional configuration for WorkDrive integration
3. Unable to determine if there's a simpler way to allow users to download contact data

## Questions
1. How do we properly create a FILE type object for WorkDrive.uploadFile?
2. Is there a better way to let users download contact data as CSV files?
3. Are we missing any crucial WorkDrive setup steps?

Any help or examples would be greatly appreciated!
    Zoho Desk Resources

    • Desk Community Learning Series


    • Digest


    • Functions


    • Meetups


    • Kbase


    • Resources


    • Glossary


    • Desk Marketplace


    • MVP Corner


    • Word of the Day


      Zoho CRM Plus Resources

        Zoho Books Resources


          Zoho Subscriptions Resources

            Zoho Projects Resources


              Zoho Sprints Resources


                Zoho Orchestly Resources


                  Zoho Creator Resources


                    Zoho WorkDrive Resources



                      Zoho Campaigns Resources

                        Zoho CRM Resources

                        • CRM Community Learning Series

                          CRM Community Learning Series


                        • Tips

                          Tips

                        • Functions

                          Functions

                        • Meetups

                          Meetups

                        • Kbase

                          Kbase

                        • Resources

                          Resources

                        • Digest

                          Digest

                        • CRM Marketplace

                          CRM Marketplace

                        • MVP Corner

                          MVP Corner




                          Zoho Writer Writer

                          Get Started. Write Away!

                          Writer is a powerful online word processor, designed for collaborative work.

                            Zoho CRM コンテンツ






                              ご検討中の方

                                • Recent Topics

                                • No longer get Cliq notifications on phone if app not started

                                  On Android, I used to get notifications on my phone whether I was in the app, or it was started. Then about a month ago, I stopped seeing notifications on my phone UNLESS I had already started the app. So if I reboot my phone, and never start the app,
                                • Error AS101 when adding new email alias

                                  Hi, I am trying to add apple@(mydomain).com The error AS101 is shown while I try to add the alias.
                                • Deluge script to add Mail Task

                                  Has anyone out there created a custom function to create a Zoho Mail task? I'd be interested in hearing how you accomplished it. Sample code is appreciated!
                                • Tags with Zapier

                                  Maybe I'm missing something....I hope so... Using tags for triggers is a key need.  This prevents us from having a ton of different lists. I am trying to find out how to add a tag using zapier when someone makes a purchase....but it doesn't seem to be
                                • Send Supervisor Rule Emails Within Ticket Context in Zoho Desk

                                  Dear Zoho Desk Team, I hope this message finds you well. Currently, emails sent via Supervisor Rules in Zoho Desk are sent outside of the ticket context. As a result, if a client replies to such emails, their response creates a new ticket instead of appending
                                • How to apply blueprint on tickets that created from IM module

                                  Hello, I have an issue applying blueprint on tickets that created from WhatsApp conversation, the tickets matches with the blueprint criteria but still we are not able to put these tickets into the blueprint. I've tried with deferent type of tickets and
                                • Function #4: Schedule Customer Statements

                                  Regularly sending statements to customers is an imperative part of many business processes as it helps foster strong customer relationships and provides timely guidance on payments. While you can generate the statement of accounts and have it sent over
                                • trying to access CRM Variables with JS SDK

                                  Hello i built a widget with Sigma, i create CRM VARIABLES in custom properties. I try to access them in function : ZOHO.embeddedApp.on("PageLoad",function(data) with : ZOHO.CRM.CONFIG.getVariable("mycrmvariable").then(function(data){ console.log("mycrmvariable
                                • Zoho Mail POP & IMAP Server Details

                                  Hello all! We have been receiving a number of requests regarding the errors while configuring or using Zoho Mail account in POP/ IMAP clients. The server details vary based on your account type and the Datacenter in which your account is setup. Ensure
                                • Remove 30-Day Client Reply Restriction on Supervisor Rules in Zoho Desk

                                  Dear Zoho Desk Team, I hope you're doing well. Currently, Supervisor Rules in Zoho Desk run once every hour but only apply to tickets that have received a customer response within the past 30 days. This restriction creates challenges for us, as we have
                                • Paid Support Plans with Automated Billing

                                  We (like many others, I'm sure) are designing or have paid support plans. Our design involves a given number of support hours in each plan. Here are my questions: 1) Are there any plans to add time-based plans in the Zoho Desk Support Plans feature? The
                                • Contacts Don't Always Populate

                                  I've noticed that some contacts can easily be added to an email when I type their name. Other times, a contact doesn't appear even though I KNOW it is in my contact list. It is possible the ones I loaded from a spreadsheet are not an issue and the ones
                                • How to get NSE/BSE Stock Prices in Zoho sheets?

                                  I've been looking for a function that provides me with the NSE/BSE listed stocks price in Zoho Sheets like GOOGLEFINANCE in Google sheets, but I found none. Please help if there is any way to het stock prices?
                                • Tip #5: Setting access rights at the subfolder level

                                  Hello everyone, We hope you're finding our WorkDrive Tips and Tricks series useful. For today's tip, we'll teach you how to assign higher subfolder permissions to Team Folder members. Team Folders helps you avoid the drawbacks of traditional file sharing.
                                • Cannot edit email text in Zoho Form rules

                                  I have a number of rules set up on a form depending on a user's submission. For some reason, I am no longer able to edit the content of the emails sent out based on those rules. I am invited to "use the advanced editor", but the original text of the email
                                • Re-emitir facturas con nueva dirección de facturación

                                  Hola, necesito saber si es posible que las facturas ya emitidas, pueden ser re-emitidas con el cambio de dirección de facturación, realizado el día de hoy 02-01-2025, para efectos contables. Espero su ayuda, Gracias
                                • Add "Lead Image" in Bulk?

                                  Each of our Leads is accompanied with a URL containing a photo of the lead when they come in. We currently have to manually download then upload the photo to the lead. This is a HUGE waste of time. Is there any way to AUTOMATICALLY add the photos to the
                                • Client script: Can not choose a date field for an onChange field event

                                  Hi Zoho Team Why can't I choose one of my date fields to trigger an onChange event? Is this a client script limitation, or something wrong with my instance? If it is a limitation, is this mentioned in the documentation anywhere? Thanks. Marcus
                                • Can multiple agents be assigned to one ticket on purpose?

                                  Is it possible to assign one ticket to two or more agents at a time? I would like the option to have multiple people working on one ticket so that the same ticket is viewable for those agents on their list of pending tickets. Is something like this currently
                                • For security reasons your account has been blocked as you have exceeded the maximum number of requests per minute that can originate from one account.

                                  Hello Zoho Even if we open 10-15 windows in still we are getting our accounts locked with error " For security reasons your account has been blocked as you have exceeded the maximum number of requests per minute that can originate from one account. "
                                • how can I hide this Module?

                                  Hi everyone, newbie question. how can I hide the "Sales Order" column? when I try I get this message: https://imghostr.com/86395c_p7j
                                • UI Arabic

                                  can i change the member portal UI to arabic in zoho community?
                                • Domain verification is in progress... (How long do I need to wait?)

                                  Trying to setup my first email domain by connecting with GoDaddy. Have been here for quite some time and the screen is not changing. How long should this take?Send DataSend Data
                                • Custom Module missing SDK function fetchRelatedRecords(...) in a Client Script

                                  Good day, We have added a new module with a Multi-Lookup relation to Contacts.  When we tried to use the fetchRelatedRecords(id, related_list_api_name) function to get Related Records it is missing for our new custom module. https://js.zohocdn.com/crm/5124797/documentation/DotSDK/Modules.html
                                • How to display profile picture for distribution list?

                                  I am Admin of a Zoho Mail server and we have distribution lists along with user accounts. I am able to set Profile picture for the users and it shows when the email is sent to another companies. The members of the groups can also send email from those
                                • Mail Search Not Working

                                  Hello, Mail search is not working at all. I've tried Chrome and Mozilla. I can try and search for an exact term, or even an email that is 1st in my email list. All search does is sit and spin, or it comes up with no results. I've also tried it on my android
                                • Password should not contain sequential characters

                                  How can I avoid this? How do I even disable it. On my password policy page, it's all blank, so I don't know why I'm even getting this error now.
                                • Same phone number for more than one account.

                                  Hi there, I am a webdeveloper specialising in providing websites, webhosting and email solutions for my customers. I have signed up a number of my customers to Zoho Mail in the past, and a couple of these have grown into a paid package for Zoho CRM. As
                                • Is there a live chat for Zoho mail?

                                  I am having a problem in Zoho mail and would love to live chat with someone instead of email and wait for a response. Is there a function for this? I know there is in CRM but I can't seem to find it in mail... Thank you!
                                • Integrating Zoho Desk Instances from two separate organizations

                                  Is it possible to integrate Zoho Desk with an instance from another organization? For example, creating a ticket in one organization can cause the creation of a ticket in the second organization? Or certain tickets from one organization be viewable by
                                • Why does incoming mail inconsistently bounce back from Zoho mail

                                  On testing our user accounts, we are having problems where mail sent to zoho mail bounces back with errors message that 'relay access denied'. On testing from various accounts (including outlook, gmail and yahoo) mail seems to get through on some occasions
                                • Zoho email setup in office365

                                  When i am trying to setup zoho mail setup using my domain in office365 and it is not working and it says that we couldn't log on to the incoming (IMAP) server and please check your email address and password and try again. I was able to login using my
                                • JunkMail rejected

                                  Hello, we are facing problems sending mails. The IP has been blacklisted. Please, fix it as soon as possible. JunkMail rejected - sender4-op-o12.zoho.com [136.143.188.12]:17291 is in an RBL on rbl.websitewelcome.com, see Blocked - see http://www.spa
                                • My emails going to spam folder for hotmail or outlook

                                  My emails (not spam mails) are going into the spam folder for my customers using hotmail. Gmail and Yahoo users are receiving the emails in their inbox. can you please solve this problem. I read few articles but coudnt find any solution to it. I am testing it by sending a simple text email no pictures nothing at all still it is filtering my emails as spam. Please help I am really loosing time and clients due to this. Thanks
                                • Capture hotkeys inside the remote session and allow file exchange via clipboard

                                  Hi guys, assist is a really good app, and to become great it would be nice to have some features other vendors have in place and we take them for granted. For example, ScreenConnect, TeamViewer and others allow you to send hotkeys via the remote connection,
                                • Mass pdfs into OCR field

                                  I am working on a Creator app that my org will use internally. Is there any way to mass upload pfs through a form with an OCR file upload field? Is Creator capable of this, or would I need to use Catalyst?
                                • Cannot fetch url with custom extension (sigma - javascript)

                                  Hello i try to make my first extension with API request, i have two cases 1) this a deluge code attach to a button --> this one works very well response = invokeurl [ url :"my_api_fetch_url" type :GET headers:{"api_key":"myapikey","accept":"application/json","content-type":"application/json"}
                                • how to upload the picture and document

                                  i want to upload the picture and document,would you please told how to upload them?could you told it for each step?
                                • Forgot my email management account

                                  Hello, I am the administrator of ihomemix.com. I can’t remember which email address I used to register the account and then opened the email service for ihomemix. I can’t see the subscription period of my email function when I log in with this account.
                                • Add customer to account based on domain name.

                                  I generate reports based on a the account field, i.e. companyX.  In GoToAssist, my last provider, there was an option to automatically assign new ticket creators to a company (or account) based on their domain name. So for example, if a new employee creates a ticket from @companyx.com, for them to be automatically added to the companyx account would be a huge advantage.  As it stands right now, I have to remember to add them to the account manually.  Often I forget and when generating a report for
                                • Next Page