Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.
| Property | Description |
| CallerId | The Id of a user to impersonate when inserting or updating new records. |
| DefaultPrecision | The currency precision that is used for pricing throughout the system. Valid values are 0-4 and Auto. If the value is Auto, the default value will be retrieved from the Microsoft Dynamics CRM server. |
| ExposeVirtualSubColumn | Boolean that exposes a virtual subcolumn to return data in a different format. |
| IncludeCalculatedColumns | This option controls whether the driver returns the Calculated Columns defined on a table. Only applicable for CRM 2015+. |
| LanguageCode | The code indicating the language. |
| MaxRows | Specifies the maximum rows returned for queries without aggregation or GROUP BY. |
| Other | Specifies additional hidden properties for specific use cases. These are not required for typical provider functionality. Use a semicolon-separated list to define multiple properties. |
| Pagesize | The maximum number of records per page the provider returns when requesting data from Microsoft Dynamics CRM. |
| PseudoColumns | Specifies the pseudocolumns to expose as table columns. Use the format 'TableName=ColumnName;TableName=ColumnName'. The default is an empty string, which disables this property. |
| QueryMethod | The method to use when querying data from Dynamics CRM. In most cases FetchXML will work with all tables. |
| QueryPassthrough | This option passes the query to the Microsoft Dynamics CRM server as is. |
| Readonly | Toggles read-only access to Microsoft Dynamics CRM from the provider. |
| RTK | Specifies the runtime key for licensing the provider. If unset or invalid, the provider defaults to the standard licensing method. Use this property only in environments where the standard licensing method is unsupported or requires a runtime key. |
| SavedQueryFilter | A comma-separated list of filters to use for displaying Saved Queries as views (ex: Accounts%,Contacts%). |
| Timeout | Specifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error. The default is 60 seconds. Set to 0 to disable the timeout. |
| UseDisplayNames | Boolean determining if the display names for the columns should be used instead of the API names. UseDisplayNames and UseSchemaNames are mutually exclusive. |
| UseDisplayTableNames | Boolean determining if the display names for the table should be used instead of the API names. |
| UseNameForPicklistValue | Boolean determining if the string value should be used for picklist field values instead of integers. |
| UserDefinedViews | Specifies a filepath to a JSON configuration file defining custom views. The provider automatically detects and uses the views specified in this file. |
| UseSchemaNames | Boolean determining if the schema names for the table should be used instead of the API names. UseDisplayNames and UseSchemaNames are mutually exclusive. |
| UseSimpleNames | Boolean determining if simple names should be used for tables and columns. |