Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
Property | Description |
AllowSpecialCharacters | Determines whether or not to allow special characters. If true special characters will not be replaced. |
CheckForSubtablesIn | A comma-separated list of Kintone apps to retrieve subtables from. |
GuestSpaceId | Restrict query results to a guest space. |
MaxRows | Specifies the maximum rows returned for queries without aggregation or GROUP BY. |
NumberMapToDouble | Determines whether or not to change the datatype of number fields from decimal to double. |
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 | Specifies 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. |
Readonly | Toggles read-only access to Kintone from the provider. |
SubtableSeparatorCharacter | The character used for dividing tables from subtables in the format tablename + char + subtable. |
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. |
UseCodeForFieldName | Determines whether to use Label or Code for Field Name. |
UseCursor | Boolean determining if cursors should be used to retrieve records. |
UserDefinedViews | Specifies a filepath to a JSON configuration file defining custom views. The provider automatically detects and uses the views specified in this file. |
UseSimpleNames | Boolean determining if simple names should be used for tables and columns. |
UseUnitForNumericField | Determines whether to display unit with Field Name. |