TaskAssignments

Represents assignments of tasks within Box, linking a task to the users responsible for completing it.

Table Specific Information

Task Assignments are Tasks assigned to a specific User.

Select

When selecting from the Task Assignments table, you must specify Id or TaskId in the WHERE clause.

SELECT * FROM TaskAssignments WHERE Id = '35991959268';

If you're authenticated as an administrator with user impersonation permissions, you can query task assignments from multiple user accounts. For example:

SELECT * FROM TaskAssignments WHERE AsUserId IN (SELECT Id FROM Users);

Note: User impersonation has the following limitations:

The authenticated user cannot be impersonated unless that user is a service account.
If the authenticated user is a standard user account, they can only query task assignments associated with their account.
Task assignments shared with multiple users are only returned for one of the users.

Insert

To insert into Task Assignments, connect a Task (TaskId) with a User (AssignedToId).

INSERT INTO TaskAssignments (TaskId, AssignedToId) VALUES (1001, 123);

Update

You can only update the Message of the Task Assignment or its ResolutionState.

UPDATE TaskAssignments SET Message = 'x', ResolutionState = 'completed' WHERE Id = '111';

Delete

Delete task assignments by specifying its Id:

DELETE FROM TaskAssignments WHERE Id = '111';

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	True	Unique identifier assigned to the task assignment.
TaskId	String	False	Identifier of the task that is being assigned.
AssignedToId	String	False	Identifier of the user who has been assigned to complete the task.
AssignedToName	String	False	The full name of the user who has been assigned the task.
AssignedToLogin	String	False	The login email of the user who has been assigned the task.
ItemType	String	False	Specifies the type of item associated with the task assignment, such as a file or folder.
ItemId	String	False	Identifier of the item associated with the task assignment.
ItemName	String	False	The display name of the item associated with the task assignment.
Message	String	False	The note or instructions attached to the task assignment.
AssignedById	String	False	Identifier of the user who created and assigned the task.
AssignedByName	String	False	The full name of the user who created and assigned the task.
AssignedByLogin	String	False	The login email of the user who created and assigned the task.
AssignedAt	Datetime	True	The date and time when the task was assigned.
RemindedAt	Datetime	True	The date and time when a reminder for the task was sent.
CompletedAt	Datetime	True	The date and time when the task was marked as completed.
ResolutionState	String	False	The current status of the task assignment, indicating whether it has been addressed or remains unresolved. The allowed values are completed, incomplete, approved, rejected.
AsUserId	String	False	Identifier of the user to impersonate for API requests, available only for Admin, Co-Admin, and Service Accounts.