JDBC Driver for Zoho CRM

Build 24.0.9060

LinkRelatedRecords

Adds 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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060