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 |
Request
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)Sample Request
Copiedhttps://people.zoho.com/api/forms/json/test_form/insertRecordResponse
Copied{
"response": {
"result": {
"pkId": "705358000000970013",
"message": "Successfully Added"
},
"message": "Data added successfully",
"uri": "/api/forms/json/test_form/insertRecord",
"status": 0
}
}