JDBC Driver for Basecamp

Build 22.0.8462

Assignments

Retrieve Assignments on Basecamp 3.

Columns

Name Type References Description
Id [KEY] Long The unique identifier for the person.
TodoListId Long

ToDoLists.Id

The unique identifier for the todolist.
ProjectId Long

Projects.Id

Use filter to retrieve active people on the project with the given ID.
Name String The name of the person.
Owner Boolean Boolean value to show if the current person is the account owner.
Admin Boolean Boolean value to show if the current person is an admin or not.
Title String The title of the person.
Bio String Bio description of the person.
CreatedAt Datetime The date and time when the record was created.
UpdatedAt Datetime The date and time when the record was last updated.
EmailAddress String The email address of the person.
AttachableSgid String The attachable Set Group ID.
PersonableType String Type of the person.
TimeZone String Human readable timezone for the user.
CompanyId Long Id of users company.
CompanyName String Name of users company.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462