Kaizen #40 - System-defined fields and their default values in Leads #API
Hello everyone!
Welcome back to another post in the Kaizen series!
This week, we will discuss the system-defined fields and their default values in the Leads module in Zoho CRM.
We will cover the following in this post:
- System-defined non-mandatory fields and their default values
- System-defined mandatory fields
What are the system-defined fields in a module?
The fields that are available by default in a module, are system-defined fields. You can choose to set values to these fields, or the system assigns the default value for applicable fields.
How can you find which fields are system-defined?
Use the Fields Metadata API. The response contains all the fields available in that module for your org.
The boolean value of the key custom_field indicates whether the field is system-defined or a custom field in that module. The value "true" indicates that the current field is a custom field, and the value "false" indicates that the current field is a system-defined field.
System-defined mandatory fields
Few system-defined fields are mandatory. If left unspecified, the system throws the MANDATORY_NOT_FOUND error.
The boolean value of the key system_mandatory indicates whether the field is mandatory in that module. The value "true" indicates that the current field is a system-defined mandatory field, and the value "false" indicates that the current field is not a system-defined mandatory field.
Note
We cannot modify the properties of a few system-defined fields. Ex: Last_Name in Leads.
Fields Metadata API for the Leads Module
Sample Request
Request URL: {{api-domain}}/crm/v2/settings/fields?module=Leads
Request Method: GET
Sample Response
{ "fields": [ { "system_mandatory": false, "webhook": true, "json_type": "jsonobject", "crypt": null, "field_label": "Lead Owner", "tooltip": null, "created_source": "default", "field_read_only": true, "display_label": "Lead Owner", "read_only": false, "association_details": null, "businesscard_supported": true, "multi_module_lookup": {}, "currency": {}, "id": "949200000000000553", "custom_field": false, "lookup": {}, "visible": true, "length": 120, "view_type": { "view": true, "edit": true, "quick_create": false, "create": true }, "subform": null, "api_name": "Owner", "unique": {}, "data_type": "ownerlookup", "formula": {}, "decimal_place": null, "mass_update": false, "multiselectlookup": {}, "pick_list_values": [], "auto_number": {} }, { "system_mandatory": false, "webhook": true, "json_type": "string", "crypt": null, "field_label": "Company", "tooltip": null, "created_source": "default", "field_read_only": false, "display_label": "Company", "read_only": false, "association_details": null, "quick_sequence_number": "1", "businesscard_supported": false, "multi_module_lookup": {}, "currency": {}, "id": "949200000000000555", "custom_field": false, "lookup": {}, "visible": true, "length": 100, "view_type": { "view": true, "edit": true, "quick_create": true, "create": true }, "subform": null, "api_name": "Company", "unique": {}, "data_type": "text", "formula": {}, "decimal_place": null, "mass_update": true, "multiselectlookup": {}, "pick_list_values": [], "auto_number": {} }, { "system_mandatory": true, "webhook": true, "json_type": "string", "crypt": null, "field_label": "Last Name", "tooltip": null, "created_source": "default", "field_read_only": false, "display_label": "Last Name", "read_only": false, "association_details": null, "quick_sequence_number": "3", "businesscard_supported": false, "multi_module_lookup": {}, "currency": {}, "id": "949200000000000559", "custom_field": false, "lookup": {}, "visible": true, "length": 80, "view_type": { "view": false, "edit": true, "quick_create": true, "create": true }, "subform": null, "api_name": "Last_Name", "unique": {}, "data_type": "text", "formula": {}, "decimal_place": null, "mass_update": false, "multiselectlookup": {}, "pick_list_values": [], "auto_number": {} }, { "system_mandatory": false, "private": null, "webhook": true, "json_type": "jsonobject", "crypt": null, "field_label": "Related Users", "tooltip": null, "created_source": "default", "field_read_only": false, "display_label": "User", "read_only": false, "association_details": null, "businesscard_supported": false, "multi_module_lookup": {}, "currency": {}, "id": "4150868000000625001", "custom_field": true, "lookup": {}, "visible": true, "length": 50, "view_type": { "view": true, "edit": true, "quick_create": false, "create": true }, "subform": null, "api_name": "User", "unique": {}, "data_type": "userlookup", "formula": {}, "decimal_place": null, "mass_update": false, "multiselectlookup": {}, "pick_list_values": [], "auto_number": {} }, ... ] } |
System-defined non-mandatory fields and their default values
The following table gives the list of all the system-defined non-mandatory fields in the Standard Layout of the Leads module.
Field API Name | JSON Type | CRM Data Type | Default Value |
Owner | JSON Object | Lookup | Name and ID of the current user |
Company | String | Single Line | null |
First_Name | String | Single Line | null |
Salutation | String | Picklist | None |
Email | String | Email | null |
Full_Name | String | -- | null |
Phone | String | Phone | null |
Mobile | String | Phone | null |
Designation | String | Text | null |
Lead_Status | String | Picklist | null |
Fax | String | Phone | null |
Website | String | URL | null |
Lead_Source | String | Picklist | null |
No_of_Employees | Integer | Number | null |
Industry_Type | String | Picklist | null |
Rating | String | Picklist | None |
Tag | JSON Array | -- | null |
Annual_Revenue | Double | Currency | null |
Created_By (not editable) | JSON Object | -- | Name and ID of the current user |
Email_Opt_Out | Boolean | Checkbox | false |
Skype_ID | String | Single Line | null |
Modified_By (not editable) | JSON Object | -- | Name and ID of the user who last modified the record last |
Created_Time (not editable) | String | -- | The date and time at which the record was created |
Secondary_Email | String | Email | null |
Modified_Time (not editable) | String | -- | The date and time at which the record was last modified |
Twitter | String | Single Line | null |
Last_Activity_Time (not editable) | String | -- | The date and time at which the record was used last |
Converted_Date_Time | String | -- | The date and time at which the lead or quote was converted |
Street, City, State, Zip_Code, Country | String | Single Line | null |
Description | String | Multi-line | null |
Record_Image | String | -- | null |
You can refer to the Sample Attributes section of our Insert Records API for an example on adding values to the above fields.
System-defined mandatory field for the Leads module:
Field API Name | JSON Type | CRM Data Type | Default Value |
Last_Name | String | Single Line | Not applicable |
Note
- In the Fields Metadata API, the value true for the key "field_read_only" indicates that it is read-only always.
- The value true for the key "read_only" indicates that the key is read-only for the viewing user's profile. You can set the properties of such fields based on the profile. A user without the desired profile cannot edit these fields through an API.
- You cannot modify the properties of system-defined mandatory fields in any module.
- You can choose to alter the properties of the system-defined(non-mandatory) or custom fields in standard/custom layouts. The details of all the fields in all the layouts will be retrieved in the fields metadata API response.
- You can also choose to set default values for fields with CRM field types—picklist, multi-select picklist, and checkbox.
We hope you found this post useful. Write to us at support@zohocrm.com if you have any questions, or let us know in the comment section.
Cheers!
Previous 'Kaizen' - Deals #API
Access your files securely from anywhere
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Sneha Sridharan
Jeremy Nagel - www.smooth.tel
Kevin Flynn
Sticky Posts
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.Kaizen #198: Using Client Script for Custom Validation in Blueprint
Nearing 200th Kaizen Post – 1 More to the Big Two-Oh-Oh! 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.Celebrating 200 posts of Kaizen! Share your ideas for the milestone post
Hello Developers, We launched the Kaizen series in 2019 to share helpful content to support your Zoho CRM development journey. Staying true to its spirit—Kaizen Series: Continuous Improvement for Developer Experience—we've shared everything from FAQsKaizen #193: Creating different fields in Zoho CRM through API
🎊 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.Client Script | Update - Introducing Commands in Client Script!
Have you ever wished you could trigger Client Script from contexts other than just the supported pages and events? Have you ever wanted to leverage the advantage of Client Script at your finger tip? Discover the power of Client Script - Commands! Commands
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Kaizen# 204 - Answering Your Questions | Perform Field Updates before Blueprint transition via Client Script
Hello everyone! Welcome back to another exciting Kaizen post. One of the questions we received through your Kaizen feedback was: “How can I update fields before Blueprint transition and how to prevent a transition based on a condition using Client Script?”Create online meetings for Booking Pages with Zoho Meetings and Zoom
Greetings, We hope you're all doing well. We're excited to share some recent enhancements to Bigin's Booking Pages. As you know, Booking Pages let you create public pages to share your availability so that your customers can easily book time slots withFilters in audit logs
Greetings, I hope all of you are doing well. We're happy to announce a few recent enhancements we've made to Bigin. We'll go over each one in detail. Previously, there were no filters available to narrow down data in audit logs. Now, we've introducedEnhanced help options in Bigin
Greetings, We're excited to introduce a new enhancement to Bigin's Help section: a comprehensive Help Options panel that brings together all your support resources in a single, well-organized space. Previously, the Need Help? menu provided only a limitedZoho FSM API Developer Needed
Hi, I’m looking for a developer with experience using Zoho FSM APIs. Scope: Connect WordPress website booking form to Zoho FSM Check availability (date, time, region) Create Work Orders + Service Appointments automatically Notify both customer and schedulerRevenue Management: #4 What if there are uncertainties in project or service delivery?
Our previous post taught us how Zoho Billing makes life easy for businesses with its automated revenue recognition rule. However, certain businesses have more challenges that an automated system cannot handle, and there are certain situations where automatedThis mobile number has been marked spam. Please contact support-as@zohocorp.com
Bom dia, estou tentando colocar o número 11 94287-6695 e esta com erro "This mobile number has been marked spam. Please contact support-as@zohocorp.com" pode me ajudar, por favor?Feature Request: Ability to Set a Custom List View as Default for All Users
Dear Zoho CRM Support Team, We would like to request a new feature in Zoho CRM regarding List Views. Currently, each user has to manually select or favorite a custom list view in order to make it their default. However, as administrators, we would likeItems Serial Tracking Issue
We enabled Zoho Items inventory tracking then disabled it after some time now we want to enable it again When I check the missing serial number reports I see one item But I cant see any option to Add the serial numbers Where and how to add the serialComposite Services and Account Tracking
I am looking to garner support/request the ability to make composite services. A quick search in the forums brings up multiple requests for this feature. I fail to see why an item is mandatory while services are optional. I also would like to see theZoho Payroll integration with Zoho Books - unable to match multiple bank feeds to one wage payment
For one employee's wage, I make two partial payments. Those bank feed transactions come into Zoho Books via bank integration. I make one pay-run for the month in Zoho Payroll and that comes into Zoho Books via the Zoho integration. Zoho Books doesn't let me match multiple bank feed transactions against a single wage item. Please fix urgently. I can't complete my books because of this.Add Checkbox Selection & Bulk Actions to Delivery Challans Module
Hi Zoho Team, I’ve noticed that in the Sales Orders module, there are checkboxes beside each entry that allow users to select multiple records for bulk actions such as print, email, or delete. However, in the Delivery Challans module, this option appearsCan't be able to check-in in laptop
even after giving location access still i can't be able to check-in in laptop.Compensation Cess on Coal ₹400 per tonne. ?????
The compensation cess rate varies by the type of product. And the cess is calculated based on the value of the product without GST. Coal, for example, comes with a cess of ₹400 per tonne. That means that if you sell 2 tonnes of coal that have a value7 month over zoho book purchase but still not immpliments Golive
7 month over zoho book purchase but still not immpliments Golive one problems zoho team short out then other problems come still very poor mangments and immliments team . struggling with the templates in ZOHO Books. Especially with the placement of someAverage Costing / Weighted Average Costing
Hello fellow maadirs. I understand Zoho Books uses FIFO method of dealing with inventory costing, but do you guys have any plans to introduce average costing? We indians need average costing. It's part of our culture. Please. I beg thee. Thanks.SMS to customers from within Bigin
Hi All, Is there anyone else crying out for Bigin SMS capability to send an SMS to customers directly from the Bigin interface? We have inbuilt telephony already with call recordings which works well. What's lacking is the ability to send and receiveHow to update/remove file in zoho creator widgets using javascript API
Hi Team, I have developed a widget which allows inserting and updating records I have file upload field with multiple file upload. Now while doing insert form record, I am using uploadFile API to upload files for that record. I am using updateRecord APIParent & Member Accounts (batch updating / inheritance)
Hello, I find the Parent Account functionality very useful for creating custom views and reports, but was wondering if I can also carry out batch editing on all members (aka children) of a Parent Account at the same time. Alternatively, can I set members to automatically inherit the values of the parent? For example: We have a chain of supermarkets that buy our products. These supermarkets are all members of a Parent Account in our CRM. We release a new product and all of the member stores wish toEdit Legend of Chart
I would like to edit the legend of the chart. Every time I enable the legend, I get a very unhelpful (1), and when I try to type to change to what I would desire, nothing happens, which is very frustrating. I've gone through your online tutorials and nowhere can I find a legend settings button. This seems a simple fix, where can edit the legend? Thanks.Extended timeouts for APIs beyond 40secs for to accomodate LLMs
A 40 second max response time for API calls is fine when connecting to most services, however is unsuitable when dealing with LLMs (ChatGPT/Claude/Gemini) where the response timing is very uncertain. Is there any way to increase this? It would be greatDeletion of Zoho Account
To whom it may concern, Good day, My account has been created incorrectly in Zoho and I am not able to join my Company's Zoho account - attached screenshot for your kind reference Alphatronmarine - Portal Kindly advise procedure to delete this currentWorkflow for deposit to bank account
Hello, Is it possible to make a workflow when a deposit is made to your bank account which is coupled to Zoho books? I want Zoho to sent an email each time a deposit is made to our bank account via a workflow. Regards, StevenMarking Retainer invoice paid through Deluge
Hey Everyone, We have a scenario where we are collecting deposit payments on our website. Now, in zoho books, we need to create a retainer invoice and mark it as paid automatically using deluge just like we can mark normal invoices as paid. I have triedExport Invoices to XML file
Namaste! ZOHO suite of Apps is awesome and we as Partner, would like to use and implement the app´s from the Financial suite like ZOHO Invoice, but, in Portugal, we can only use certified Invoice Software and for this reason, we need to develop/customize on top of ZOHO Invoice to create an XML file with specific information and after this, go to the government and certified the software. As soon as we have for example, ZOHO CRM integrated with ZOHO Invoice up and running, our business opportunitiesCreate a new record in custom module vi custom button
I have zoho books premium plan . I have 2 custom modules in zoho books. 1. Goods Receipt 2. Delivery Order, I need to select multiple records from Goods Receipt and create a new Delivery order from these multiple records. (like multilple sales order intoProfile date settings
At present I have "EEE, MMMM dd, yyyy" but this takes an exessive amount of column space, we should be able to input our own format. I would like to use "EEE, MMM dd, yy" - a much shorter version of the above but with the same abbreviated info, requiringDelivery Method Field in Sales Order Module
In Books and in Sales orders, the "Delivery Method" field seems to allow for anything to be entered and it seems to store those entries for future use. When you chose to convert a sales order to a purchase order, the related field is now called "ShipmentEditing / Removing stages for pipeline
Hello, I'm trying to create a new pipeline. I created a new stage and made an error when entering the probability. How can I edit fields in stages that I created? Can I delete these stages from "Add Stages" list?Dynamically Filter User Lookup in CRM Subform
We have a subform called Pricing Calculator in the Zoho CRM Opportunity module and need some assistance. Current Setup: First column: Picklist (Level) Second column: User Lookup field When a Level is selected, we want the User lookup to display only userschange time zone
can't seem to figure out how to change the time zone of the projectBigin iOS app update: Built-in telephony and RingCentral support
Hello everyone! We are excited to introduce Built-In Telephony and RingCentral support in the latest iOS version(v1.11.13) of the Bigin mobile app. Once the integration is completed on the Bigin desktop site(bigin.zoho.com), you can choose the Built-InAdd Image or Update Image API - for Items Module
I am trying to add new Items to Zoho Inventory from Zoho Creator. I achieved this using Zoho Inventory Create Item API, but how to add or update the item image from Zoho Creator to Zoho Inventory Item Module?Introducing Booking Pages—a topping for your Calendar Scheduling needs!
Greetings, We're here with a new topping for Bigin! Let's dive into the details. What does this topping do? Scheduling appointments with customers is one of the most common challenges small businesses face on a daily basis, as it often involves frequentDebugging `try` blocks : Tip
I find it annoying that if one line inside a `try` block has an error, the Deluge arser points the beginning of the block to the location of the error. BUT, if you temporarily comment out the initial `try {`  The parser goes through the whole block and[Product Update] TimeSheets module is now renamed as Time Logs in Zoho Projects.
Dear Zoho Analytics customers, As part of the ongoing enhancements in Zoho Projects, the Timesheets module has been renamed to Time Logs. However, the module name will continue to be displayed as Timesheets in Zoho Analytics until the relevant APIs areUse approval workflow comments in record scripts
Greetings, i'm running an approval workflow for my records, during approval/rejection there is a step where comments are entered. i want to add there comments to the record and to use them in various deluge scripts like sending emails and so on. howZOHO Store
Not able to make a payment We are using Zoho One, and we are from India. The payment currency, which shows for us, is in USD. But the system says we can choose Country/Region India if it shows INR only. Attaching screenshots for more info.Support Migration into Aliases in Zoho Mail
Hello Zoho Mail Team, How are you? We are in the process of migrating some of our users from Google Workspace (Gmail and Google Drive) to Zoho. During this process, we noticed that Zoho Mail currently only supports migration into a primary mailbox andAPI for Z Workdrive Flow Make-Integromat ?
We are zoho workdrive fans Also we would like to have an api to work with Zoho Flow or with Make better known by its old name INTEGROMAT Is it planned and when? 3 months -6 months or more?Next Page