Windsor brings all your Trello data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Trello Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| actions__data | OBJECT | actions.data | actions.data | actions |
| actions__date | DATE | actions.date | actions.date | actions |
| actions__id | TEXT | actions.id | actions.id | actions |
| actions__idMemberCreator | TEXT | actions.idMemberCreator | actions.idMemberCreator | actions |
| actions__limits | OBJECT | actions.limits | actions.limits | actions |
| actions__member | OBJECT | actions.member | actions.member | actions |
| actions__memberCreator | OBJECT | actions.memberCreator | actions.memberCreator | actions |
| actions__type | TEXT | actions.type | actions.type | actions |
| boards__closed | BOOLEAN | boards.closed | boards.closed | boards |
| boards__creationMethod | TEXT | boards.creationMethod | boards.creationMethod | boards |
| boards__dateLastActivity | DATE | boards.dateLastActivity | boards.dateLastActivity | boards |
| boards__dateLastView | DATE | boards.dateLastView | boards.dateLastView | boards |
| boards__datePluginDisable | DATE | boards.datePluginDisable | boards.datePluginDisable | boards |
| boards__desc | TEXT | boards.desc | boards.desc | boards |
| boards__descData | TEXT | boards.descData | boards.descData | boards |
| boards__enterpriseOwned | BOOLEAN | boards.enterpriseOwned | boards.enterpriseOwned | boards |
| boards__id | TEXT | boards.id | boards.id | boards |
| boards__idBoardSource | TEXT | boards.idBoardSource | boards.idBoardSource | boards |
| boards__idEnterprise | TEXT | boards.idEnterprise | boards.idEnterprise | boards |
| boards__idOrganization | TEXT | boards.idOrganization | boards.idOrganization | boards |
| boards__idTags | OBJECT | boards.idTags | boards.idTags | boards |
| boards__ixUpdate | DATE | boards.ixUpdate | boards.ixUpdate | boards |
| boards__labelNames | OBJECT | boards.labelNames | boards.labelNames | boards |
| boards__limits | OBJECT | boards.limits | boards.limits | boards |
| boards__memberships | OBJECT | boards.memberships | boards.memberships | boards |
| boards__name | TEXT | boards.name | boards.name | boards |
| boards__pinned | BOOLEAN | boards.pinned | boards.pinned | boards |
| boards__powerUps | OBJECT | boards.powerUps | boards.powerUps | boards |
| boards__prefs | OBJECT | boards.prefs | boards.prefs | boards |
| boards__premiumFeatures | OBJECT | boards.premiumFeatures | boards.premiumFeatures | boards |
| boards__shortLink | TEXT | boards.shortLink | boards.shortLink | boards |
| boards__shortUrl | TEXT | boards.shortUrl | boards.shortUrl | boards |
| boards__starred | BOOLEAN | boards.starred | boards.starred | boards |
| boards__subscribed | BOOLEAN | boards.subscribed | boards.subscribed | boards |
| boards__templateGallery | TEXT | boards.templateGallery | boards.templateGallery | boards |
| boards__url | TEXT | boards.url | boards.url | boards |
| cards__badges | OBJECT | cards.badges | cards.badges | cards |
| cards__checkItemStates | OBJECT | cards.checkItemStates | cards.checkItemStates | cards |
| cards__closed | BOOLEAN | cards.closed | cards.closed | cards |
| cards__cover | OBJECT | cards.cover | cards.cover | cards |
| cards__customFieldItems | OBJECT | cards.customFieldItems | cards.customFieldItems | cards |
| cards__dateLastActivity | DATE | cards.dateLastActivity | cards.dateLastActivity | cards |
| cards__desc | TEXT | cards.desc | cards.desc | cards |
| cards__descData | OBJECT | cards.descData | cards.descData | cards |
| cards__due | TEXT | cards.due | cards.due | cards |
| cards__dueComplete | BOOLEAN | cards.dueComplete | cards.dueComplete | cards |
| cards__dueReminder | TEXT | cards.dueReminder | cards.dueReminder | cards |
| cards__id | TEXT | cards.id | cards.id | cards |
| cards__idAttachmentCover | TEXT | cards.idAttachmentCover | cards.idAttachmentCover | cards |
| cards__idBoard | TEXT | cards.idBoard | cards.idBoard | cards |
| cards__idChecklists | OBJECT | cards.idChecklists | cards.idChecklists | cards |
| cards__idLabels | OBJECT | cards.idLabels | cards.idLabels | cards |
| cards__idList | TEXT | cards.idList | cards.idList | cards |
| cards__idMembers | OBJECT | cards.idMembers | cards.idMembers | cards |
| cards__idMembersVoted | OBJECT | cards.idMembersVoted | cards.idMembersVoted | cards |
| cards__idShort | NUMERIC | cards.idShort | cards.idShort | cards |
| cards__isTemplate | BOOLEAN | cards.isTemplate | cards.isTemplate | cards |
| cards__labels | OBJECT | cards.labels | cards.labels | cards |
| cards__manualCoverAttachment | BOOLEAN | cards.manualCoverAttachment | cards.manualCoverAttachment | cards |
| cards__name | TEXT | cards.name | cards.name | cards |
| cards__pos | NUMERIC | cards.pos | cards.pos | cards |
| cards__shortLink | TEXT | cards.shortLink | cards.shortLink | cards |
| cards__shortUrl | TEXT | cards.shortUrl | cards.shortUrl | cards |
| cards__start | TEXT | cards.start | cards.start | cards |
| cards__subscribed | BOOLEAN | cards.subscribed | cards.subscribed | cards |
| cards__url | TEXT | cards.url | cards.url | cards |
| checklists__badges | OBJECT | checklists.badges | checklists.badges | checklists |
| checklists__checkItemStates | TEXT | checklists.checkItemStates | checklists.checkItemStates | checklists |
| checklists__checkItems | OBJECT | checklists.checkItems | checklists.checkItems | checklists |
| checklists__closed | BOOLEAN | checklists.closed | checklists.closed | checklists |
| checklists__cover | OBJECT | checklists.cover | checklists.cover | checklists |
| checklists__creationMethod | TEXT | checklists.creationMethod | checklists.creationMethod | checklists |
| checklists__data | OBJECT | checklists.data | checklists.data | checklists |
| checklists__date | DATE | checklists.date | checklists.date | checklists |
| checklists__dateLastActivity | DATE | checklists.dateLastActivity | checklists.dateLastActivity | checklists |
| checklists__dateLastView | DATE | checklists.dateLastView | checklists.dateLastView | checklists |
| checklists__datePluginDisable | DATE | checklists.datePluginDisable | checklists.datePluginDisable | checklists |
| checklists__desc | TEXT | checklists.desc | checklists.desc | checklists |
| checklists__descData | TEXT | checklists.descData | checklists.descData | checklists |
| checklists__due | TEXT | checklists.due | checklists.due | checklists |
| checklists__dueComplete | BOOLEAN | checklists.dueComplete | checklists.dueComplete | checklists |
| checklists__dueReminder | TEXT | checklists.dueReminder | checklists.dueReminder | checklists |
| checklists__enterpriseOwned | BOOLEAN | checklists.enterpriseOwned | checklists.enterpriseOwned | checklists |
| checklists__fullName | TEXT | checklists.fullName | checklists.fullName | checklists |
| checklists__id | TEXT | checklists.id | checklists.id | checklists |
| checklists__idAttachmentCover | TEXT | checklists.idAttachmentCover | checklists.idAttachmentCover | checklists |
| checklists__idBoard | TEXT | checklists.idBoard | checklists.idBoard | checklists |
| checklists__idBoardSource | TEXT | checklists.idBoardSource | checklists.idBoardSource | checklists |
| checklists__idCard | TEXT | checklists.idCard | checklists.idCard | checklists |
| checklists__idChecklists | OBJECT | checklists.idChecklists | checklists.idChecklists | checklists |
| checklists__idEnterprise | TEXT | checklists.idEnterprise | checklists.idEnterprise | checklists |
| checklists__idList | TEXT | checklists.idList | checklists.idList | checklists |
| checklists__idMemberCreator | TEXT | checklists.idMemberCreator | checklists.idMemberCreator | checklists |
| checklists__idOrganization | TEXT | checklists.idOrganization | checklists.idOrganization | checklists |
| checklists__idShort | NUMERIC | checklists.idShort | checklists.idShort | checklists |
| checklists__isTemplate | BOOLEAN | checklists.isTemplate | checklists.isTemplate | checklists |
| checklists__ixUpdate | TEXT | checklists.ixUpdate | checklists.ixUpdate | checklists |
| checklists__labelNames | OBJECT | checklists.labelNames | checklists.labelNames | checklists |
| checklists__limits | OBJECT | checklists.limits | checklists.limits | checklists |
| checklists__manualCoverAttachment | BOOLEAN | checklists.manualCoverAttachment | checklists.manualCoverAttachment | checklists |
| checklists__memberCreator | OBJECT | checklists.memberCreator | checklists.memberCreator | checklists |
| checklists__memberships | OBJECT | checklists.memberships | checklists.memberships | checklists |
| checklists__name | TEXT | checklists.name | checklists.name | checklists |
| checklists__pinned | TEXT | checklists.pinned | checklists.pinned | checklists |
| checklists__pos | NUMERIC | checklists.pos | checklists.pos | checklists |
| checklists__prefs | OBJECT | checklists.prefs | checklists.prefs | checklists |
| checklists__shortLink | TEXT | checklists.shortLink | checklists.shortLink | checklists |
| checklists__shortUrl | TEXT | checklists.shortUrl | checklists.shortUrl | checklists |
| checklists__softLimit | TEXT | checklists.softLimit | checklists.softLimit | checklists |
| checklists__starred | BOOLEAN | checklists.starred | checklists.starred | checklists |
| checklists__subscribed | BOOLEAN | checklists.subscribed | checklists.subscribed | checklists |
| checklists__templateGallery | TEXT | checklists.templateGallery | checklists.templateGallery | checklists |
| checklists__type | TEXT | checklists.type | checklists.type | checklists |
| checklists__url | TEXT | checklists.url | checklists.url | checklists |
| checklists__username | TEXT | checklists.username | checklists.username | checklists |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| lists__closed | BOOLEAN | lists.closed | lists.closed | lists |
| lists__id | TEXT | lists.id | lists.id | lists |
| lists__idBoard | TEXT | lists.idBoard | lists.idBoard | lists |
| lists__name | TEXT | lists.name | lists.name | lists |
| lists__pos | NUMERIC | lists.pos | lists.pos | lists |
| lists__softLimit | NUMERIC | lists.softLimit | lists.softLimit | lists |
| lists__subscribed | BOOLEAN | lists.subscribed | lists.subscribed | lists |
| organizations__activeBillableMemberCount | NUMERIC | organizations.activeBillableMemberCount | organizations.activeBillableMemberCount | organizations |
| organizations__billableCollaboratorCount | NUMERIC | organizations.billableCollaboratorCount | organizations.billableCollaboratorCount | organizations |
| organizations__billableMemberCount | NUMERIC | organizations.billableMemberCount | organizations.billableMemberCount | organizations |
| organizations__credits | OBJECT | organizations.credits | organizations.credits | organizations |
| organizations__desc | TEXT | organizations.desc | organizations.desc | organizations |
| organizations__descData | OBJECT | organizations.descData | organizations.descData | organizations |
| organizations__displayName | TEXT | organizations.displayName | organizations.displayName | organizations |
| organizations__domainName | TEXT | organizations.domainName | organizations.domainName | organizations |
| organizations__enterpriseJoinRequest | OBJECT | organizations.enterpriseJoinRequest | organizations.enterpriseJoinRequest | organizations |
| organizations__id | TEXT | organizations.id | organizations.id | organizations |
| organizations__idBoards | OBJECT | organizations.idBoards | organizations.idBoards | organizations |
| organizations__idMemberCreator | TEXT | organizations.idMemberCreator | organizations.idMemberCreator | organizations |
| organizations__invitations | OBJECT | organizations.invitations | organizations.invitations | organizations |
| organizations__invited | BOOLEAN | organizations.invited | organizations.invited | organizations |
| organizations__ixUpdate | TEXT | organizations.ixUpdate | organizations.ixUpdate | organizations |
| organizations__limits | OBJECT | organizations.limits | organizations.limits | organizations |
| organizations__membersCount | NUMERIC | organizations.membersCount | organizations.membersCount | organizations |
| organizations__memberships | OBJECT | organizations.memberships | organizations.memberships | organizations |
| organizations__name | TEXT | organizations.name | organizations.name | organizations |
| organizations__newLicenseInviteRestrict | TEXT | organizations.newLicenseInviteRestrict | organizations.newLicenseInviteRestrict | organizations |
| organizations__newLicenseInviteRestrictUrl | TEXT | organizations.newLicenseInviteRestrictUrl | organizations.newLicenseInviteRestrictUrl | organizations |
| organizations__powerUps | OBJECT | organizations.powerUps | organizations.powerUps | organizations |
| organizations__prefs | OBJECT | organizations.prefs | organizations.prefs | organizations |
| organizations__premiumFeatures | OBJECT | organizations.premiumFeatures | organizations.premiumFeatures | organizations |
| organizations__products | OBJECT | organizations.products | organizations.products | organizations |
| organizations__promotions | OBJECT | organizations.promotions | organizations.promotions | organizations |
| organizations__url | TEXT | organizations.url | organizations.url | organizations |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| users__boardId | TEXT | users.boardId | users.boardId | users |
| users__fullName | TEXT | users.fullName | users.fullName | users |
| users__id | TEXT | users.id | users.id | users |
| users__username | TEXT | users.username | users.username | users |