Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.
| Property | Description |
| ExpandAsterisk | Indicates whether the asterisk should be expanded in the $select query parameter. |
| MaxRows | Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses. |
| MaxSelectLength | To avoid the query risks failing with [414] URI Too Long error, we apply a length limit of the columns in projection($select) which defaults to 1000. This property is useful to increase the limit in case there are circumstances where the service does not restrict the URI length or the user wants the limit to be higher for $select. To disable length limitation set this property to -1. This property can not be used when the ServiceType connection property is set to AnalyticsService. |
| NavigationPropertiesAsViews | A boolean indicating navigation properties should be promoted to full views. |
| Other | These hidden properties are used only in specific use cases. |
| Readonly | You can use this property to enforce read-only access to SAP ByDesign from the provider. |
| Timeout | The value in seconds until the timeout error is thrown, canceling the operation. |
| UseDisplayNames | Boolean determining whether or not to use SAP labels. |
| UserDefinedViews | A filepath pointing to the JSON configuration file containing your custom views. |