Windsor brings all your Wrike data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Wrike Field Reference
Fields
ID | Type | Name | Description | Reports |
---|---|---|---|---|
comments__authorid | TEXT | comments.authorId | comments.authorId | comments |
comments__createddate | TEXT | comments.createdDate | comments.createdDate | comments |
comments__id | TEXT | comments.id | comments.id | comments |
comments__taskid | TEXT | comments.taskId | comments.taskId | comments |
comments__text | TEXT | comments.text | comments.text | comments |
comments__updateddate | TEXT | comments.updatedDate | comments.updatedDate | comments |
contacts__avatarurl | TEXT | contacts.avatarUrl | contacts.avatarUrl | contacts |
contacts__companyname | TEXT | contacts.companyName | contacts.companyName | contacts |
contacts__deleted | BOOLEAN | contacts.deleted | contacts.deleted | contacts |
contacts__firstname | TEXT | contacts.firstName | contacts.firstName | contacts |
contacts__id | TEXT | contacts.id | contacts.id | contacts |
contacts__lastname | TEXT | contacts.lastName | contacts.lastName | contacts |
contacts__locale | TEXT | contacts.locale | contacts.locale | contacts |
contacts__me | BOOLEAN | contacts.me | contacts.me | contacts |
contacts__memberids | OBJECT | contacts.memberIds | contacts.memberIds | contacts |
contacts__myteam | BOOLEAN | contacts.myTeam | contacts.myTeam | contacts |
contacts__phone | TEXT | contacts.phone | contacts.phone | contacts |
contacts__profiles | OBJECT | contacts.profiles | contacts.profiles | contacts |
contacts__timezone | TEXT | contacts.timezone | contacts.timezone | contacts |
contacts__title | TEXT | contacts.title | contacts.title | contacts |
contacts__type | TEXT | contacts.type | contacts.type | contacts |
customfields__accountid | TEXT | customfields.accountId | customfields.accountId | customfields |
customfields__id | TEXT | customfields.id | customfields.id | customfields |
customfields__settings | OBJECT | customfields.settings | customfields.settings | customfields |
customfields__sharedids | OBJECT | customfields.sharedIds | customfields.sharedIds | customfields |
customfields__spaceid | TEXT | customfields.spaceId | customfields.spaceId | customfields |
customfields__title | TEXT | customfields.title | customfields.title | customfields |
customfields__type | TEXT | customfields.type | customfields.type | customfields |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
folders__childids | OBJECT | folders.childIds | folders.childIds | folders |
folders__createddate | TEXT | folders.createdDate | folders.createdDate | folders |
folders__id | TEXT | folders.id | folders.id | folders |
folders__project | OBJECT | folders.project | folders.project | folders |
folders__scope | TEXT | folders.scope | folders.scope | folders |
folders__space | BOOLEAN | folders.space | folders.space | folders |
folders__title | TEXT | folders.title | folders.title | folders |
source | TEXT | Source | The name of the Windsor connector returning the row | |
tasks__accountid | TEXT | tasks.accountId | tasks.accountId | tasks |
tasks__authorids | OBJECT | tasks.authorIds | tasks.authorIds | tasks |
tasks__briefdescription | TEXT | tasks.briefDescription | tasks.briefDescription | tasks |
tasks__completeddate | TEXT | tasks.completedDate | tasks.completedDate | tasks |
tasks__createddate | TEXT | tasks.createdDate | tasks.createdDate | tasks |
tasks__customfields | OBJECT | tasks.customFields | tasks.customFields | tasks |
tasks__customstatusid | TEXT | tasks.customStatusId | tasks.customStatusId | tasks |
tasks__dates | OBJECT | tasks.dates | tasks.dates | tasks |
tasks__description | TEXT | tasks.description | tasks.description | tasks |
tasks__id | TEXT | tasks.id | tasks.id | tasks |
tasks__importance | TEXT | tasks.importance | tasks.importance | tasks |
tasks__parentids | OBJECT | tasks.parentIds | tasks.parentIds | tasks |
tasks__permalink | TEXT | tasks.permalink | tasks.permalink | tasks |
tasks__priority | TEXT | tasks.priority | tasks.priority | tasks |
tasks__responsibleids | OBJECT | tasks.responsibleIds | tasks.responsibleIds | tasks |
tasks__scope | TEXT | tasks.scope | tasks.scope | tasks |
tasks__status | TEXT | tasks.status | tasks.status | tasks |
tasks__supertaskids | OBJECT | tasks.superTaskIds | tasks.superTaskIds | tasks |
tasks__title | TEXT | tasks.title | tasks.title | tasks |
tasks__updateddate | TEXT | tasks.updatedDate | tasks.updatedDate | tasks |
today | DATE | Today | Today's date | |
workflows__customstatuses | OBJECT | workflows.customStatuses | workflows.customStatuses | workflows |
BOOLEAN | workflows.hidden | workflows.hidden | workflows | |
workflows__id | TEXT | workflows.id | workflows.id | workflows |
workflows__name | TEXT | workflows.name | workflows.name | workflows |
workflows__standard | BOOLEAN | workflows.standard | workflows.standard | workflows |
workflows__title | TEXT | workflows.title | workflows.title | workflows |