ScoreDetails
Query the score details of a contact.
View Specific Information
To query data from this view, you must specify ContactId.
The adapter will use the ActOn API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the adapter.
- ContactId supports the '=' and 'IN' operators.
For example, the following queries are processed server side:
SELECT * FROM ScoreDetails WHERE ContactId = 'l-0004:2' SELECT * FROM ScoreDetails WHERE ContactId IN ('l-0004:2', 'l-0004:3')
Columns
Name | Type | Description |
ContactId [KEY] | String | Unique identifier of the contact. |
ActivityId | String | Unique identifier of the activity. |
Action | String | Brief description of the action. |
IdType | String | Type of the activity. |
Profile | Boolean | Whether or not the user has a profile. |
Score | Integer | Score of the activity. |
Specific | Boolean | Whether or not the activity is specific. |
Ago | Integer | Days ago that activity happened. |
InScoreRange | Boolean | Whether or not the activity is in score range. |
What | String | Object of the activity. |
When | Datetime | When the activity happened. |
Bin | String | Subject of the activity. |
Verb | String | Description of the activity. |