Excel Add-In for ServiceNow

Build 24.0.9060

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.


PropertyDescription
DisplayValueBased on this value, the provider retrieves the display value or the actual value from the database.
DisplayValueColumnNamePattern for displaying column names when DisplayValue property is set to ALL.
EnforceColumnValuesControls whether available values for an element are retrieved and checked when executing INSERT or UPDATE statements.
ExcludeReferenceLinkBased on this value, the additional information provided for reference fields will be suppressed or not.
GetColumnsMetadataIndicates the user preference as to when and how the provider should get the columns metadata.
MaxRowsLimits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.
OtherThese hidden properties are used only in specific use cases.
PagesizeThe maximum number of results to return per page from ServiceNow.
ReadonlyYou can use this property to enforce read-only access to ServiceNow from the provider.
ShowDescriptionsControls whether column and table descriptions are returned via the sys_documentation and sys_db_object API endpoints.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
UseDisplayTableNamesBoolean determining if the display names for the table should be used instead of the API names.
UserDefinedViewsA filepath pointing to the JSON configuration file containing your custom views.

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