Deluge script issue : Mismatch of data type expression. Expected BIGINT but found STRING

Deluge script issue : Mismatch of data type expression. Expected BIGINT but found STRING

I'm building a Zoho Creator form to take inputs for Email, Bootcamp Name, and Tag. If a record with the same Email + Bootcamp exists in a custom module (bootcampattendence), I want to update it by adding a new tag. If it doesn’t exist, I want to create the record and add the tag.

Even though the record is created or found successfully, when I try to update the tag, I get an error:
Mismatch of data type expression. Expected BIGINT but found STRING

I’m using zoho.crm.updateRecord("bootcampattendence", recordId, updateMap); where recordId is .toLong() converted.”

BELOW IS MY CODE:

// Capture inputs from the form
input.email = input.email;
bootcamp = input.bootcampname;
tagName = input.tag;
// Step 1: Search for existing record
criteria = "(Email:equals:" + input.email + ") and (Bootcamp_Name:equals:" + bootcamp + ")";
searchResp = zoho.crm.searchRecords("bootcampattendence",criteria);
recordIdStr = "";
if(searchResp != null && searchResp.size() > 0)
{
// Record exists
recordIdStr = searchResp.get(0).get("id").toString();
info "Record found with ID: " + recordIdStr;
}
else
{
// Step 2: Create record
newRecord = Map();
newRecord.put("Email",input.email);
newRecord.put("Bootcamp_Name",bootcamp);
createResp = zoho.crm.createRecord("bootcampattendence",newRecord);
if(createResp.get("id") != null)
{
recordIdStr = createResp.get("id").toString();
info "New record created with ID: " + recordIdStr;
}
else
{
info "Record creation failed.";
}
}
// Step 3: Add Tag
if(recordIdStr != "")
{
recordId = recordIdStr.toLong();
// Required as updateRecord needs BIGINT
tagMap = list();
tagEntry = Map();
tagEntry.put("name",tagName);
tagMap.add(tagEntry);
updateMap = Map();
updateMap.put("Tag",tagMap);
updateResp = zoho.crm.updateRecord("bootcampattendence",recordId,updateMap);
info updateResp;
}
else
{
info "No record ID found to add tag.";
}



        • Recent Topics

        • How to get batch number of item by api?

          Hi there, Is there any way to get batch number of item by api? Batch number is the batch reference number in https://www.zoho.com/inventory/help/advanced-inventory-tracking/batch-tracking.html . When I call the https://www.zoho.com/books/api/v3/#Items_Get_an_item
        • Questions about ACH in Zoho Billing

          We have ACH enabled for subscriptions in Zoho Billing and we have the option enabled for users to be able to log in to their bank to add the account to their payment methods. Questions: 1) If the user's bank isn't supported via the log-in method, will
        • Zoho Writer Default Publish Setting for Mail Merge

          Hello, I was thinking of using Mail Merge to create documents from CRM and automatically link them. However, I noticed the "publish" function and it seems the default is "to the world". This creates some anxiety as it is not clear what this "to the world"
        • Upcoming Changes to LinkedIn Parsing in Resume Extractor

          Starting 31 July 2025, the Zoho Recruit Resume Extractor will no longer support direct parsing of candidate data from LinkedIn profiles. Why Is This Change Needed? In accordance with LinkedIn’s platform policies, extracting profile data through browser
        • Payroll In Canada

          Hi, When can we expect to have payroll in Canada with books 
        • Contacts Profile

          Is there a way to add a picture to my contacts profile? You have an outline of a person but no way I can see to import a picture.
        • Tip 46: View resource allocation while adding or editing tasks

          Keeping track of employees workload can be daunting but also necessary. Overloading employees with work can cause burnout and reduce productivity.  Managers should be able to identify resources who are less engaged when assigning tasks. This will ensure a balanced workload and also improve employee's efficiency. Zoho Projects lets you identify resources who are available to take up a job when you add or edit a task.  ​ Assign the task to team members and the calendar in the Start Date field will display
        • field update from the value of another field

          Hello, I need to do a field update from the value of another field, but i don´t know how can i do it. In the mass update option it is not possible... I need to put the last name value form the leads module to other custom field that i have created. thanks for your help
        • Currency transition

          We are using Zoho CRM in Curacao, Dutch Caribbean. Our currency is currently the ANG. Curacao will be transition ing from using the ANG (Antillean Guilder) to using the XCG currency (Caribbean Guilder) on March 31st 2025, see: https://www.mcb-bank.com/caribbean-guilder.
        • Lookup fields

          Is there any way to add Lookup fields to Zoho FSM -- I do not see the option but I see default lookup fields in different modules
        • Using Zoho One to manage two (or more) businesses

          We are one company that operates two business, a scenario that Zoho One doesn't really seem to handle very well, and one which I can't imagine is at all unique to us! (It is basically designed to facilitate branding and use for one business only per subscription).
        • Shopify integration

          I need to integrate Shopify with Zoho Books
        • Switching Between Multiple Zoho One Organizations in New UI

          Here’s a polished version in English that you can use on Zoho’s support or community forum: Subject: Switching Between Multiple Zoho One Organizations in New UI Hello Zoho Community / Support Team, I’m currently managing two independent Zoho One organizations.
        • Fully functional FSM workflow

          I am using Books, FSM, Begin and Desk. At this moment, FSM is not fully functional even on its own. For example, Customer A buys 4 air-cons and 3 brackets from us. We are fine to create WO manually in FSM. This should be the full loop for a FSM workflow:-
        • Woocommerce Line Item Information

          I'd like to add each line item from a Woocommerce order to a zoho creator form record. The line items are found within the line items array, but I'm not sure how to get each item out of the array? Any help would be much appreciated.
        • Connect Woocommerce new order to zoho books via zoho flow

          Hello i want help to create a flow to create a new sales order from woocommerce to zoho books. Can someone send me step by step flow, functions and fields?
        • What's New in Zoho Invoice | April - June 2025

          Hello everyone! We're excited to share the latest feature updates and enhancements we've made to Zoho Invoice from April to June 2025. In this, you will learn more about the following features: New Integrations via Zoho Marketplace Add Images to Email
        • Change Invoice Prices for an Effective Date

          Hi, It would be a really good feature to be able to change the prices on invoices/recurring invoices from an effective date in the event of price increases. For instance, I am in the process of increasing prices that will be effective from a specific
        • PROJECTS - More flexibility with task and pricing

          Hi Everyone, I would like to use PROJECTS in my Zoho Booking app but it does not fit into my business. For example: I charge per sessions fixed price. My session usually are 2 hours and I bill the customer on the end of the month. My session can have
        • Is it possible to change default payable account for a bill?

          We have a case where we need to change a bill account from the default accounts payable to another account (it can be current asset or current liability, depending on the case). However, Zoho Books has set default account for bills, (accounts payable)
        • how to upload a reviewed price list in zoho to replace the existing price list

          Price list upload for my zoho books
        • Banking: Transfer from another account without base currency

          Scenario: A banking line item shall be categorised as an "internal transfer" from another bank account. This is a USD to EUR transfer. Our base currency is CHF. What we tried: Category: "Transfer from another account" From: Our USD account To: Our EUR
        • Company details and emails

          Our company has recently been rebranded and we have new email address - How do I update information for users. I have tried to re invite users with new email but it sends me to organization and there is no where I can change the email or invite with new
        • Linking Resale Certificates to Customer Locations

          Florida Resale Certificates must be on every customer invoice. We have customers with multiple locations and each location has a seperate FL Resale Certificate. The FL Resale Certificate makes the transaction EXEMPT from Sales Tax. Can FL Resale Certificate
        • Notebook App Not Opening

          I love this app but for the last 2 days it recuses to open. My phone tells me the app is bugged and I must wait for a new update. Is anyone else having this problem or is something going on with me? I have many important notes that I can't necessarily
        • Admin and Dispatcher Users show as Field Technicians in Dispatch Module?

          Hi Zoho, Our Admin and Dispatch user both show up as Fied Technicians / Field Agents in the Dispatch module, but they most certainly should not be assigned to any of the work orders and service appointments. These users are NOT service resources. How
        • ZOHO DESK | SET PERMISSION NOT TO ALLOW SPECIFIC AGENTS TO CREATE TICKET

          Hi Zoho Team, I have a question regarding this: "Team Desk are the ones to have the permission to create a ticket, Team OPS resolvers must not create a ticket." - How to set permission to Team OPS resolvers for not creating a ticket? Only Team Desk should
        • Full Text Customization & Translation in SalesIQ Chat Widget Settings

          Dear Zoho SalesIQ Team, Greetings, We would like to request an important enhancement to the chat widget customization options in Zoho SalesIQ. Current Limitation: At the moment, only some of the text shown in the chat widget is editable or translatable
        • Copy Sales Order Reference# to Purchase Order#

          Hello, We use our customer's purchase order number as the order number on our purchase order to the supplier.  We direct ship everything from our suppliers and the customers then see their PO number on the packing notes (instead of a sequentially-generated one). Therefore, is it possible to use automation to copy the Sales Order Reference# (customer PO) to the respective Purchase Order# (our PO) when converting the Sales Order to a Purchase Order?
        • Experience effortless record management in CRM For Everyone with the all-new Grid View!

          Hello Everyone, Hope you are well! As part of our ongoing series of feature announcements for Zoho CRM For Everyone, we’re excited to bring you another type of module view : Grid View. In addition to Kanban view, List view, Canvas view, Chart view and
        • Free webinar: Zoho Sign in Q2 2025: A quick walkthrough

          Hi there! We’re halfway through the year—and Zoho Sign has some exciting enhancements to show for it! Join us in our upcoming webinar to discover what's new and what you can look forward to. What will this session cover? Explore the newest features introduced
        • Can't type latin characters Mac x Windows

          I access a Win XP machine using Chrome on Mac OS X High Sierra and I can't get special characters like á é ó â ê ô ã õ à í ú to work. I tried a few different keyboard layout setups, but nothing worked. I end up having to type a lot of stuff in a local notepad for further copy and paste, which is not convenient at all. Am I missing anything? How can I make this work? Thanks.
        • Copying records from a Custom Module into Deals

          Hello, I recently created a custom module to handle a particular type of order/transaction in our business. Having got this up and running I've realised that it would be much better to use the Deals module with a different layout instead. We've entered
        • Using a Webhook as an Action

          I have been able to setup where I can use a webhook as a Trigger, but I am wondering how I can use a webhook as an Action. In the Zoho Flow Builder when using Zoho CRM as a trigger, I do not see a way to invoke a URL to POST json data that can be used
        • Add Microsoft Entra ID to Zoho One

          Hi! Have anyone tried the Zoho connection to Microsoft Entra ID (https://help.zoho.com/portal/en/kb/one/admin-guide/directory-stores/articles/add-microsoft-azure-to-zoho-one?action=kbArticleFollow&actionId=4014605732522 ) This is a big operation and you
        • Subform edits don't appear in parent record timeline?

          Is it possible to have subform edits (like add row/delete row) appear in the Timeline for parent records? A user can edit a record, only edit the subform, and it doesn't appear in the timeline. Is there a workaround or way that we can show when a user
        • Kaizen #197: Frequently Asked Questions on GraphQL APIs

          🎊 Nearing 200th Kaizen Post – We want to hear from you! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.
        • Pushing Zoho People leave into Microsoft calendar: how to chose how "event" is shown (busy, free etc)

          Hi, how can I select how a "leave" event is pushed into Microsoft calendar? I want for leave "working elsewhere" to show as working elsewhere and NOT as busy.
        • Is there any way to prevent the row cloning feature(on edit page)

          My initial requirement is to prevent some users from adding new rows in the subform. For that, I have implemented the client script, and the script is working fine. But users are able to clone the row and make changes. For that, I was unable to find any
        • Zoho Desk Community Portal Not Displaying Custom Styling Correctly

          Hi Zoho Community, I’m struggling to get a custom community portal in Zoho Desk to display my branding and styling correctly, and I’d love some help troubleshooting this for a client’s support portal. Details: Setup: Zoho Desk (Professional plan, latest
        • Next Page