Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
CData JDBC Driver for HubSpot Views
| Name | Description |
| AssociationsTypes | Retrieve all available association types between a pair of CRM objects. |
| CustomObjectProperties | Retrieve the available Custom Objects Properties in HubSpot. |
| CustomObjects | Retrieve the available Custom Objects in HubSpot. |
| Files | Search through files in the file manager. Does not display hidden or archived files. Requires files or files.ui_hidden.read as a scope. |
| Folders | Search for folders. Does not contain hidden or archived folders. Requires files or files.ui_hidden.read as a scope. |
| Owners | HubSpot uses owners to assign CRM objects to specific people in your organization. The endpoints described here are used to get a list of the owners that are available for an account. |
| ThreadMessages | Retrieve the entire message history in a Thread |
| WebAnalytics | The Web Analytics endpoint allows developers to find and filter events associated with a CRM object of any type. |