Insert Record API
To add a record to the form.
Request URL:
https://people.zoho.com/people/api/forms/<inputType>/<formLinkName>/insertRecord?inputData=<inputData>
Header:
Authorization:Zoho-oauthtoken 1000.8cb99dxxxxxxxxxxxxx9be93.9b8xxxxxxxxxxxxxxxf
Scope:
scope=ZOHOPEOPLE.forms.ALL
OR
scope = ZOHOPEOPLE.forms.CREATE
Possible Operation Types:
ALL - Full access to data
CREATE - Create form data
Request Parameters:
| formLinkName | Form label name. To get formLinkName, refer appendix |
| inputType | XML or json |
| inputData | XML input: <Request><Record><field name="Labelname">value</field><field name="LabelName1">value1</field><field name="Labelname2">value2</field></Record></Request> (refer appendix to know about field label name) |
| JSON input: {LabelName:'value',LabelName1:'value1',LabelName2:'value2'} |
NOTE : To insert a record in tabular section, the values should be sent in JSON Array.
Example:
1.To insert a record in tabular section, the values should be sent in JSON Array.
Request URL:
https://people.zoho.com/people/api/forms/json/Previous_Employment/insertRecord?inputData={Employee_ID:'1001',Previous_Company_Name:['Company1', 'Company 2'],Previous_Designation:['Engineer','Manager']}
Header:
Authorization:Zoho-oauthtoken 1000.8cb99dxxxxxxxxxxxxx9be93.9b8xxxxxxxxxxxxxxxf
Here, Previous_Company_Name and Previous_Designation are the field label name of the tabular section.
Below is the added record.
2. If the form contains any Lookup fields, then Lookup value id has to be sent in the API request instead of lookup value. Refer Appendix Point 2 > Method 3 to get the lookup value using get component API.
3. If the form contains muti-select field (for Example, multi-select dropdown), then the values for the field should be sent with “;”(colon) as the separator.
Format :
Field_Label_Name : ‘Value1;Value2’
Threshold Limit: 300 requests | Lock period: 5 minutes
Threshold Limit - Number of API calls allowed within a minute.
Lock Period - Wait time before consecutive API requests.
Request
Copiedhttps://people.zoho.com/people/api/forms/json/Travel_Request/insertRecord?inputData={Employee_ID:'1001',Travel_Date:'21-Nov-2109'}Header
CopiedAuthorization:Zoho-oauthtoken 1000.8cb99dxxxxxxxxxxxxx9be93.9b8xxxxxxxxxxxxxxxfResponse
Copied{"response":{"result":{"pkId":"112674000000235025","message":"Successfully Added"},"message":"Data added successfully","uri":"/api/forms/json/Travel_Request/insertRecord","status":0}}