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!

      • Recent Topics

      • 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

      • Select CRM Custom Module in Zoho Creator

        I have a custom module added in Zoho CRM that I would like to link in Zoho creator.  When I add the Zoho CRM field it does not show the new module.  Is this possible?  Do i need to change something in CRM to make it accesible in Creator?

      • Not able to change colors help center

        Hi. How can I change the orange color in the help center? You can change everything besides this font color And how can I remove the part on the bottom?

      • What is syntax to call creator function (or trigger a creator workflow) from CRM deluge?

        What is syntax to call creator function (or trigger a creator workflow) from CRM deluge?

      • Send Whatsapp with API including custom placeholders

        Is is possible to initiate a session on whatsapp IM channel with a template that includes params (placeholders) that are passed on the API call? This is very usefull to send a Utility message for a transactional notification including an order number

      • Increase Round Robin Scheduler Frequency in Zoho Desk

        Dear Zoho Desk Team, We hope this message finds you well. We would like to request an enhancement to the Round Robin Scheduler in Zoho Desk to better address ticket assignment efficiency. Current Behavior At present, the Round Robin Scheduler operates

      • I'm getting an "Invalid_scope" error, even though I used an access token generated with the correct scope.

        I'm getting an "Invalid_scope" error, even though I used an access token generated with the correct scope. Here’s what I did in Postman: Generated the code to create an access token using the following URL: https://accounts.zoho.eu/oauth/v2/auth?scope=ZohoCampaigns.contact.UPDATE&client_id=<client_id>&response_type=code&access_type=offline&redirect_uri=https://1882-2-26-193-161.ngrok-free.app

      • Separate One-Time Mentions from Ongoing Ticket Following in Zoho Desk

        Dear Zoho Desk Support Team, We are writing to request an enhancement to the mention functionality within Zoho Desk. Currently, when an agent is mentioned in a ticket, they receive notifications for all subsequent activity on that ticket, similar to being

      • Projects Multiselect API

        Having troubles setting a mutli select field via API. updateMap = map(); updateMap.put("UDF_MULTI1","picklist_id1,picklist_id2"); updateProjectRes = invokeurl [ url :"https://projects.zoho.com/restapi/portal/XXXX/projects/" + projectID + "/" type :POST

      • KB Templates

        * It would be nice if Zoho can provide users an option to create custom templates for KB articles. Also, it would be nice as well if the users can have an option to 1.) select a default template and 2.) declare default tag/tags, for KB articles created through Ticket's resolution.

      • Mass update Accounts in Zoho Desk

        We used the integration feature to bring in all of our accounts from Zoho CRM. While all of the names and links are in place, on the Zoho Desk side the email, phone, website, and address fields are blank. By going into each account I can select "Update

      • Vivaldi will not open the Zoho Mail app when I click a email link in the browser

        I'm running Vivaldi on Arch with the Plasma desktop and have under default applications Zoho Mail set as my default email client. Whenever I click a email link in Vivaldi I get the below when it should be launching Zoho. Any ideas on rectifying this issue?

      • Digital publisher

        Kinetic Digital Publisher provides comprehensive digital publishing services, including eBook creation, formatting, cover design, and marketing. We help authors publish and promote their work across online platforms with ease.

      • Client Script - mapping data from different module

        Dear ZOHO Team Firstly I need to describe the need - I need to have data from Contacts module based on lookup field - the 5 map limit is not enough for me because I have almost 20 fields to copy So I have decided to make a Customer Script - and from unknown

      • Time Zone Correction with Daylight Savings Time

        Hey, I'm writing a series of reports where the source data is synced from an external source which stores the date/time information in GMT, but I want the reports to be in local time. Now, I understand there is the CONVERT_TZ function which allows me

      • Load form in iframe without header

        I am trying to load a form into an iframe without the header, but I am not having any luck. I am using openUrl() to load the iframe with the form URL and zc_Header set to false, e.g. #Form:Add_Case?zc_Header=false but it is still loading the header. Any

      • Filter embedded report

        How to filter embedded report in a page, below code is not working. dateField => startDate & dateField=< endDate The report should print on page containing records from startDate to endDate. params='zc_Header=true&amp;Service_Date__gte=<%=startDate%>&amp;Service_Date__lte=<%=endDate%>'

      • Creator Simplified #5: Set file upload restrictions in Zoho Creator

        Hey Creators, Welcome to the next post in the Creator Simplified series. Today, we’ll explore how to implement file upload restrictions to limit user submissions to specific file types. By implementing an allowed list for file uploads, you can optimize

      • Field Type: Address, Change District/State to Dropdown with picklist??

        Using the Address Field type, is there a way to make the District/State field be a dropdown with a picklist so the users can select rather than type the state name every time? I know this can be done if I use a drowdown field for the State (or entire address information), but that isn't as tidy as using the address field type. I apologize if this is a duplicate. I posted this question the other day, or so I though. Can't find that post.

      • cutomized fields are not showing up in zoho creator from zoho crm

        We have customized fields in zoho crm under accounts module like "Last production upgrade" --> This field is a date. When created a solution in zoho creator i couldn't find any of the customized fields. Would you please help me on this matter? Thanks

      • How to Add Bulk Data in Zoho Creator Forms Using Deluge Without Exceeding Execution Time Limit

        I have a database form with a column named 'Product Name' containing 8000 values in a Zoho Creator form. In another form named 'Returns Data,' I have a column with the same name, 'Product Name.' How do I add these 8000 values to the 'Returns Data' form

      • Open New Free Zoho Account

        Hi Team, Do you guys offer a free email hosting? I do have a domain already. If yes, what is the process to open the new account? Thanks,

      • 554 5.7.1 : Recipient address rejected: user info@intimspace.de does not exist

        554 5.7.1 : Адрес получателя отклонен: пользователь info@intimspace.de не существует I can't send an email to Google at info@intimspace.de. An error comes. I entered everything correctly in DNS https://zohomail.tools/#domainDetails/intimspace.de/ALL

      • Emails going back unread

        Hi all, When in Zoho mail - when I recieve a new mail it puts back all emails read that day back to unread - I then have to go back through and open all emails I have already read! Gets very annoying... Any idea on the bug fix?

      • Automatically updating field(s) of lookup module

        I have a lookup field, which also pulls through the Status field from the linked record. When the lookup is first done, the Status is pulled through - this works perfectly. If that Status is later updated, the lookup field does not update as well. As

      • Constraints on Tasks

        We have a use case where we have certain fixed date tasks and need to schedule predecessor tasks around these. Predecessor tasks need to be completed with a lag before the fixed date. We should be able to schedule the start and end date for predecessor

      • Moving Project Dependencies Not Moving Precedessors

        Most of the time we want to base our start dates around an event that is in the middle of the project template. If I set a bar up at the date we want it, it doesn't move the predecessors up. Is there a way to change this? eg. there is no point starting

      • Can you set task due dates to be "x" days before the milestone?

        We have a milestone set as the date of our first event. All of the tasks need to happen in increments prior to the milestone event. Is there a way to configure this without having to set up each task due date? Thanks!

      • Change script to add fields

        Hi, I have a custom function (writen by a different implementation company in the beginning) which I would like to edit to add a different field as well. Can't get it to work on my own though. - The script now adds the address fields to a new quote (needs

      • Integration between Zoho CRM and Zoho WorkDrive

        I'd like to search Zoho for an invoice I've added as an attachment (pdf) to an account. The name of the invoice is 1388-advertiserx-July.pdf - but I can't find it using the search function for any of these terms: 1388 1388-advertiserx 1388-advertiserx-July.pdf

      • Default ticket template in helpcenter

        Hello, I have a web form and a ticket template created. How can I make that my default ticket template? If an user clicks New ticket or create a ticket, I want that template to be the default one. Thank you for the time and info.

      • Expanded data-capturing capabilities with enhanced tabular sections

        We are thrilled to announce an update to Zoho Recruit that brings even more flexibility and customization to your recruiting process. With the addition of 10 new field types to the tabular sections, you now have the power to enhance your tabular sections

      • Integration of Business Hours in Email Templates

        Dear Zoho Desk Team, We would like to propose a feature enhancement to Zoho Desk that would greatly improve the utility of the Business Hours settings and streamline communication with our clients. Feature Request: Integration of Business Hours in Email

      • Introduction of Robotics Process Automation in Zoho products

        It will be great if Zoho can start advancing from automation to robotics process automation. For a start, it can be started with smart document understanding.   Provide OCR engines Google cloud, Microsoft Azure Computer vision OCR, Microsoft OCR, Omnipage

      • Zoho CRM Calendar View

        Hello Zoho team, We need desperately a calendar view next to list, kandan and other views. I think it should be easy to implement as you already have the logic from Projects and also from Kanban View in CRM. In calendar view when we set it up - we choose

      • Add Owner to deluge-created module record note

        Is it possible to include the "owner" aka "creator", of a Note when creating it via delulge? This sets "superadmin" as the Note creator. I need to override it. notemap = Map(); notemap.put("Parent_Id",program_contact_id); notemap.put("Note_Content",program_contact_data.get('Note'));

      • Blueprint - Field Validation Criteria (During)

        When setting validation criteria elsewhere in Zoho, or even workflow criteria etc., there are Is Empty and Isn't Empty options.  Within the Field Validation Criteria within Blueprint, those options aren't available.  Is there a particular reason for this? 

      • Delete Field that is used in a Zoho Flow connection

        I'm trying to delete a Field used in a Webhook created by Zoho Flow with CRM Connection and i get the following alert: When going to the alert i get to the following issue, can't edit it since its been deployed by a pluggin But yes i have here the prompted

      • Use image on img HTML tag

        Hi how could I do to use my image saved in Workdrive to use it in an HTML img tag ? I need to display it on my website without having to use iframes. Regards,

      • ZOHO Compain emails going to spam after authentication is successful

        Hello, I am frustrated right now. I have recently setup the zoho email compaign, The auto responder email went to receipient spam folder. then, I researched a lot and completed authentication (SPF, DKIM) in email deliverability, email relay in zoho crm.

      • Next Page