Boxes
This call lets you get all boxes contained in the specified pipeline.
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 Boxes are BoxKey and PipelineKey. For example:
SELECT * FROM Boxes WHERE PipelineKey='agxzfm1haWxmb29nYWVyMAsSDE9yZ2FuabphdGlvbiIJY2RhdGEuY29tDAsSCFdvcmtmbG93GICArJ_i0_EIDA' SELECT * FROM Boxes WHERE BoxKey='agxzfm1haWxmb29nYWVyLAsSDE9yZ2FuaXphdabvbiIJY2RhdGEuY29tDAsSBENhc2UYgICs7-O4mwsM'
Columns
| Name | Type | References | Description |
| BoxKey [KEY] | String | Key of Box | |
| LastSavedTimestamp | Timestamp | Time stamp saved last in ePoch format | |
| PipelineKey | String |
Pipelines.PipelineKey | Key of the pipeline the box is in |
| CreatorKey | String |
Users.UserKey | Key of a creator |
| CreationTimestamp | Timestamp | Time stamp when box was created | |
| LastUpdatedTimestamp | Timestamp | Timestamp of the last time the box was updated | |
| LastStageChangeTimestamp | Timestamp | Time stamp when box was updated | |
| TotalNumberOfEmails | Integer | Count of total number of emails | |
| TotalNumberOfSentEmails | Integer | Count of total number of emails sent | |
| TotalNumberOfReceivedEmails | Integer | Count of total number of emails received | |
| Name | String | Name of the box found | |
| Notes | String | Sample notes for description of box | |
| AssignedToSharingEntries | String | Details of number of user assigned to | |
| CreatorSharingEntry | String | Details of number of user created | |
| FollowerSharingEntries | String | Details of number of user followers | |
| FollowerKeys | String | Key of the followers of this box | |
| LinkedBoxKeys | String | Any key linked to the particular box | |
| EmailAddressesAutoExtracted | String | List of email which can be auto extracted | |
| EmailAddressesBlacklist | String | List of email address which is blacklist by user | |
| EmailAddresses | String | List of email addresses | |
| TaskCompleteCount | Integer | Count of task which is completed | |
| TaskIncompleteCount | Integer | Count of task which is incompleted | |
| TaskOverdueCount | Integer | Count of task which is overdue | |
| TaskAssigneeKeySet | String | List of key set the task is assigned to | |
| OverdueTaskAssigneeKeySet | String | List of key set the overdue task is assigned to | |
| IncompleteTaskAssigneeKeySet | String | List of key set the incomplete task is assigned to | |
| TaskAssigneeSharingEntrySet | String | Set of users whom task is assigned to | |
| OverdueTaskAssigneeSharingEntrySet | String | Set of users whom task is assigned to but overdue | |
| IncompleteTaskAssigneeSharingEntrySet | String | Set of users whom task is assigned to but is incomplete | |
| TaskTotal | Integer | List of total number of tasks | |
| CallLogCount | Integer | List of call log count | |
| MeetingNotesCount | Integer | List of meeting notes | |
| TotalCallLogDuration | Integer | List of total call log duration | |
| TotalMeetingNotesDuration | Integer | Lost of total meeting duration notes | |
| FollowerCount | Integer | Count of number of followers | |
| CommentCount | Integer | Count of number of comments | |
| GmailThreadCount | Integer | Count of number of gmail threads | |
| FileCount | Integer | Count of number of files | |
| Fields | String | Number of fields | |
| Freshness | Double | Amount of freshness | |
| StageKey | String |
Stages.StageKey | A unique identifier for the containing folder. Set this in the filter to retreive only files under the specified parent folder. |