Newsfeeds
This endpoint will give you historical changes for boxes and pipelines. It is limited to the 50 most recent events.
Table Specific Information
Select
Streak allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only = comparision. The available columns for Newsfeeds are BoxKey and PipelineKey. For example:
SELECT * FROM Newsfeeds WHERE BoxKey='agxzfm1haWxmb29nYWVyLAsSDE9yZ2FuaXphdGlvbiIJY2RhdGEuY29tDAsSBENhc2UYgICsv6fs-ggM' AND detailLevel='ALL' SELECT * FROM Newsfeeds WHERE PipelineKey='agxzfm1haWxmb29nYWabMAsSDE9yZ2FuaXphdGlvbiIJY2RhdGEuY29tDAsSCFdvcmtmbG93GICArJ_i0_EIDA'
Columns
| Name | Type | References | Description |
| NewsfeedItemKey [KEY] | String | The news feed item key. | |
| NewsfeedEntryKey | String | The news feed entry key. | |
| CreatorKey | String |
Users.UserKey | The key of the user that created this newsfeed item. |
| Timestamp | Timestamp | When this event occurred. | |
| NewsfeedEntryScope | String | What this event applies to - either a BOX or PIPELINE. | |
| NewsfeedEntryOperation | String | Whether this event refers to a CREATE, UPDATE, or DELETE. | |
| NewsfeedEntrySpecific | String | What specifically happened to cause this event. | |
| SpecificVariablesAssignedTo | String | Member assigned to the particular newsfeed. | |
| SpecificVariablesStoryAuthorDisplayName | String | Display name of the story author. | |
| SpecificVariablesBoxName | String | Name of the box. | |
| SpecificVariablesOldStageName | String | Name of an old stage. | |
| SpecificVariablesLastStageChangeTimestamp | Timestamp | Last time the stage was chagned. | |
| SpecificVariablesStageName | String | Name of the stage. | |
| SpecificVariablesStageKey | String |
Stages.StageKey | Key of the stage. |
| SpecificVariablesPipelineName | String | Name of the pipeline. | |
| SpecificVariablesOldStageKey | String |
Stages.StageKey | Key of the old stage. |
| BoxKey | String |
Boxes.BoxKey | Key of the box. |
| PipelineKey | String |
Pipelines.PipelineKey | Key of the pipeline. |
| Moved | Boolean | Whether the news feed is moved or not. | |
| StoryTextGlobal | String | Global story text used for the news feed. | |
| StoryTextPipeline | String | Pipeline story text used for the news feed. | |
| StoryTextBox | String | Box story text used for the news feed. | |
| UserText | String | A user entered description. | |
| ExpandedUserText | String | Details like full name and email id of the user. | |
| DetailText | String | A more detailed description. | |
| UserImageUrl | String | URL of the user profile photo. | |
| CollapsedEntries | String | List of collapsed entries. | |
| LastSavedTimestamp | Timestamp | When the item was last saved. | |
| detailLevel | String | This is similar to the specifics parameter but uses a predetermined set of specifics to filter on. The possible values for this parameter are ALL or CONDENSED. The CONDENSED value limits the results to only certain important specific parameters determined by Streak.
The allowed values are ALL, CONDENSED. |