Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.
Property | Description |
AccountsServer | The full Account Server URL. |
AggregateColumnSize | Sets the length of a aggregate field for a provider. |
APIDomain | The full URL of the API domain. |
BatchSize | The maximum size of each batch operation to submit. |
ConnectionLifeTime | The maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed. |
ConnectOnOpen | This property specifies whether to connect to the Zoho CRM when the connection is opened. |
IncludeCustomViews | If set to true, the provider will display custom views among the other views and make them available for use. |
IncludeRelatedLists | If set to true, the provider will display related List views among the other views and make them available for use. |
MaxRows | Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses. |
Other | These hidden properties are used only in specific use cases. |
PageSize | The number of results to return per page of data retrieved from Zoho CRM. |
PoolIdleTimeout | The allowed idle time for a connection before it is closed. |
PoolMaxSize | The maximum connections in the pool. |
PoolMinSize | The minimum number of connections in the pool. |
PoolWaitTime | The max seconds to wait for an available connection. |
PseudoColumns | This property indicates whether or not to include pseudo columns as columns to the table. |
Readonly | You can use this property to enforce read-only access to Zoho CRM from the provider. |
RTK | The runtime key used for licensing. |
Timeout | The value in seconds until the timeout error is thrown, canceling the operation. |
UseConnectionPooling | This property enables connection pooling. |
UseCOQL | Determines whether to use Query API. |
UseDisplayNames | If set to false, the provider will use api names for some operations. |
UserDefinedViews | A filepath pointing to the JSON configuration file containing your custom views. |
UseSandbox | Determines whether the calls will be sent to a Sandbox instance instead of a regular one. |
UseServerSideFiltering | If set to false, the provider will not send the filters server-side but will process them client-side. |
UseSimpleNames | Boolean determining if simple names should be used for tables and columns. |