Excel Add-In for Kintone

Build 25.0.9434

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 number of rows returned for queries that do not include either 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., to be used only when our Support team advises it, to address specific issues. See Remarks for details.
PagesizeSpecifies the maximum number of records per page the provider returns when requesting data from Kintone.
ReadonlyToggles read-only access to Kintone from the provider.
SubtableIdAsLongSpecifies whether the Id column in subtables should use the Long data type.
SubtableSeparatorCharacterThe character used for dividing tables from subtables in the format tablename + char + subtable.
TableNameModeThe dynamic table identifier for each AppId.
TimeoutSpecifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error.
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 that defines custom views. The provider automatically detects and uses the views specified in this file.
UseSimpleNamesSpecifies whether or not 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 25.0.9434