Excel Add-In for Kintone

Build 24.0.9175

Miscellaneous

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


PropertyDescription
AllowSpecialCharactersDetermines whether or not to allow special characters. If true special characters will not be replaced.
CheckForSubtablesInA comma-separated list of Kintone apps to retrieve subtables from.
GuestSpaceIdRestrict query results to a guest space.
MaxRowsSpecifies the maximum rows returned for queries without aggregation or GROUP BY.
NumberMapToDoubleDetermines whether or not to change the datatype of number fields from decimal to double.
OtherSpecifies additional hidden properties for specific use cases. These are not required for typical provider functionality. Use a semicolon-separated list to define multiple properties.
PagesizeSpecifies the maximum number of results to return from Kintone, per page. This setting overrides the default page size set by the datasource, which is optimized for most use cases.
ReadonlyToggles read-only access to Kintone from the provider.
SubtableSeparatorCharacterThe character used for dividing tables from subtables in the format tablename + char + subtable.
TimeoutSpecifies 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.
UseCodeForFieldNameDetermines whether to use Label or Code for Field Name.
UseCursorBoolean determining if cursors should be used to retrieve records.
UserDefinedViewsSpecifies a filepath to a JSON configuration file defining custom views. The provider automatically detects and uses the views specified in this file.
UseSimpleNamesBoolean determining if simple names should be used for tables and columns.
UseUnitForNumericFieldDetermines whether to display unit with Field Name.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175