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 Streak Views
| Name | Description |
| Boxes | This call lets you get all boxes contained in the specified pipeline. |
| BoxesContacts | This call lists the contacts defined in a box. |
| BoxesOrganizations | This call lists the organizations defined in a box. |
| Comments | Retrieve comments. |
| Contacts | Retrieve contacts. |
| EmailFilters | Retrieves an array of email filters within a box. |
| Files | Retrieve Streak files from a specific box. |
| Meetings | Retrieve mettings for a specific box. |
| Newsfeeds | This endpoint will give you historical changes for boxes and pipelines. It is limited to the 50 most recent events. |
| Organizations | Retrieve organizations from Streak. |
| Pipelines | Gets list of pipelines and also retrive a single pipeline |
| Snippets | This call lets you get all the snippets for a user, also you can get a single snippet |
| Stages | This call gives you a specific stage defined in a pipeline. |
| Tasks | Retrieves tasks from Streak. |
| TeamMembers | Retrieve members of teams. Users can be on 0 or more teams. |
| Teams | Retrieve teams from Streak. Users can be on 0 or more teams. |
| Threads | Retrieve threads from Streak. |
| Users | Retrieve users details. |
| Webhooks | Retrieves webhoods from Streak. |