Insert Record | Add Record | API | Insert Record Example

Insert Record API

Description:

To add a record to any form in Zoho People.

Sample Request URL:

https://people.zoho.com/api/forms/json/test_form/insertRecord

Header:

Authorization:Zoho-oauthtoken 1000.8cb99dxxxxxxxxxxxxx9be93.9b8xxxxxxxxxxxxxxxf

Scope:

scope = ZOHOPEOPLE.forms.CREATE

Possible Operation Types:

CREATE - Create form data

Request Parameters:

Parameters	Values Allowed	Default Values	Description	Mandatory
formLinkName	-	-	Form label name. To get formLinkName, refer appendix	Yes
inputType	-	-	{LabelName:'value',LabelName1:'value1',LabelName2:'value2'}	Yes
isDraft	-	-	true \| false	No

NOTE : To insert a record in the tabular section, the values should be sent in a JSON array.

Threshold Limit: 100 requests | Lock period: 5 minutes

Threshold Limit - Number of API calls allowed within a minute.
Lock Period - Wait time before consecutive API requests.

Common Error Codes and Description

Code	Description
7038	Permission denied to add record
7011	Form name is invalid
7013	Field name is invalid
7052	Invalid value/mandatory error
7020	No fields are present in the form

View extended list of error codes >

Request

Java JavaScript Curl Deluge Python

CopiedOkHttpClient client = new OkHttpClient().newBuilder()
  .build();
MediaType mediaType = MediaType.parse("application/x-www-form-urlencoded");
RequestBody body = RequestBody.create(mediaType, "inputData={Single_Line_1:\"a1\",Multi_Line_1:\"12\",Lookup_1:\"705358000000229001\"}");
Request request = new Request.Builder()
  .url("https://people.zoho.com/api/forms/json/test_form/insertRecord")
  .method("POST", body)
  .addHeader("Content-Type", "application/x-www-form-urlencoded")
  .addHeader("Authorization", "••••••")
  .build();
Response response = client.newCall(request).execute();

Copiedconst myHeaders = new Headers();
myHeaders.append("Content-Type", "application/x-www-form-urlencoded");
myHeaders.append("Authorization", "••••••");

const urlencoded = new URLSearchParams();
urlencoded.append("inputData", "{Single_Line_1:\"a1\",Multi_Line_1:\"12\",Lookup_1:\"705358000000229001\"}");

const requestOptions = {
  method: "POST",
  headers: myHeaders,
  body: urlencoded,
  redirect: "follow"
};

fetch("https://people.zoho.com/api/forms/json/test_form/insertRecord", requestOptions)
  .then((response) => response.text())
  .then((result) => console.log(result))
  .catch((error) => console.error(error));

Copiedcurl --location 'https://people.zoho.com/api/forms/json/test_form/insertRecord' \
--header 'Content-Type: application/x-www-form-urlencoded' \
--header 'Authorization: ••••••' \
--data-urlencode 'inputData={Single_Line_1:"a1",Multi_Line_1:"12",Lookup_1:"705358000000229001"}'

CopiedrecordMap1 = Collection();
recordMap1.insert("Single_Line_1":"a1");
recordMap1.insert("Multi_Line_1":"12");
recordMap1.insert("Lookup_1":"705358000000229001");
inputMap = Map();
inputMap.put("inputData",recordMap1);
AuthMap = Collection();
AuthMap.insert("Authorization":"••••••");
response = invokeUrl
[
	url: "https://people.zoho.in/people/api/forms/json/test_form/insertRecord"
	type: POST
	parameters: inputMap
	headers: AuthMap.toMap()
];
info response;

Copiedimport requests

url = "https://people.zoho.com/api/forms/json/test_form/insertRecord"

payload = 'inputData=%7BSingle_Line_1%3A%22a1%22%2CMulti_Line_1%3A%2212%22%2CLookup_1%3A%22705358000000229001%22%7D'
headers = {
  'Content-Type': 'application/x-www-form-urlencoded',
  'Authorization': '••••••'
}

response = requests.request("POST", url, headers=headers, data=payload)

print(response.text)

Show full

Show less

Sample Request

Copiedhttps://people.zoho.com/api/forms/json/test_form/insertRecord

Response

Copied{
    "response": {
        "result": {
            "pkId": "705358000000970013",
            "message": "Successfully Added"
        },
        "message": "Data added successfully",
        "uri": "/api/forms/json/test_form/insertRecord",
        "status": 0
    }
}

CRM

Voice

Sign

Forms

Bigin

SalesIQ

Bookings

RouteIQ

Thrive

CRM Plus

Zakya

Campaigns

Voice

Sign

Forms

Social

Survey

SalesIQ

Sites

Backstage

PageSense

Marketing Automation

LandingPage

Webinar

LeadChain

Domains

CommunitySpaces

Thrive

Publish

Marketing Plus

Commerce

Zakya

Desk

Assist

Voice

SalesIQ

Bookings

FSM

Lens

Solo

Service Plus

Books

Expense

Sign

Inventory

Invoice

Billing

Payroll

Commerce

Checkout

Practice

Solo

Payments

Finance Plus

Mail

Voice

Sign

WorkDrive

Bookings

Cliq

Notebook

Meeting

Connect

Learn

Office Integrator

Writer

TeamInbox

ZeptoMail

Show

Tables

Sheet

Office Suite

Calendar

ToDo

PDF Editor

Workplace

Vani

Expense

Recruit

People