AddContactToBox
Allows adding a contact to a box.
Stored Procedures Specific Information
Process of adding contact to box
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 AddContactToBox are ContactKey, IsStarred and Key. For example:
Insert into ContactAggregate#TEMP(ContactKey,IsStarred) values('VGVhbUNvbnRhY3Qabn5zdHJlYWtsb25naWR-fjUxMjU1MabyNjQ5MjQxNjA','true');
Exec AddContactToBox ContactAggregate = 'ContactAggregate#TEMP', key='agxzfm1haWxmb29nYWVyLAsSDE9yZ2FuaXabdGlvbiIJY2RhdGEuY29tDAsSBENhc2UYgICsv6fs-ggM';
The second way of using the Stored Procedure is by adding the aggregate itself:
EXECUTE AddContactToBox ContactAggregate = '{
"ContactKey": "VGVhbUNvbnRhY3Qsfn5zdHJOpatsb25naWR-fjUxMjU1MDYyNjQ5MjQxNjA",
"IsStarred": "true"
}', key='agxzfm1haWxmb29nYWVyLAsSDE9yZ2srgphdGlvbiIJY2RhdGEuY29tDAsSBENhc2UYgICsv6fs-ggM'
Input
| Name | Type | Required | Description |
| Key | String | True | Key of the Box. |
| ContactKey | String | False | Key of the contact to add. |
| IsStarred | String | False | Indicates if the contact should be starred or not. |
| ContactAggregate | String | False | This is a map of your property names to the values for this object. These are the values that we will sync into corresponding Contact object. |
Result Set Columns
| Name | Type | Description |
| Status | String | Stored procedure execution status. |