LinkRelatedRecords
It is used to add the relation between modules.
Procedure-Specific Information
ZohoCRM Supports updating the relations for some specific modules and for adding the relation it requires ModuleName, Related ModuleName, RecordId of the module and RecordId of the related module.
ZohoCRM Requires atleast one related object in the request body to perform this operation and it can be added using the aggregate function.
For Example:
INSERT INTO LinkRelatedrecords#TEMP(RelatedRecordId#1,MemberStatus#1,RelatedRecordId#2,MemberStatus#2) values('4482327000000271429','Active','4482327000000271430',''); INSERT INTO LinkRelatedrecords#TEMP(RelatedRecordId#3) values('4482327000000271431') EXEC LinkRelatedrecords Module = 'Campaigns', RecordId = '4482327000000467001', RelatedModule = 'Leads', RelatedRecordsAggregate = 'LinkRelatedrecords#TEMP';
Note: This procedure makes use of indexed parameters. Indexed parameters facilitate providing multiple instances a single parameter as inputs for the procedure.
Suppose there is an input parameter named Param#. To input multiple instances of an indexed parameter like this, execute:
EXEC ProcedureName Param#1 = "value1", Param#2 = "value2", Param#3 = "value3"
In the table below, indexed parameters are denoted with a '#' character at the end of their names.
Input
Name | Type | Description |
Module | String | Supported Module name. |
RelatedModule | String | Related Module name. |
RecordId | String | Record id of the module. |
RelatedRecordId# | String | Record id of the related module. |
MemberStatus# | String | Member status of the relation. |
RelatedRecordsAggregate | String | An array of relations to update |