ODBC Driver for Trello

Build 24.0.9062

OrganizationMembers

List the members in a Organization.

Columns

Name Type Description
Id [KEY] String Id of the member.
Username String The username of this account.
FullName String The full name related to the account, if it is public.
AaEmail String AaEmail field of this member.
AaEnrolledDate String AaEnrolledDate field of this member.
AaId String AaId field of this member.
ActivityBlocked Boolean ActivityBlocked field of this member.
AvatarHash String AvatarHash field of this member.
AvatarSource String AvatarSource field of this member.
AvatarUrl String The url of this member's avatar.
Bio String Bio of the member.
BioData String Bio Data of the member.
Confirmed Boolean Whether the user has confirmed their email address for their account.
Email String Email of the member.
GravatarHash String The Gravatar Hash.
IdBoards String List of boards this member belongs to.
IdBoardsPinned String Id boards pinned of the member.
IdEnterprise String Id enterprise of the member.
IdEnterprisesAdmin String Id enterprises admin of the member.
IdEnterprisesDeactivated String Id enterprises deactivated of the member.
IdMemberReferrer String Id member referrer.
IdOrganizations String List of workspaces this member belongs to.
IdPremOrgsAdmin String IdPremOrgsAdmin field of this member.
Initials String The initials related to the account, if it is public.
IsAaMastered Boolean IsAaMastered field of this member.
IxUpdate Integer IxUpdate field of this member.
LimitsDisableAt Integer Limits disable at.
LimitsStatus String Limits status.
LimitsWarnAt Integer Limits warn at.
LoginTypes String Login types of the member.
MarketingDate Datetime Marketing opt-in date.
MarketingOptedIn Boolean Marketing opt-inOptedIn of the member.
MemberType String Type of the member.
MessagesDismissedId String Messages dismissed id of the member.
MessagesDismissedCount String Messages dismissed count of the member.
MessagesDismissedLastDismissed Datetime Messages dismissed last dismissed of the member.
MessagesDismissedName String Messages dismissed name of the member.
NonPublicAvailable Boolean Non public Available field of this member.
NonPublicAvatarHash String Non public AvatarHash field of this member.
NonPublicAvatarUrl String Non public AvatarUrl field of this member.
NonPublicFullName String Non public FullName field of this member.
NonPublicInitials String Non public Initials field of this member.
OneTimeMessagesDismissed String One time messages dismissed field of this member.
PrefsColorBlind Boolean Preferred ColorBlind field of this member.
PrefsLocale String Preferred Locale field of this member.
PrefsMinutesBeforeDeadlineToNotify Integer Preferred MinutesBeforeDeadlineToNotify field of this member.
PrefsMinutesBetweenSummaries Integer Preferred MinutesBetweenSummaries field of this member.
PrefsPrivacyAvatar String Preferred PrivacyAvatar field of this member.
PrefsPrivacyFullName String Preferred PrivacyFullName field of this member.
PrefsSendSummaries Boolean Preferred SendSummaries field of this member.
PrefsTimezone String The preferred timezone of this member.
PrefsTimezoneInfoDateNext Datetime Preferred TimezoneInfoDateNext field of this member.
PrefsTimezoneInfoOffsetCurrent Integer Preferred TimezoneInfoOffsetCurrent field of this member.
PrefsTimezoneInfoOffsetNext Integer Preferred TimezoneInfoOffsetNext.
PrefsTimezoneInfoTimezoneCurrent String Preferred TimezoneInfoTimezoneCurrent field of this member.
PrefsTimezoneInfoTimezoneNext String Preferred TimezoneInfoTimezoneNext field of this member.
PrefsTwoFactorEnabled Boolean Preferred TwoFactorEnabled field of this member.
PrefsTwoFactorNeedsNewBackups Boolean Preferred TwoFactorNeedsNewBackups field of this member.
PremiumFeatures String Premium features of the member.
Products Integer Products of the member.
Status String Status of the member.
Trophies String Trophies of the member.
UploadedAvatarHash String Uploaded avatar hash.
UploadedAvatarUrl String Uploaded avatar url.
Url String Url field of this member.
OrganizationId [KEY] String The Id of the organization where the member is part of.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062