Upgrading to SOTI Assist 2.0
Starting with SOTI Assist 2.0, user IDs are generated as globally unique identifiers (GUID). Previously, SOTI Assist used incremental numbering. Existing user IDs are automatically converted to the new format upon upgrade. You can see mappings between the new and old format for existing user IDs in the UserInfo database table.
If you rely on User IDs to integrate SOTI Assist with third-party tools, you may need to update those integrations manually. Read Changes in SOTI Assist 2.0 that may affect customers using Assist APIs on SOTI Central for more information.
Database Tables
The following database tables were changed in SOTI Assist 2.0.
Database Table Name | Old Column | New Column |
---|---|---|
dbo.Activity | CreationUserId | CreationUserPublicId |
dbo.Activity | UpdateUserId | UpdateUserPublicId |
dbo.ActivityEmailAddress | RecipientId | RecipientPublicId |
dbo.ApiClient | CreationUserId | CreationUserPublicId |
dbo.IncidentTicket | AssigneeId | AssigneePublicId |
dbo.IncidentTicket | CreationUserId | CreationUserPublicId |
dbo.IncidentTicket | ReporterId | ReporterPublicId |
dbo.IncidentTicket | ResolutionUserId | ResolutionUserPublicId |
dbo.Settings | UserInfoId | UserInfoPublicId |
dbo.UserInfo | UserInfoId | UserInfoPublicId |
dbo.Watcher | UserInfoId | UserInfoPublicId |
API Calls
The following API calls were changed in SOTI Assist 2.0.
Method | Route | URL | Query String | Request Body | Response Body |
---|---|---|---|---|---|
GET
|
sotiassist/account/assigneeList | ⬤ | |||
POST
|
sotiassist/email/validateRecipients | ⬤ | ⬤ | ||
POST
|
sotiassist/privacy/anonymizeUser/{userPublicId} | ⬤ | |||
GET
|
sotiassist/reporter | ⬤ | ⬤ | ||
POST
|
sotiassist/reporter | ⬤ | |||
GET
|
sotiassist/reporter/{publicId} | ⬤ | ⬤ | ||
PUT
|
sotiassist/reporter/{publicId} | ⬤ | ⬤ | ⬤ | |
GET
|
sotiassist/search/devices/{deviceId}/tickets | ⬤ | ⬤ | ||
GET
|
sotiassist/search/tickets | ⬤ | ⬤ | ||
GET
|
sotiassist/ticket | ⬤ | ⬤ | ||
POST
|
sotiassist/ticket | ⬤ | ⬤ | ||
GET
|
sotiassist/ticket/{id} | ⬤ | |||
GET
|
sotiassist/ticket/{id}/activities | ⬤ | ⬤ | ||
POST
|
sotiassist/ticket/{id}/activities | ⬤ | ⬤ | ||
GET
|
sotiassist/ticket/{id}/activities/{activityId} | ⬤ | |||
PUT
|
sotiassist/ticket/{id}/activities/{activityId} | ⬤ | ⬤ | ||
POST
|
sotiassist/ticket/{id}/activities/attachments/upload | ⬤ | |||
POST
|
sotiassist/ticket/{id}/activities/email/send | ⬤ | ⬤ | ||
POST
|
sotiassist/ticket/{id}/activities/snapshot/save | ⬤ | |||
PUT
|
sotiassist/ticket/{id}/assigneePublicId | ⬤ | ⬤ | ⬤ | |
PUT
|
sotiassist/ticket/{id}/description | ⬤ | |||
PUT
|
sotiassist/ticket/{id}/priority | ⬤ | |||
PUT
|
sotiassist/ticket/{id}/reportedMethod | ⬤ | |||
PUT
|
sotiassist/ticket/{id}/reporterPublicId | ⬤ | ⬤ | ⬤ | |
PUT
|
sotiassist/ticket/{id}/status | ⬤ | |||
PUT
|
sotiassist/ticket/{id}/title | ⬤ | |||
DELETE
|
sotiassist/ticket/{ticketId}/watchers | ⬤ | |||
GET
|
sotiassist/ticket/{ticketId}/watchers | ⬤ | |||
POST
|
sotiassist/ticket/{ticketId}/watchers | ⬤ | ⬤ | ||
GET
|
sotiassist/ticket/search | ⬤ | ⬤ | ||
GET
|
sotiassist/ticket/statistics/assignees/to/tickets | ⬤ | ⬤ | ||
GET
|
sotiassist/userinfo | ⬤ | |||
GET
|
sotiassist/userinfo/{userInfoPublicId} | ⬤ | ⬤ | ||
GET
|
sotiassist/userinfo/{userInfoPublicId}/refresh | ⬤ | |||
GET
|
sotiassist/userinfo/anonymous | ⬤ | |||
POST
|
sotiassist/userinfo/cache/refresh | ⬤ | |||
GET
|
sotiassist/userinfo/current | ⬤ | |||
GET
|
sotiassist/userinfo/groups/mobicontrol | ⬤ | |||
GET
|
sotiassist/userinfo/search | ⬤ | ⬤ |