Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
| Property | Description |
| Archived | Specifies whether the provider retrieves archived records when querying supported objects. |
| CallPropertiesFile | Specifies a comma-separated list or file path containing the names of fields to retrieve for the Calls table. |
| ColumnSizes | Specifies a comma-separated list that defines custom column sizes for specific fields. |
| CompanyPropertiesFile | Specifies a comma-separated list or file path containing the names of fields to retrieve for the Companies table. |
| ContactPropertiesFile | Specifies a comma-separated list or file path containing the names of fields to retrieve for the Contacts table. |
| DealPropertiesFile | Specifies a comma-separated list or file path containing the names of fields to retrieve for the Deals table. |
| EmailPropertiesFile | Specifies a comma-separated list or file path containing the names of fields to retrieve for the Emails table. |
| ExpandAssociations | Specifies whether the provider expands association tables to include one table per object-to-object relationship. |
| FeedbackSubmissionPropertiesFile | Specifies a comma-separated list or file path containing the names of fields to retrieve for the FeedbackSubmissions table. |
| GenerateSchemaFiles | Indicates the user preference as to when schemas should be generated and saved. |
| GoalPropertiesFile | Specifies a comma-separated list or file path containing the names of fields to retrieve for the Goals table. |
| IncludeCustomTables | Specifies whether the provider includes custom HubSpot objects in the schema. |
| LeadPropertiesFile | Specifies a comma-separated list or file path containing the names of fields to retrieve for the Leads table. |
| LineItemPropertiesFile | Specifies a comma-separated list or file path containing the names of fields to retrieve for the LineItems table. |
| MaxRows | Specifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY. |
| MeetingPropertiesFile | Specifies a comma-separated list or file path containing the names of fields to retrieve for the Meetings table. |
| NotePropertiesFile | Specifies a comma-separated list or file path containing the names of fields to retrieve for the Notes table. |
| NumberColumnMode | Specifies how the provider represents numeric fields detected as number types in HubSpot. |
| OrderPropertiesFile | Specifies a comma-separated list or file path containing the names of fields to retrieve for the Orders table. |
| Other | Specifies 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. |
| Pagesize | Specifies the maximum number of records to retrieve per page when querying data from HubSpot. |
| ProductPropertiesFile | Specifies a comma-separated list or file path containing the names of fields to retrieve for the Products table. |
| QuotePropertiesFile | Specifies a comma-separated list or file path containing the names of fields to retrieve for the Quotes table. |
| Readonly | Toggles read-only access to HubSpot from the provider. |
| TaskPropertiesFile | Specifies a comma-separated list or file path containing the names of fields to retrieve for the Tasks table. |
| TicketPropertiesFile | Specifies a comma-separated list or file path containing the names of fields to retrieve for the Tickets table. |
| Timeout | Specifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error. |
| UseDisplayNames | Specifies whether to use HubSpot's display names for tables and columns instead of their internal API names. |
| UseDropdownLabels | Specifies whether to return dropdown labels instead of internal values for custom enum fields. |
| UserDefinedViews | Specifies a filepath to a JSON configuration file that defines custom views. The provider automatically detects and uses the views specified in this file. |
| UseSimpleNames | Specifies whether or not simple names should be used for tables and columns. |